111,126
社区成员
发帖
与我相关
我的任务
分享System.Data.DataTable dt = (System.Data.DataTable)dgv_Data.DataSource;
string sql = "select MR_Name as 货料名称,MR_Model as 规格型号,MR_Unit as 单位,MR_Price as 单价 from MIS_MaterielRegiser";
oda = new OleDbDataAdapter(sql, ocnn);
ocb = new OleDbCommandBuilder(oda);//CommandBuilder对象能自动生成insert语句
ocb.QuotePrefix = "[";
ocb.QuoteSuffix = "]";
oda.Update(dt);