Code My Future

 1 using System.Configuration;
 2 using System.Data;
 3 using System.Data.OleDb;
 4 
 5 namespace XXX
 6 {
 7     public class OleDbHelper
 8     {
 9         private static readonly string connstr = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
10         public static int ExecuteNonQuery(string cmdText, params OleDbParameter[] parameters)
11         {
12             using (OleDbConnection conn = new OleDbConnection(connstr))
13             {
14                 conn.Open();
15                 using (OleDbCommand cmd = conn.CreateCommand())
16                 {
17                     cmd.CommandText = cmdText;
18                     cmd.Parameters.AddRange(parameters);
19                     return cmd.ExecuteNonQuery();
20                 }
21             }
22         }
23 
24         public static object ExecuteScalar(string cmdText, params OleDbParameter[] parameters)
25         {
26             using (OleDbConnection conn = new OleDbConnection(connstr))
27             {
28                 conn.Open();
29                 using (OleDbCommand cmd = conn.CreateCommand())
30                 {
31                     cmd.CommandText = cmdText;
32                     cmd.Parameters.AddRange(parameters);
33                     return cmd.ExecuteScalar();
34                 }
35             }
36         }
37 
38         public static object ExecuteDataTable(string cmdText, params OleDbParameter[] parameters)
39         {
40             using (OleDbConnection conn = new OleDbConnection(connstr))
41             {
42                 conn.Open();
43                 using (OleDbCommand cmd = conn.CreateCommand())
44                 {
45                     cmd.CommandText = cmdText;
46                     cmd.Parameters.AddRange(parameters);
47                     DataTable dt = new DataTable();
48                     OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);
49                     adapter.Fill(dt);
50                     return dt;
51                 }
52             }
53         }
54     }
55 }

 1 <?xml version="1.0"?>
 2 <!--
 3   有关如何配置 ASP.NET 应用程序的详细信息，请访问
 4   http://go.microsoft.com/fwlink/?LinkId=169433
 5   -->
 6 <configuration>
 7   <system.web>
 8     <compilation debug="true"/>
 9     <httpRuntime/>
10   </system.web>
11   <connectionStrings>
12     <add name="ConnStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\database.mdb"/>
13   </connectionStrings>
14 </configuration>