我有一个dataGrid控件,和三个按钮
我已经把数据再dataGrid中显示出来,现在我想再dataGrit中加一条记录,一点button就会保存
我再button_click中的代码
OleDbConnection ass = new OleDbConnection();
ass.ConnectionString =@"Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data
Source=E:\shiyan\PersonInfo.mdb";
ass.open();
OleDbCommand dd = new OleDbCommand("select * from AddressBook",ass);
dd.CommandTimeout = 30;
OleDbDataAdapter crDa = new OleDbDataAdapter();
crDa.SelectCommand = dd
DataSet crDS = new DataSet();
crDa.Fill(crDS,"AddressBook");
crDa.Update(crDs,"AddressBook");
this.dataGrid1.DataSource =crDS.Tables["AddressBook"];
ass.Close ();
我代码哪里有错误呢?
出不来我想要的效果。
请大家帮帮我,谢谢!
我已经把数据再dataGrid中显示出来,现在我想再dataGrit中加一条记录,一点button就会保存
我再button_click中的代码
OleDbConnection ass = new OleDbConnection();
ass.ConnectionString =@"Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data
Source=E:\shiyan\PersonInfo.mdb";
ass.open();
OleDbCommand dd = new OleDbCommand("select * from AddressBook",ass);
dd.CommandTimeout = 30;
OleDbDataAdapter crDa = new OleDbDataAdapter();
crDa.SelectCommand = dd
DataSet crDS = new DataSet();
crDa.Fill(crDS,"AddressBook");
crDa.Update(crDs,"AddressBook");
this.dataGrid1.DataSource =crDS.Tables["AddressBook"];
ass.Close ();
我代码哪里有错误呢?
出不来我想要的效果。
请大家帮帮我,谢谢!
ass.ConnectionString =@"Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data
Source=E:\shiyan\PersonInfo.mdb";
ass.open();
OleDbCommand dd = new OleDbCommand("select * from AddressBook",ass);
dd.CommandTimeout = 30;
OleDbDataAdapter crDa = new OleDbDataAdapter();
crDa.SelectCommand = dd
DataSet crDS = new DataSet();
crDa.Fill(crDS,"AddressBook");
在这里进进行插入操作
crDa.Update(crDs,"AddressBook");
this.dataGrid1.DataSource =crDS.Tables["AddressBook"];
ass.Close ();
是insert吗?
您可以帮我提示一句嘛?
拜托啦
我应该怎么做呢?
谢谢