将Excel直接当作数据库使用，ASP.NET三层架构

【实例简介】

Excel做为数据库登录的三层实现

一个简单的登录验证程序源码，数据库采用的是Excel，利用简单三层实现

DB/users.xls为Excel文件
【实例截图】

【核心代码】

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using System.Data;
using System.Configuration;

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=G:\\users.xls;Extended Properties=Excel 8.0;");

         
          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;
          }  
      }
      public void RunSQL(string cmdText,out OleDbDataReader dataReader)
      {
          Open();
          OleDbCommand cmd = new OleDbCommand(cmdText,myConnection);
              //cmd.Parameters.Add(new OleDbParameter(RETURNVALUE, OleDbType.Integer, 4, ParameterDirection.ReturnValue,
              //     false, 0, 0, string.Empty, DataRowVersion.Default, null));
          try
          {
              ///读取数据
              dataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
              //dataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection); 
          }
          catch (Exception ex)
          {
              dataReader = null;
              ///记录错误日志
              //SystemError.CreateErrorLog(ex.Message);
              //Close();
          }
          finally
          {
              //Close();
          }
      }

    }
}