1using System;
 2using System.Collections.Generic;
 3using System.Text;
 4using System.Data;//1引入操作Access数据库名称空间
 5using System.Data.OleDb;
 6using System.Configuration;//2引入读取配置文件的名称空间
 7using System.Collections;
 8//该源码下载自www.51aspx.com(５1ａｓｐｘ．ｃｏｍ)
 9
10namespace WebQuest
11...{
12    public class AccessDB
13    ...{
14        private string _connectionString;//3连接串
15
16        private string _sqlStr;//4要执行的SQL语句
17
18        public string SqlStr
19        ...{
20            get ...{ return _sqlStr; }
21            set ...{ _sqlStr = value; }
22        }
23     
24        public AccessDB()//5
25        ...{
26            _connectionString = ConfigurationManager.AppSettings["ConnectionString"];
27        }
28
29        //6执行没有返回值的SQL语句
30        public void ExecuteSqlStr()
31        ...{
32            OleDbConnection _conn = new OleDbConnection(_connectionString);
33            _conn.Open();
34
35            OleDbCommand _com = new OleDbCommand(_sqlStr, _conn);
36
37            _com.ExecuteNonQuery();
38
39            _conn.Close();//关闭连接
40
41        }
42
43        //执行返回记录集的SQL语句
44        public OleDbDataReader ExecuteSqlStrReturnDr()
45        ...{
46            OleDbConnection _conn = new OleDbConnection(_connectionString);
47            _conn.Open();
48
49            OleDbCommand _com = new OleDbCommand(_sqlStr, _conn);
50            return _com.ExecuteReader(CommandBehavior.CloseConnection);//执行完语句以后,连接自动关闭
51        }
52        public DataSet ExecuteSqlStrReturnDs()
53        ...{
54            OleDbConnection _conn = new OleDbConnection(_connectionString);
55            _conn.Open();
56
57            OleDbDataAdapter _Da = new OleDbDataAdapter(_sqlStr, _conn);
58
59            DataSet _Ds = new DataSet();
60
61            _Da.Fill(_Ds);
62          
63
64            _conn.Close();
65
66            return _Ds;
67
68        }
69        
70      
71    }
72}