App_Code/database.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.ComponentModel;
using System.Collections;
using System.Diagnostics;


/// <summary>
/// database 的摘要说明
/// </summary>
public class DataAccess : IDisposable
{
    public string SqlBase = ConfigurationManager.AppSettings["ConnectionString"];


    public DataTable DisPlay_DT(string sql, SqlConnection conn)
    {
        DataTable Dt = new DataTable();
        SqlDataAdapter ShowAdapter = new SqlDataAdapter(sql, conn);
        ShowAdapter.Fill(Dt);
        conn.Close();
        return Dt;
    }

    public DataTable DisPlayList_Ds(string sql, SqlConnection conn)
    {
        DataTable Dt = new DataTable();
        SqlDataAdapter ShowAdapter = new SqlDataAdapter(sql, conn);
        ShowAdapter.Fill(Dt);
        conn.Close();
        return Dt;
    }

    public int AddInfo(string sql, SqlConnection conn)
    {
        int State;
        try
        {
            SqlCommand AddInfoCmd = new SqlCommand(sql, conn);
            AddInfoCmd.ExecuteNonQuery();
            conn.Close();
            State = 1;
        }
        catch
        {
            State = 0;
            conn.Close();
        }
        return State;
    }

    public int DeleteInfo(string sql, SqlConnection conn)