DBHelper

//引入命名空间

using System.Data;
using System.Data.SqlClient;

  namespace DBHelper
{
    public class DBHelper
    {
        //创建数据库通道地址
        static string connectionStr = "server=.;database=Test;uid=sa;pwd=123456";
        //实例化数据库通道对象
        static SqlConnection con = new SqlConnection(connectionStr);
        /// <summary>
        /// 打开数据库通道的方法
        /// </summary>
       public static void Open()
        {
            if (con.State==ConnectionState.Closed)
            {
                con.Open();
            }
        }
        /// <summary>
        /// 关闭数据库通道的方法
        /// </summary>
        public static void Close()
        {
            if (con.State == ConnectionState.Open)
            {
                con.Close();
            }
        }
        /// <summary>
        /// 增删改通用执行数据库命令的方法
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public static bool Excute(string sql)
        {
            try
            {
                //打开通道
                Open();
                //创建执行命令的对象
                SqlCommand com = new SqlCommand(sql, con);
                //执行命令返回结果
                if (com.ExecuteNonQuery() > 0)
                {
                    return true;
                }
            }
            catch (Exception)
            {

                Console.WriteLine("数据库操作异常");
            }
            finally
            {
                Close();

            }
            return false;
        }
        /// <summary>
        /// 执行数据库命令后返回一行一列值得通用方法
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public static object GetScaler(string sql) {
            object result =null;
            try
            {
                Open();
                SqlCommand com = new SqlCommand(sql, con);
                result = com.ExecuteScalar();
            }
            catch (Exception)
            {

                Console.WriteLine("数据量访问异常");
            }
            finally
            {
                Close();
            }
            return result;
        }
        /// <summary>
        /// 通过SqlDataReader去获取数据库的数据
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public static SqlDataReader GetDataReader(string sql) {
            SqlDataReader dataReader = null;
            try
            {
                Open();
                SqlCommand com = new SqlCommand(sql, con);
                dataReader = com.ExecuteReader();
            }
            catch (Exception)
            {

                Console.WriteLine("数据量访问异常");
            }
            return dataReader;
        }
        /// <summary>
        /// 根据SqlDataAdaper获取数据存放到DataSet数据集中
        /// </summary>
        /// <param name="sql">数据库命令</param>
        /// <returns>DataSet数据集</returns>
        public static DataSet GetDataSet(string sql) {
        //实例化一个数据集
            DataSet ds = new DataSet();            

        //实例化一个数据适配器
            SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sql, con);            
            //将适配器拿到数据填充到数据集中
            sqlDataAdapter.Fill(ds);
            return ds;
        }
    }
}