【文件属性】:
文件名称:DataGridview绑定
文件大小:1KB
文件格式:TXT
更新时间:2012-11-21 13:18:51
DataGridview绑定
using (SqlConnection connection = new SqlConnection(@"server=.;database=gr;user id=sa;pwd="))
{
//SqlDataAdapter sda = new SqlDataAdapter("select * from customers", connection);
//DataSet ds = new DataSet();
//sda.Fill(ds);
BindingSource bindingSource1 = new BindingSource();
connection.Open();
SqlCommand cmd = new SqlCommand("select * from T1", connection);
SqlDataReader sdr = cmd.ExecuteReader(CommandBehavior.Default);
if (sdr.Read())
{
bindingSource1.DataSource = sdr;
GridView1.DataSource = sdr;
GridView1.DataSource = bindingSource1;
}
}