SqlDataAdapter1.Update(dataSet1,TableName);
之前加上一句:SqlCommandBuilder builder = new SqlCommandBuilder(SqlDataAdapter1);
//创建一个对象,来为SqlDataAdapter1创建更新需要的SQL Command
之前加上一句:SqlCommandBuilder builder = new SqlCommandBuilder(SqlDataAdapter1);
//创建一个对象,来为SqlDataAdapter1创建更新需要的SQL Command
更新需要updateCommand和insertCommand和deleteCommand
可以自己手工建立 ,也可以按照已有的SELECTCOMMAND的信息自动创建.
自动创建的方式参考上面的老兄写的代码.
SqlConnection myConn = new SqlConnection(myConnection);
SqlDataAdapter myDataAdapter = new SqlDataAdapter();
myDataAdapter.SelectCommand = new SqlCommand(mySelectQuery, myConn);
SqlCommandBuilder custCB = new SqlCommandBuilder(myDataAdapter); myConn.Open(); DataSet custDS = new DataSet();
myDataAdapter.Fill(custDS, "Customers"); //code to modify data in dataset here //Without the SqlCommandBuilder this line would fail
myDataAdapter.Update(custDS, "Customers"); myConn.Close(); return custDS;
}