App_Code/runsql.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.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.OleDb;

/// <summary>
///runsql 的摘要说明
/// </summary>
public class runsql
{
    #region 通用方法
    // 数据连接池
    //private OleDbConnection con;
    /// <summary>
    /// 返回数据库连接字符串
    /// </summary>
    /// <returns></returns>
    public static String GetSqlConnection()
    {
        //String conn = ConfigurationManager.ConnectionStrings["myconn"].ConnectionString;
        string DBName = ConfigurationManager.AppSettings.Get("DBName").ToString();
        //从配置文件中得到数据库驱动 
        string DBDriver = ConfigurationManager.AppSettings.Get("DBDriver").ToString();
        //得到数据库连接字符串 
        string DBConnectionString = DBDriver + HttpContext.Current.Server.MapPath(HttpContext.Current.Request.ApplicationPath + "/App_Data/") + DBName;
        //建立数据库连接对象 
        OleDbConnection OleDbConn = new OleDbConnection(DBConnectionString);
        String conn = OleDbConn.ConnectionString;
        return conn;
    }
    #endregion
    #region 执行sql字符串
    /// <summary>
    /// 执行不带参数的SQL语句
    /// </summary>
    /// <param name="Sqlstr"></param>
    /// <returns></returns>
    public static int ExecuteSql(String Sqlstr)
    {
        String ConnStr = GetSqlConnection();
        using (OleDbConnection conn = new OleDbConnection(ConnStr))
        {
            OleDbCommand cmd = new OleDbCommand();
            cmd.Connection = conn;
            cmd.CommandText = Sqlstr;
            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();
            return 1;
        }
    }
    /// <summary>
    /// 执行带参数的SQL语句
    /// </summary>