如何给SqlHelper的封装

设置Web.config

	<connectionStrings>
	//连接数据库的字符串
		<Add name="sql" connectionStrings="*****" providerName=""/>
	</connectionStrings>

sqlHelper

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
//下面就可以直接调用SqlData
//using SqlData = System.Data.SqlClient.SqlDataAdapter;


namespace WebApplication1
{
    public class sqlHelper
    {
        //连接字符串
        private static string strConn = ConfigurationManager.ConnectionStrings[""].ConnectionString;

        //查询
        public static DataTable Query(string sql) 
        {
            SqlDataAdapter sda = new SqlDataAdapter(sql, strConn);
            DataTable dt = new DataTable();
            sda.Fill(dt);
            return dt;

        }
        //非查询
        public static int NonQuery(string sql ) 
        {
            int num = 0;
            SqlConnection sqlConnection = new SqlConnection(strConn) ;
            SqlCommand comm = new SqlCommand(sql, sqlConnection);
            //sqlConnection.Open();
            //num = comm.ExecuteNonQuery();
            //sqlConnection.Close();
            try
            {
                sqlConnection.Open();

                num = comm.ExecuteNonQuery();


            }
            finally 
            {
                if (sqlConnection.State == ConnectionState.Open) sqlConnection.Close();
            
            }
            return num; 
        }

    }
}

还不太明白，就先写到这，不久修改