Web/App_Code/SqlHelper.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Configuration;
using System.Data.OleDb;
using System.IO;
using System.Data;

/// <summary>
///SqlHelper 的摘要说明
/// </summary>
public class SqlHelper
{
    private static OleDbConnection connection;

    public static OleDbConnection Connection
    {
        get
        {
            string connectionstring = ConfigurationManager.ConnectionStrings["Accesscon"].ConnectionString;

            if (connection == null)
            {
                connection = new OleDbConnection(connectionstring);
                connection.Open();
            }
            return SqlHelper.connection;
        }

    }

    public static readonly string ConnectionString = ConfigurationManager.ConnectionStrings["Accesscon"].ConnectionString;
    public static readonly OleDbConnection con = new OleDbConnection(ConnectionString);


    /// <summary>
    ///只支持SQL语句，类型，用于增删改 
    /// </summary>
    /// <param name="commandText"></param>
    /// <param name="ct"></param>
    /// <returns></returns>
    public static int ExecuteNonQuery(string commandText, CommandType ct)
    {

        OleDbCommand cmd = new OleDbCommand(commandText, Connection);
        try
        {
            cmd.CommandType = ct;
            return cmd.ExecuteNonQuery();
        }
        catch (Exception)
        {
            return -1;
        }
        finally
        {
            con.Close();
        }