//要传一个DataSet,和若干个表

         /// <summary>

         /// 更新数据库

         /// </summary>

         /// <param name="dataSet">数据集</param>

         /// <param name="tableName">数据表</param>

         /// <returns>-1：失败；-2：无可更新数据；其他：成功</returns>

         public int UpdateDatabase(DataSet dataSet,params String[] tableName)

         {

             int saveCount = -;

             //结束编辑

             for (int i = ; i < tableName.Length; ++i)

             {

                 this.BindingContext[dataSet, tableName[i]].EndCurrentEdit();

             }

             //检查变更//用一个东西存储所做的更改

             DataSet changes = (DataSet)dataSet.GetChanges();

             if (changes != null)

             {

                 for (int j = ; j < tableName.Length; ++j)

                 {

                     //生成更新语句

                     string sqltext = "Select * From " + tableName[j] + " ";

                     //新建 一个连接

                     using (SqlConnection con = new SqlConnection(IConnectionString))     //这里要换成自己的连接字符串

                     {

                         //打开连接

                         con.Open();

                         //新建DA

                         using (SqlDataAdapter oDA = new SqlDataAdapter(sqltext, con))

                         {

                             try

                             {

                                 //生成更新语句

                                 SqlCommandBuilder sqlBuilder = new SqlCommandBuilder(oDA);

                                 //更新数据库

                                 saveCount += oDA.Update(changes, tableName[j]);

                             }

                             catch

                             { throw; }

                         }

                     }

                 }

                 //dataSet.Merge(changes );    //VS2015更新完成后会自动刷新数据，如果合并后会出现重复记录手动刷新后消失

                 dataSet.AcceptChanges();

             }

             else

             {

                 saveCount = -;

             }

             return saveCount;

         }