自己封装的ASP.NET的MSSQL的数据库操作类(MSSQLHelper)

/*
 *   说明: 对MSSQL数据库的增删查改操作的封装类
 */

using System;
using System.Data;
using System.Data.SqlClient;
using System.Web.Configuration;

namespace Niunan.Tg029.Hr.Utility
{
    public class MSSQLHelper
    {
        private SqlConnection conn = null;
        private SqlCommand cmd = null;
        private SqlDataReader sdr = null;

        public MSSQLHelper()
        {
            string connStr = WebConfigurationManager.ConnectionStrings["connStr"].ToString();
            conn = new SqlConnection(connStr);
        }

        /// <summary>创建Command对象
        /// 默认是SQL语句
        /// </summary>
        /// <param name="sql">SQL语句</param>
        public void CreateCommand(string sql)
        {
            conn.Open();
            cmd &