更新数据库类.

using System;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;
namespace winApplication
{
     public class sqlAccess
     {
         //与SQL Server的连接字符串设置
         private string _connString;
         private string _strSql;
 
         private SqlCommandBuilder sqlCmdBuilder;
         private DataSet ds = new DataSet();
         private SqlDataAdapter da;
         public sqlAccess(string connString,string strSql)
         {
              this._connString=connString;
       this._strSql=strSql;
         }
 
         private SqlConnection GetConn()
         {
              try
              {
                   SqlConnection Connection = new SqlConnection(this._connString);
                   Connection.Open();
                   return Connection;
              }
              catch (Exception ex)
              {
                   MessageBox.Show(ex.Message,"数据库连接失败");
                   throw;
              }
         }
 
         //根据输入的SQL语句检索数据库数据
         public DataSet SelectDb(string strSql,string strTableName)
         {
              try
              {
        this._strSql = strSql;
        this.da = new SqlDataAdapter(this._strSql,this.GetConn());
        this.ds.Clear();
        this.da.Fill(ds,strTableName);
        return ds;//返回填充了数据的DataSet，其中数据表以strTableName给出的字符串命名
              }
              catch (Exception ex)
              {
                   MessageBox.Show(ex.Message,"数据库操作失败");
                   throw;
              }
         }
 
         //数据库数据更新(传DataSet和DataTable的对象)
         public DataSet UpdateDs(DataSet changedDs,string tableName)
         {
              try
              {
        this.da = new SqlDataAdapter(this._strSql,this.GetConn());
        this.sqlCmdBuilder = new SqlCommandBuilder(da);
        this.da.Update(changedDs,tableName);
        changedDs.AcceptChanges();
        return changedDs;//返回更新了的数据库表
              }
              catch (Exception ex) 
              { 
                   MessageBox.Show(ex.Message,"数据库更新失败");
                   throw;
              }
          }
      }
}