VS 三层架构DAL层Sqlhelper代码块

 先引用

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

 public class SqlHelper
    {
        /// <summary>
        /// 创建连接字符串
        /// </summary>
        private static string strConn = ConfigurationManager.ConnectionStrings["DigitalProductShopConnectionString"]
            .ConnectionString;

        /// <summary>
        /// 查询语句
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public static DataTable Query(string sql)
        {
            //创建一张新表
            using (DataTable table = new DataTable())
            {
                //创建数据适配器
                using (SqlDataAdapter adapter = new SqlDataAdapter(sql, strConn))
                {
                    adapter.Fill(table);
                }

                return table;
            }
        }

        public static int NonQuery(string sql)
        {
            //创建一个数字
            int num = 0;
            using (SqlConnection sqlConn = new SqlConnection(strConn))
            {
                using (SqlCommand sqlCmd = new SqlCommand(sql, sqlConn))
                {
                    try
                    {
                        sqlConn.Open();
                        num = sqlCmd.ExecuteNonQuery();
                    }
                    finally
                    {
                        if (sqlConn.State == ConnectionState.Open)
                        {
                            sqlConn.Close();
                        }
                    }
                }
            }
            return num;
        }
    }