一个C# Access数据库操作封装类,功能不太多,但基本够用,主要面向使用Access数据库的用户,可实现Access数据库连接、返回执行SQL 语句所影响数据的行数、获取结果集的第一行第一列、获得详细Access数据等,类可继续扩展,这个确实简单些:
02 | using System.Collections.Generic; |
06 | using System.Data.OleDb; |
07 | using System.Configuration; |
08 | namespace Aikeli.Show.Shopman |
10 | public static class OleDbHelper |
12 | private static OleDbConnection connection; |
14 | /// 获得一个唯一的CONNECTION 实例 |
16 | public static OleDbConnection Connection |
20 | string connectionstring = ConfigurationManager.ConnectionStrings[ "database" ].ConnectionString; |
21 | if (connection == null ) |
23 | connection = new OleDbConnection(connectionstring); |
26 | else if (connection.State == System.Data.ConnectionState.Closed) |
30 | else if (connection.State == System.Data.ConnectionState.Broken) |
38 | /// 返回执行SQL 语句所影响数据的行数 |
39 | public static int ExecuteCommand( string sql) |
41 | OleDbCommand com = new OleDbCommand(sql, Connection); |
42 | int result = com.ExecuteNonQuery(); |
46 | public static int GetScalar( string sql) |
48 | OleDbCommand com = new OleDbCommand(sql, Connection); |
49 | int result = int .Parse(com.ExecuteScalar().ToString()); |
53 | public static DataTable GetDataSet( string sql) |
55 | DataSet dataset = new DataSet(); |
56 | OleDbCommand com = new OleDbCommand(sql, Connection); |
57 | OleDbDataAdapter da = new OleDbDataAdapter(com); |
59 | return dataset.Tables[0]; |
61 | public static OleDbDataReader GetReader( string sql) |
63 | OleDbCommand com = new OleDbCommand(sql, Connection); |
64 | OleDbDataReader reader = com.ExecuteReader(); |