oledbdataadapter1填充了一个dataset1,
DataTable dt = dataset.Table[0].Select("...");dt = dt.Select("...");多次select后,在又给dt.rows[][]赋值后最后可以用
oledbdataadapter.Update(dt)讲dt写数据库吗?
DataTable dt = dataset.Table[0].Select("...");dt = dt.Select("...");多次select后,在又给dt.rows[][]赋值后最后可以用
oledbdataadapter.Update(dt)讲dt写数据库吗?
oledbcommandbuilder更新数据库
oledbcommandbuilder更新数据库
这样样写
DataTable table = dt.Tables[0];
bindingSource1.DataSource = table;
dataGridView1.DataSource = bindingSource1;
datagridview1的数据修改了,dt的数据会相应的更改吗?
{
DataTable data = new DataTable();
data.Columns.Add("name");
data.Columns.Add("class");
data.Rows.Add(new object[] { "csdn", "A" });
data.Rows.Add(new object[] { "javaeye", "A" });
data.AcceptChanges(); bindingSource1.DataSource = data;
this.dataGridView1.DataSource = bindingSource1.DataSource; } private void button1_Click(object sender, EventArgs e)
{
DataTable data = (DataTable)bindingSource1.DataSource;
DataTable changedData = data.GetChanges();
if (changedData != null && changedData.Rows.Count > 0)
MessageBox.Show(changedData.Rows.Count.ToString()); }