ASP. NET database operation class instance

This article illustrates the ASP. NET database operation class. Share it for your reference, as follows:

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 description of 
  /// </summary>
  public class SqlServerDataBase
  {
    private string strError = null;
    private int intCount = 0;
    public SqlServerDataBase()
    {
      //
      // TODO:  Add constructor logic here 
      //
    }
    /// <summary>
    ///  Expose methods DBConn Returns the database connection 
    /// </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>
    ///  Expose properties ErrorMessage Returns an error message 
    /// </summary>
    public string ErrorMessage
    {
      get
      {
        return strError;
      }
    }
    /// <summary>
    ///  Retrieve data from the database according to the query statement 
    /// </summary>
    /// <param name="strSelect"> Query statement </param>
    /// <param name="SqlConn"> Database connection </param>
    /// <returns> Return if there is data DataSet Object, otherwise return the null</returns>
    public DataSet Select(string SelectString, SqlConnection sqlConn)
    {
      strError = "";
      SqlConnection conn;
      if (sqlConn == null)
      {
        conn = DBconn();
      }
      else
      {
        conn = sqlConn;
      }
      try
      {
        // If the current state of the database connection is closed, open the connection 
        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 = " Data retrieval failed: " + e.Message;
        return null;
      }
      finally
      {
        if (conn.State != ConnectionState.Closed)
        {
          conn.Close();
        }
      }
    }
    /// <summary>
    ///  Update the database 
    /// </summary>
    /// <param name="UpdateString">Update Sql Statement </param>
    /// <param name="SqlConn"> Database connection </param>
    /// <returns> Successful update returns true</returns>
    public bool Update(string UpdateString, SqlConnection SqlConn)
    {
      return udiDataBase(UpdateString, SqlConn);
    }
    /// <summary>
    ///  Delete data from a database 
    /// </summary>
    /// <param name="DeleteString">Delete Sql Statement </param>
    /// <param name="SqlConn"> Database connection </param>
    /// <returns> Delete successfully returned true</returns>
    public bool Delete(string DeleteString, SqlConnection SqlConn)
    {
      return udiDataBase(DeleteString, SqlConn);
    }
    /// <summary>
    ///  Insert data into a database 
    /// </summary>
    /// <param name="InsertString">Insert Sql Statement </param>
    /// <param name="SqlConn"> Database connection </param>
    /// <returns> Successful insertion returns true</returns>
    public bool Insert(string InsertString, SqlConnection SqlConn)
    {
      return udiDataBase(InsertString, SqlConn);
    }
    /// <summary>
    ///  According to Sql Statement to update the database 
    /// </summary>
    /// <param name="UDIString"> Update statement </param>
    /// <param name="SqlConn"> Database connection </param>
    /// <returns> If the update is successful, return 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 = " Failed to update database: " + e.Message;
        return false;
      }
      finally
      {
        if (conn.State != ConnectionState.Closed)
        {
          conn.Close();
        }
      }
    }
  }
}

For more readers interested in asp. net, please check the topics of this site: "asp. net Optimization Skills Summary", "asp. net String Operation Skills Summary", "asp. net Operation XML Skills Summary", "asp. net File Operation Skills Summary", "asp. net ajax Skills Summary" and "asp. net Cache Operation Skills Summary".

I hope this article is helpful to everyone's asp. net programming.