CommonClass

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;
public class CommonClass
{
  
    private static string  connectionString = string.Empty;

    #region Return connectionString and SqlConnection object
    public static string GetConnectionString()
    {
        return ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
    }

    public static SqlConnection GetConnection()
    {
        SqlConnection cn = null;
        if (cn == null)
        {
            cn = new SqlConnection(CommonClass.GetConnectionString());
        }
        return cn;
    }
    #endregion

    #region get dataset collection
    public static DataSet GetDataSet(string mySql)
    {
        //文章------------------------------------------
        connectionString = GetConnectionString();
        DataSet ds = new DataSet();
        try
        {
            SqlConnection connection = new SqlConnection(connectionString);
            SqlDataAdapter adapter = new SqlDataAdapter(mySql, connection);
            adapter.Fill(ds);
            connection.Close();
        }
        catch
        {
        }

        return ds;
    }
    #endregion

    public static void ExecuteQuery(string _sql)
    {
        using (SqlConnection connection = CommonClass.GetConnection())
        {
            SqlDataAdapter adapter = new SqlDataAdapter();
            connection.Open();

            SqlCommand command = new SqlCommand(_sql, connection);
            command.CommandType = CommandType.Text;
            int ReturnValue = command.ExecuteNonQuery();
            connection.Close();
        }
    }

    #region  defince enum of record status
    public enum OpectionType
        {
            Insert = 0,
            Update = 1,
            Delete = 2,
            SetInvalid = 3,
            Select = 4
        }

   #endregion

}