语句:
OleDbCommandBuilder thisComm = new OleDbCommandBuilder( thisAdapter );
只是简单的根据thisAdapter的SelectCommand生成了UpdateCommand、DeleteCommand、InsertCommand,并没有连接到thisAdapter,所以当你调用:
thisAdapter.Update( thisDataSet.Tables[0] );
的时候,什么都不会发生。解决:thisAdapter.UpdateCommand=thisComm.GetUpdateCommand();
thisAdapter.DeleteCommand=thisComm.GetDeleteCommand();
thisAdapter.InsertCommand=thisComm.GetUpdateCommand();上面代码中可能调用方法或属性有误,编译时纠正。
OleDbCommandBuilder thisComm = new OleDbCommandBuilder( thisAdapter );
只是简单的根据thisAdapter的SelectCommand生成了UpdateCommand、DeleteCommand、InsertCommand,并没有连接到thisAdapter,所以当你调用:
thisAdapter.Update( thisDataSet.Tables[0] );
的时候,什么都不会发生。解决:thisAdapter.UpdateCommand=thisComm.GetUpdateCommand();
thisAdapter.DeleteCommand=thisComm.GetDeleteCommand();
thisAdapter.InsertCommand=thisComm.GetUpdateCommand();上面代码中可能调用方法或属性有误,编译时纠正。
解决方案 »
- 哪位大侠帮我解决!
- c# winform 关于 System.Threading.Timer的问题?????谢谢!
- C#中如何实现qq登陆界面中的密码框中的点
- 为什么VS.Net2005创建的网站项目解决方案非得都保存在默认路径下???
- 问个问题人月计算方法顺便散点分
- 关于case
- 严重请求,各位高手解决 二进制数据的读取、更新和重复写入
- winforms与sqlserver打包问题
- windows 系统服务中如何声明全局dataset
- 继承2个接口,这2个接口中都有一个first()方法,怎么区分
- 用ADO.NET在Oracle表中插入记录后如何返回自增主键值?
- 如何禁用ctrl+alt+del键和alt+tab键和ctrl+shift+esc键??
// string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\datalib.mdb;Mode=Share Deny None";
// string strComm = "select * from [user]";
// DataSet thisDataSet = new DataSet();
// OleDbConnection thisConn = new OleDbConnection( strConn );
// OleDbDataAdapter thisAdapter = new OleDbDataAdapter( strComm, thisConn);
// OleDbCommandBuilder thisComm = new OleDbCommandBuilder( thisAdapter );
// //select
// OleDbCommand sComm = new OleDbCommand("select * from [user]",thisConn );
// thisAdapter.SelectCommand = sComm;
// //insert
// sComm = new OleDbCommand("insert into [user] (ID,name) values (@ID,@name)",thisConn);
// sComm.Parameters.Add("@ID",OleDbType.Integer,5,"ID" );
// sComm.Parameters.Add("@name",OleDbType.VarChar, 15,"name");
// thisAdapter.InsertCommand = sComm;
//
// //update
// sComm = new OleDbCommand("update [user] set name = @name",thisConn);
// sComm.Parameters.Add( "@name",OleDbType.VarChar,15,"name");
// thisAdapter.UpdateCommand = sComm;
//
//
//
//
//
// try
// {
// thisConn.Open();
// thisAdapter.Fill( thisDataSet,"user" );
// this.dataGrid1.DataSource = thisDataSet.Tables[0];
//// DataRow thisRow = thisDataSet.Tables["user"].NewRow();
//// thisRow["ID"] = 19;
//// thisRow["name"] = "fqang";
//// thisDataSet.Tables[0].Rows.Add(thisRow);
//
//
//
// thisAdapter.Update( thisDataSet.Tables[0] );
//
//
//
//
// }
// catch ( Exception ee )
// {
// MessageBox.Show(ee.ToString());
// }
//
// thisConn.Close();