SqlConnection thisConn = new SqlConnection("server=
CHINA-P82LHZ9IM;database=bank;uid=sa;pwd=hotechong");
SqlDataAdapter thisAdapter = new SqlDataAdapter("SELECT * FROM bank",thisConn);
DataSet thisDataSet = new DataSet();
thisAdapter.Fill(thisDataSet,"Bank");
Console.WriteLine(thisDataSet.Tables["Bank"].Rows[4]["client"];
Console.WriteLine();
thisDataSet.Tables["Bank"].Rows[4]["client"] = "冯陈良";
Console.WriteLine(thisDataSet.Tables["Bank"].Rows[4]["client"]);
//上面一切正常
//可是加了下面这句就出现异常了
thisAdapter.Update(thisDataSet,"Bank");异常是
System.InvalidOperationException:当传递具有已修改行的DataRow集合时,更新要求有效的UpdateCommand
CHINA-P82LHZ9IM;database=bank;uid=sa;pwd=hotechong");
SqlDataAdapter thisAdapter = new SqlDataAdapter("SELECT * FROM bank",thisConn);
DataSet thisDataSet = new DataSet();
thisAdapter.Fill(thisDataSet,"Bank");
Console.WriteLine(thisDataSet.Tables["Bank"].Rows[4]["client"];
Console.WriteLine();
thisDataSet.Tables["Bank"].Rows[4]["client"] = "冯陈良";
Console.WriteLine(thisDataSet.Tables["Bank"].Rows[4]["client"]);
//上面一切正常
//可是加了下面这句就出现异常了
thisAdapter.Update(thisDataSet,"Bank");异常是
System.InvalidOperationException:当传递具有已修改行的DataRow集合时,更新要求有效的UpdateCommand
SqlCommandBuilder scb=new SqlCommandBuilder(thisDataSet);
SqlCommandBuilder scb=new SqlCommandBuilder(thisDataSet);
///////////////////////////////////
应该是SqlCommandBuilder scb=new SqlCommandBuilder(thisAdapter);
thisAdapter.SelectCommand = new SqlCommand(更新语句, thisConn);
thisAdapter.DeleteCommand,
thisAdapter.InsertCommand,
具体看例子,
http://blog.csdn.net/zhzuo/archive/2004/08/06/67037.aspx
http://blog.csdn.net/zhzuo/archive/2005/01/03/238273.aspx