DataGridView的绑定
2007-04-09 17:02 清炒白菜 阅读(1883) 评论(3) 编辑 收藏 举报在ASP.NET里面用了DataGrid控件,设置动态绑定的方法,与以前的类似,直接把DataSet绑到控件上。
但是在WinForm里面,用的是BindingSource对象来绑定数据。
private void btnTestDataGrid_Click(object sender, EventArgs e)
{
DataSet result = new DataSet();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["DataBaseConnection"]))
{
conn.Open();
SqlCommand cmd = new SqlCommand("select * from CorporationView where factionID = 500020", conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(result, "Corporation");
}
BindingSource bs = new BindingSource();
bs.DataMember = "Corporation";
bs.DataSource = result;
this.dataGridView1.DataSource = bs;
}
{
DataSet result = new DataSet();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["DataBaseConnection"]))
{
conn.Open();
SqlCommand cmd = new SqlCommand("select * from CorporationView where factionID = 500020", conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(result, "Corporation");
}
BindingSource bs = new BindingSource();
bs.DataMember = "Corporation";
bs.DataSource = result;
this.dataGridView1.DataSource = bs;
}
bs.DataMember = "Corporation";
bs.DataSource = result;
可以改写成:
bs.DataSource = result.Tables[0];