我开始学习C#(SQL库)了数据类

using System;
using System.Data;
using System.Data.SqlClient; 
using System.Configuration;
using System.Web.UI.WebControls;
namespace ctest
 //科长-2006-07-write
{
 /// <summary>
 /// dbconn 的摘要说明。
 /// </summary>
 public class dbconn
 {  
/// <summary>
/// 返回一个AppSettings的值
/// </summary>
/// <param name="Appstr">AppSettingsr的名字</param>
/// <returns></returns>
  public static string GetApp(string Appstr)
        {
   return  ConfigurationSettings.AppSettings[Appstr];
  }
  /// <summary>
  /// 创建SQL连接
  /// </summary>
  public static SqlConnection  CreateSqlConnection()
  {
   SqlConnection myConnection = new SqlConnection( GetApp("ConnString"));
   myConnection.Open();
   return myConnection;
  }

  /// <summary>
  /// 执行SQL语句
  /// </summary>
  /// <param name="SQl">要执行的SQL语句</param>
  public static  void dosql(string strsql )
  {
   SqlConnection conn=CreateSqlConnection();
   SqlCommand myCommand=new SqlCommand(strsql,conn);
   myCommand.ExecuteNonQuery();
   conn.Close();
  }

/// <summary>
/// 更新和删除SQL语句
/// </summary>
/// <param name="sql">SQL语句</param>
/// <returns>BOOL是否执行成功</returns>
  public static bool ExecuteUpdate(string sql)
  {
   try
   {
    SqlCommand dCom=new SqlCommand();
    dCom.CommandText = sql;
    int flag = dCom.ExecuteNonQuery();
    if(flag != -1)
    {
     return true;
    }
    else
    {
     return false;
    }
   }
   catch//(Exception ex)
   {
    return false;
   }
  }

  /// <summary>
  /// 传入SQL语句，返回一个DataSet类型的数据表集合
  /// </summary>
  /// <param name="strsql">SQL语句字符串</param>
  /// <returns>dataset</returns>
  public static DataSet GETdataset (string strsql)
  {
      SqlConnection conn=CreateSqlConnection();
   SqlDataAdapter dApter = new SqlDataAdapter(strsql,conn);   
   DataSet DS = new DataSet();
   dApter.Fill(DS);
   conn.Close();
   return DS;  
  }
 /// <summary>
 /// 传入SQL语句返回一个DataTable
 /// </summary>
 /// <param name="strsql">SQL语句</param>
 /// <returns></returns>
  public static  DataTable  GetDataTable(string strsql)
  {
   
   SqlConnection conn=CreateSqlConnection();
   SqlDataAdapter DataAdapter1 = new SqlDataAdapter(strsql, conn);
   DataSet DS=new DataSet();
   DataAdapter1.Fill(DS);
   conn.Close();
   return DS.Tables[0];
  }

/// <summary>
/// 传入SQL语句，DataGrid数据帮定
/// </summary>
/// <param name="intPageNumber">分页数</param>
/// <param name="DG_name">DataGrid名称</param>
/// <param name="strsql">SQL语句</param>
  public static  void   BindDataGrid (int intPageNumber,DataGrid DG_name,string strsql )
  {
   // ----------- 数据库连接 -----------   
   SqlConnection conn=CreateSqlConnection();
   /* // 方法一
    SqlCommand myCommand = new SqlCommand(SqlCmd, myConnection);
    SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter();
    sqlDataAdapter1.SelectCommand = myCommand;
    DataSet ds1= new DataSet();
    sqlDataAdapter1.SelectCommand.ExecuteNonQuery();
    sqlDataAdapter1.Fill(ds1);
    DataView source = new DataView(ds1.Tables[0]);
    DataGrid1.DataSource=source;
    DataGrid1.DataBind();
    myConnection.Close();
    */
   // 方法二
   SqlDataAdapter DataAdapter1 = new SqlDataAdapter(strsql, conn);
   DataSet ds  = new DataSet();
   DataAdapter1.Fill(ds);
   try
   {
    DataTable DT = ds.Tables[0];
    DG_name.DataSource = DT;
    /*-----------------------------------------
     * 翻页的时候要设置的就是下面这个属性
     * ----------------------------------------*/
    DG_name.CurrentPageIndex = intPageNumber;
    DG_name.DataBind();
   }
   catch (SqlException ex)
   {
     
   }
   finally
   {
    ds.Dispose();
    ds.Clear();
    DataAdapter1.Dispose();
    conn.Close();
   }
  }

 }
 
  

 

}