将dataGridView中的添加/删除等修改保存至数据库 ,支持多条操作，最后一次性保存

1、窗体级变量，准备工作

 

        MMS.Public.DbAccLibry.DbAccess myDbacc;

 

        <summary>
        /// 批量修改数据库交易对象
        /// </summary>
        private SqlDataAdapter myDAMult = new SqlDataAdapter();

        /// <summary>
        /// 批量修改记录集
        /// </summary>
        private DataSet myDsMult = new DataSet();
        /// <summary>
        /// 批量修改参数
        /// </summary>
        private SqlParameter myParmMult = new SqlParameter();

        /// <summary>
        /// 数据库连接交易对象
        /// </summary>
        private SqlConnection myConn;

 

        /// <summary>
        /// SQL构造对象
        /// </summary>
        ///private SqlCommandBuilder myMultCB; 如果没指定COMMAND，则需要，否则不需要，本DEMO不需要

 

2、加载填充

        /// <summary>
        /// 加载填充
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void myComBoxClient_OnSelectedIndexChanged(object sender, EventArgs e)
        {
            myDAMult = new SqlDataAdapter(" select ta.GoodID as 商品编码, tb.Defscancode as 商品条码,tb.GoodName as 商品名称,tb.Unit as 单位,tb.spec as 规格,ta.Clientid as 客户编号,ta.SupplyPric as 供应价格,ta.UserID as  系统操作员,ta.RepDate as 报价日期,tb.RetailPric as 零售价格,tb.WholeSalePric as 批发价格,tb.MemPric as 会员价格 from Bill_GoodRepPricInfo ta,jcv_GoodBaseInfo tb where ta.GoodID=tb.GoodID and   ta.clientid= @v_clientid   ", myConn);

            myDAMult.SelectCommand.Parameters.Add("@v_clientid", SqlDbType.VarChar, 80).Value =myComBoxClient.GetSelectID() ;

            if (myDsMult != null && myDsMult.Tables.Count != 0 && myDsMult.Tables[0].Rows.Count > 0)
            {