SQLHelper/SqlOpe.cs

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

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

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using System.Data;
using System.Configuration;
//51-as-px
namespace SQLHelper
{
    public class SqlOpe
    {
        private OleDbConnection myConnection = null;
        private void Open()
        {
            if (myConnection == null)
            {
                //myConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\three\DB_51Aspx\users.xls;Extended Properties=Excel 8.0;");

                string path = AppDomain.CurrentDomain.BaseDirectory + "App_Data\\users.xls";
                string conns = $"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={path};Extended Properties=Excel 8.0;";
                myConnection = new OleDbConnection(conns);
            }
               

            if (myConnection.State == ConnectionState.Closed)
            {
                try
                {
                    ///打开数据库连接
                    myConnection.Open();
                }
                catch (Exception ex)
                {

                }
                finally
                {
                    ///关闭已经打开的数据库连接				
                }
            }
        }
        public void Close()
        {
            ///判断连接是否已经创建
            if (myConnection != null)
            {
                ///判断连接的状态是否打开
                if (myConnection.State == ConnectionState.Open)
                {
                    myConnection.Close();
                }
            }
        }
        public void Dispose()
        {
            // 确认连接是否已经关闭
            if (myConnection != null)
            {
                myConnection.Dispose();
                myConnection = null;