App_code/dataconn.cs

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

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

using System;
using System.Data;
using System.Data.OleDb;
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>
/// dataconn 的摘要说明
/// </summary>
public class dataconn
{
  public dataconn()
  {
   //
   // TODO: 在此处添加构造函数逻辑
   //
  }

  public static string strConn=ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString; 
  public  bool ExecuteSQL(int id)
  {
      string SQL = "DELETE * FROM reply where article_id = ?"; 
   OleDbConnection conn = new OleDbConnection(dataconn.strConn);
   OleDbCommand cmd = new OleDbCommand(SQL,conn);
   cmd.Parameters.AddWithValue("@article_id", id);
   try
   { 
    conn.Open();
    cmd.ExecuteNonQuery();
    return true;
   }
   catch
   {
    return false;
   }
   finally
   {
    conn.Close();
    conn.Dispose();
    cmd.Dispose();
   }
  }

    public bool delete_article(int id)
    {
        string SQL = "DELETE * FROM article where id = ?";
        OleDbConnection conn = new OleDbConnection(dataconn.strConn);
        OleDbCommand cmd = new OleDbCommand(SQL, conn);
        cmd.Parameters.AddWithValue("@id", id);
        try
        {
            conn.Open();
            cmd.ExecuteNonQuery();
            return true;
        }