DataGridView里批量修改提交数据库方法

准备工作，声明窗体级全局变量：

        private DataSet ds = new DataSet();
        private SqlDataAdapter sda = new SqlDataAdapter();
        private SqlConnection myConn = new SqlConnection();

１、利用SqlCommandBuilder

      SqlCommandBuilder sb = new SqlCommandBuilder(sda);
      sda.Update(ds.Tables[0]);
      ds.Tables[0].AcceptChanges(); 

 

２、指定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();