App_Code/ClassDB.cs

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

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

using System;
using System.Data;
using System.Data.SqlClient;
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;

/// <summary>
/// ClassDB 的摘要说明
/// </summary>
public class ClassDB
{
    public ClassDB()
    {
        //
        // TODO: 在此处添加构造函数逻辑
        //
    }
    public static string connstring = ConfigurationManager.AppSettings["cn"];  //设置连接数据库的代码是webconfig里面的cn那句,即:server=.;database=net05qingongzhuxue;uid=sa;pwd=;
    public static SqlConnection sqlConn = new SqlConnection(ConfigurationManager.AppSettings["cn"]);

    public static void DeleteID(string tablename,string id)
    {
        string sql;
        sql = "delete from " + tablename + " where id=" + id + "";
        Execute(sql);
    }
    public static void Delete(string tbname,string keyfield, string key)
    {
        string sql;
        sql = "delete from " + tbname + " where " + keyfield + "=" + key;
        Execute(sql);
    }
    public static string GetField(string tbname,string field,string keyfield,string key)
    {
        string ret = "";
        string sql = "select " + field + " from " + tbname + " where " + keyfield + "=" + key;
        DataTable dt = GetDataTable(sql);
        if (dt!=null&&dt.Rows.Count>0)
        {
            ret = dt.Rows[0][field].ToString();
        }
        return ret;
    }
    public static int Execute(string sql)  //自定义函数:执行sql语句,如果执行成功,返回值1,否则0
    {
        SqlCommand myCommand = new SqlCommand(sql, sqlConn); //设置新执行命令
        try
        {
            sqlConn.Open();  //打开数据库连接
            int count=myCommand.ExecuteNonQuery(); //执行sql语句
            return count;  //执行成功,返回1
        }
        catch
        {
            return 0;  //执行失败,返回0