tableviewer setdata to html id,绑定DataTable的Datagridview如何更新

引用 4 楼 Z65443344 的回复:

自己试一下呗

既然单表查询好使了,多表查询有什么区别吗

如果不好使再纠结为什么

今天试了发现异常Dynamic SQL generation is not supported against multiple base tables.

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("数据保存完成！");

}