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;//引入命名空间


/// <summary>
/// DBHelper 的摘要说明：公共类用来操作数据库，静态类通过类名直接调用其中的方法
/// </summary>
public class DBHelper
{
    static SqlConnection myConn;
    static SqlCommand cmd;
    static SqlDataReader sdr;
    static SqlDataAdapter sda;
    public DBHelper()
    {
        //
       
         
        }
    /// <summary>
    /// 获得数据库连接字符串
    /// </summary>
    /// <returns></returns>
    public static string GetConnStr()
    {
        return "server=.\\SQLEXPRESS;database=CYY;Integrated security = true;";
   }


    public static int ExecuteSQL(string cmdText, CommandType cmdType, string[] names, object[] values)
    {
        myConn = new SqlConnection();
        myConn.ConnectionString = ConfigurationManager.AppSettings["connstr"];
        cmd = new SqlCommand();
        cmd.Connection = myConn;
        sda = new SqlDataAdapter();
        cmd.CommandText = cmdText;
        cmd.CommandType = cmdType;
        cmd.Parameters.Clear();
        if (names != null)
        {
            for (int i = 0; i < names.Length; i++)
            {
                cmd.Parameters.AddWithValue(names[i], values[i]);
            }
        }
        if (myConn.State == ConnectionState.Closed)
        {
            myConn.Open();
        }
        int count = cmd.ExecuteNonQuery();
        myConn.Close();