110,536
社区成员
发帖
与我相关
我的任务
分享
using (OleDbConnection cCon = new OleDbConnection(con))
{
OleDbDataAdapter ada = new OleDbDataAdapter(string.Format(@"select * from [{0}]", mySet), cCon);
OleDbCommandBuilder cBu = new OleDbCommandBuilder(ada);
try
{
ada.Update(dt);
dt.AcceptChanges();
MessageBox.Show("数据保存完成!");
this.NavigatorSave.Enabled = false;
}
catch { MessageBox.Show("数据保存失败!"); }
}
我想请问的是这个更新过程是什么原理?更新的过程是什么样的?string.Format(@"select * from [{0}]", mySet)
如果我使用的是多个表查询的语句string.Format(@"select * from [{0}] inner join [{1}] on {0}.ID={1}.{0}ID",Table1,Table2)
是不是相同的更新过程呢?using (OleDbConnection conn = new OleDbConnection(con))
{
try
{
if (conn.State == ConnectionState.Closed) { conn.Open(); }
string sql = "select " +
"表1.姓名," +
"表1.性别," +
"表1.年龄," +
"表1.手机," +
"表1.邮箱," +
"表2.部门," +
"表2.职位," +
"表2.职责," +
"表2.备注" +
" from [表1] inner join [表2] on 表2.姓名=表1.姓名";
DataTable dt = new DataTable();
using (OleDbDataAdapter da = new OleDbDataAdapter(sql, conn))
{
da.Fill(dt);
}
this.dataGridView.AutoGenerateColumns = false;
this.dataGridView.DataSource = dt;
}
using (OleDbConnection cCon = new OleDbConnection(con))
{
string sql = "select " +
"表1.姓名," +
"表1.性别," +
"表1.年龄," +
"表1.手机," +
"表1.邮箱," +
"表2.部门," +
"表2.职位," +
"表2.职责," +
"表2.备注" +
" from [表1] inner join [表2] on 表2.姓名=表1.姓名";
OleDbDataAdapter da = new OleDbDataAdapter(sql, cCon);
OleDbCommandBuilder cBu = new OleDbCommandBuilder(da);
DataTable dt = this.dataGridView.DataSource as DataTable;
try
{
da.Update(dt);
dt.AcceptChanges();
MessageBox.Show("数据保存完成!");
}
DataTable dt = this.dataGridView.DataSource as DataTable;
你看能不能给