添加一个名为Detail的一个空表DataTable到DataSet，通过getPackListDet存储过程得到数据，一条一条添加到Detail中，
添加的行状态都为Added，通过SqlDataAdapter批量更新到数据库。查询数据库发现数据未添加成功。

                ds.Tables.Add(CPublicDB.CDBHelper.GetDBInstance.GetDataTableDirectly("select * from PackListDet where PackBoxNo=''", "Detail"));

                DataTable dt = CPublicDB.CDBHelper.GetDBInstance.GetDataTableDirectly("exec getPackListDet '" + this.txtPackNo.Text + "'");

                foreach (DataRow dr in dt.Rows)

                {

                    object[] objs = new object[13];

                    objs[0] = 0;

                    objs[1] = dr["PackListNo"].ToString();

                    objs[2] = dr["CtnId"].ToString();

                    objs[3] = dr["FrCtn"].ToString();

                    objs[4] = dr["ToCtn"].ToString();

                    objs[5] = dr["CtnQty"].ToString();

                    objs[6] = dr["StyleNo"].ToString();

                    objs[7] = dr["StyleNo"].ToString();

                    objs[8] = dr["Color"].ToString();

                    objs[9] = dr["Sizes"].ToString();

                    objs[10] = dr["SizeSeq"].ToString();

                    objs[11] = dr["Qty"].ToString();

                    objs[12] = "";

                    ds.Tables["Detail"].Rows.Add(objs);

                }

        public bool ExecuteBatchCommandBySQL(DataTable dt, string sSelectSql)

        {

            OpenCon();

            SqlDataAdapter sd = new SqlDataAdapter();

            sd.SelectCommand = new SqlCommand(sSelectSql, con);

            SqlCommandBuilder scb = new SqlCommandBuilder(sd);

            try

            {

                lock (this)

                {

                    sd.Update(dt);

                }

            }

            catch (Exception ex)

            {

                throw ex;

            }

            return true;

            //return ds; //数据集的行状态在更新后会都变为: UnChange,在这次更新后客户端要用返回的ds 

        }

                if (CPublicDB.CDBHelper.GetDBInstance.ExecuteBatchCommandBySQL(ds.Tables["Detail"], "select * from PackListDet"))

                {

                    MessageBox.Show("保存成功！");

                }

                else

                    MessageBox.Show("保存失败！");