准备工作,声明窗体级全局变量:
private DataSet ds = new DataSet();
private SqlDataAdapter sda = new SqlDataAdapter();
private SqlConnection myConn = new SqlConnection();
1、利用SqlCommandBuilder
SqlCommandBuilder sb = new SqlCommandBuilder(sda);
sda.Update(ds.Tables[0]);
ds.Tables[0].AcceptChanges();
2、指定UpdateCommand
SqlParameter param = new SqlParameter();
string strSql = " update Good_PrtyInfo set maxstcs=@maxstcs , minstcs=@minstcs where 1=1 and GoodID=@GoodID ";
sda.UpdateCommand = new SqlCommand(strSql, myConn);
param = sda.UpdateCommand.Parameters.Add("@maxstcs", SqlDbType.VarChar, 50, "maxstcs");
param.SourceVersion = DataRowVersion.Current;
param = sda.UpdateCommand.Parameters.Add("@minstcs", SqlDbType.VarChar, 50, "minstcs");
param.SourceVersion = DataRowVersion.Current;
//param = myDA.UpdateCommand.Parameters.Add("@DeptID", SqlDbType.VarChar, 50, "DeptID");
//param.SourceVersion = DataRowVersion.Current;
param = sda.UpdateCommand.Parameters.Add("@GoodID", SqlDbType.VarChar, 50, "GoodID");
param.SourceVersion = DataRowVersion.Original;
sda.UpdateCommand.UpdatedRowSource = UpdateRowSource.None;
sda.UpdateBatchSize = 10;
//SqlCommandBuilder sb = new SqlCommandBuilder(sda);
sda.Update(ds.Tables[0]);
ds.Tables[0].AcceptChanges();