App_Code/DBHelper.cs

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

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

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Text.RegularExpressions;

/// <summary>
/// DBHelper 的摘要说明
/// </summary>
public class DBHelper
{
     
        public DBHelper()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //
        }
 
 
        /// <summary>
        /// 获得数据库连接字符串
        /// </summary>
        /// <returns></returns>
        public static string GetConnStr()
        {
            return ConfigurationManager.ConnectionStrings["QiChe"].ConnectionString;
        }



        /// <summary>
        /// 由sql变量（select语句）得到DataSet类型查询记录集合
        /// </summary>
        /// <param name="sql">select语句，字符串类型</param>
        /// <returns></returns>
        public static DataSet GetDataSet(string sql)
        {
            SqlConnection conn = new SqlConnection(GetConnStr());
            conn.Open();
            SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
            DataSet ds = new DataSet();
            sda.Fill(ds);
            conn.Close();
            return ds;
        }




        /// <summary>
        /// 执行sql语句，主要是insert、update、delete语句
        /// </summary>
        /// <param name="sql"></param>