App_Code/SqlHelper.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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

namespace DAO
{
    public class SqlHelper
    {//下载于51aspx.com
        //从Web.config中读取数据库连接字符春
        private String ConnStr = System.Configuration.ConfigurationSettings.AppSettings["ConnString"];

        private SqlConnection conn = null;

        /// <summary>
        /// 将查询结果集填充到DataTable
        /// </summary>
        /// <param name="query">查询T-Sql</param>
        /// <returns></returns>
        public DataTable FillDataTable(String query)
        {
            DataTable dt = new DataTable();
            using (conn = new SqlConnection(ConnStr))
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = conn;
                cmd.CommandText = query;
                SqlDataAdapter ada = new SqlDataAdapter();
                ada.SelectCommand = cmd;
                ada.Fill(dt);
            }
            return dt;
        }

        /// <summary>
        /// 将查询结果集填充到DataSet
        /// </summary>
        /// <param name="query">查询T-Sql,可以是多个Select语句</param>
        /// <returns></returns>
        public DataSet FillDataSet(String query)
        {//下载于51aspx.com
            DataSet ds = new DataSet();
            using (conn = new SqlConnection(ConnStr))
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = conn;
                cmd.CommandText = query;
                SqlDataAdapter ada = new SqlDataAdapter();
                ada.SelectCommand = cmd;
                ada.Fill(ds);
            }
            return ds;
        }

        /// <summary>
        /// 执行insert、update、delete、truncate语句
        /// </summary>
        /// <param name="commandText">insert、update、delete、truncate语句</param>
        public void ExecuteNonQuery(String commandText)
        {
            using (conn = new SqlConnection(ConnStr))