分享一個ASP.NET資料庫操作類的執行個體

這篇文章主要介紹了ASP.NET資料庫操作類,結合執行個體形式分析了asp.net基本的資料庫增刪改查操作封裝相關技巧,需要的朋友可以參考下

本文執行個體講述了ASP.NET資料庫操作類。分享給大家供大家參考，具體如下：

using System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;namespace Mysqlserver{  /// <summary>  /// SqlServerDataBase 的摘要說明  /// </summary>  public class SqlServerDataBase  {    private string strError = null;    private int intCount = 0;    public SqlServerDataBase()    {      //      // TODO: 在此處添加建構函式邏輯      //    }    /// <summary>    /// 公開方法DBConn，返回資料庫連接    /// </summary>    /// <returns></returns>    public SqlConnection DBconn()    {      string strConn = "Server=(local);Database=GlobalMeetings;Uid=sa;pwd=";      try      {        return new SqlConnection(strConn);      }      catch (Exception)      {        return null;      }    }    /// <summary>    /// 公開屬性ErrorMessage，返回錯誤資訊    /// </summary>    public string ErrorMessage    {      get      {        return strError;      }    }    /// <summary>    /// 根據查詢語句從資料庫檢索資料    /// </summary>    /// <param name="strSelect">查詢語句</param>    /// <param name="SqlConn">資料庫連接</param>    /// <returns>有資料則返回DataSet對象，否則返回null</returns>    public DataSet Select(string SelectString, SqlConnection sqlConn)    {      strError = "";      SqlConnection conn;      if (sqlConn == null)      {        conn = DBconn();      }      else      {        conn = sqlConn;      }      try      {        //若資料庫連接的目前狀態是關閉的，則開啟串連        if (conn.State == ConnectionState.Closed)        {          conn.Open();        }        SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter();        SqlCommand selectCommand = new SqlCommand(SelectString, conn);        selectCommand.CommandType = CommandType.Text;        mySqlDataAdapter.SelectCommand = selectCommand;        DataSet myDS = new DataSet();        mySqlDataAdapter.Fill(myDS);        return myDS;      }      catch (Exception e)      {        strError = "資料檢索失敗：" + e.Message;        return null;      }      finally      {        if (conn.State != ConnectionState.Closed)        {          conn.Close();        }      }    }    /// <summary>    /// 更新資料庫    /// </summary>    /// <param name="UpdateString">Update Sql語句</param>    /// <param name="SqlConn">資料庫連接</param>    /// <returns>更新成功返回true</returns>    public bool Update(string UpdateString, SqlConnection SqlConn)    {      return udiDataBase(UpdateString, SqlConn);    }    /// <summary>    /// 從資料庫中刪除資料    /// </summary>    /// <param name="DeleteString">Delete Sql語句</param>    /// <param name="SqlConn">資料庫連接</param>    /// <returns>刪除成功返回true</returns>    public bool Delete(string DeleteString, SqlConnection SqlConn)    {      return udiDataBase(DeleteString, SqlConn);    }    /// <summary>    /// 把資料插入資料庫    /// </summary>    /// <param name="InsertString">Insert Sql語句</param>    /// <param name="SqlConn">資料庫連接</param>    /// <returns>插入成功返回true</returns>    public bool Insert(string InsertString, SqlConnection SqlConn)    {      return udiDataBase(InsertString, SqlConn);    }    /// <summary>    /// 根據Sql語句更新資料庫    /// </summary>    /// <param name="UDIString">更新語句</param>    /// <param name="SqlConn">資料庫連接</param>    /// <returns>更新成功則返回true</returns>    public bool udiDataBase(string UDIString, SqlConnection SqlConn)    {      strError = "";      SqlConnection conn;      if (SqlConn == null)      {        conn = DBconn();      }      else      {        conn = SqlConn;      }      try      {        if (conn.State == ConnectionState.Closed)        {          conn.Open();        }        SqlCommand cmd = new SqlCommand(UDIString, conn);        cmd.CommandType = CommandType.Text;        intCount = cmd.ExecuteNonQuery();        return !(intCount < 1);      }      catch (Exception e)      {        strError = "更新資料庫失敗：" + e.Message;        return false;      }      finally      {        if (conn.State != ConnectionState.Closed)        {          conn.Close();        }      }    }  }}