更新记录时出错!郁闷!帮忙看一下!谢
gj121 2004-11-20 08:12:11 OleDbConnection Cnn=new OleDbConnection("Provider=SQLOLEDB;Persist Security Info=False;User ID=sa;Initial Catalog=school;Data Source=LocalHost;Password=");
Cnn.Open();
OleDbDataAdapter Ada=new OleDbDataAdapter("Select * From student",Cnn);
DataSet DS=new DataSet();
Ada.Fill(DS,"student");
DataRow DR=DS.Tables["student"].Rows.Find("200101");
DR[1]="陈琳";
OleDbCommandBuilder CB=new OleDbCommandBuilder(Ada);
Ada.UpdateCommand=CB.GetUpdateCommand();
Ada.Update(DS,"student");
DS.AcceptChanges();
Cnn.Close();
运行时提示表没有主键,可我数据库中的表设了主键啊!
太郁闷啦!这么简单的问题都有问题!
关键是DataRow DR=DS.Tables["student"].Rows.Find("200101");
这一条不通过!请兄弟帮帮忙!