using?System;
using?System.Web;
using?System.Collections.Generic;

using?System.Data;
using?System.Data.OleDb;
using?System.Configuration;
using?System.IO;

namespace?DBUtility
{
????///?

????///?數據訪問層，提供處理Access數據庫的各種方法
????///?

????public?sealed??class?AccessHelper?
????{
????????static?AccessHelper（）
????????{
?????????????//connectionString?=?string.Format（@“Provider=Microsoft.Jet.OleDb.4.0;Data?Source={0}App_Data\MyShop.mdb;Persist?Security?Info=True;“?AppDomain.CurrentDomain.baseDirectory）;
????????????//connectionString?=?ConfigurationManager.AppSettings[“OLEDBCONNECTIONSTRING“].ToString（）?+?System.Web.HttpContext.Current.Server.MapPath（ConfigurationManager.AppSettings[“strCon“]）;
????????}
????????protected?static?string?connectionString
????????{
????????????get?{?return?string.Format（@“Provider=Microsoft.Jet.OleDb.4.0;Data?Source={0}“?System.Web.HttpContext.Current.Server.MapPath（ConfigurationManager.AppSettings[“strCon“]））;?}
????????}

????????#region?ExecuteNonQuery

????????///?

????????///?execute?the?sql?and?return?the?count?of?line?
????????///?

????????///?
????????///?
????????public?static??int?ExecuteNonQuery（string?commandText）
????????{
????????????return?ExecuteNonQuery（commandText?（OleDbParameter[]）null）;
????????}

????????public?static?int?ExecuteNonQuery（string?commandText?OleDbParameter[]?parameters）
????????{
????????????CommandType?text?=?CommandType.Text;
????????????return?ExecuteNonQuery（text?commandText?parameters）;
????????}

?

?

?

????????///?

????????///?Execute?a?OleDbCommand?（that?returns?no?resultset）?against?the?database?specified?in?the?connection?string?
????????///?using?the?provided?prams
????????///?

????????///?
????????///?e.g.:??
????????///??int?result?=?ExecuteNonQuery（?CommandType.StoredProcedure?“PublishOrders“?new?OleDbParameter（“@prodid“?24））;
????????///?
????????///?The?CommandType?（stored?procedure?text?etc.）
????????///?The?stored?procedure?name?or?T-SQL?command
????????///?An?array?of?SqlParamters?used?to?execute?the?command
????????///?An?int?representing?the?number?of?rows?affected?by?the?command
????????public?static?int?ExecuteNonQuery（?CommandType?commandType?string?commandText?params?OleDbParameter[]?commandprams）
????????{
????????????if?（connectionString?==?null?||?connectionString.Length?==?0）?throw?new?ArgumentNullException（“connectionString“）;

????????????//?Create?&?open?a?OleDbConnection?and?dispose?of?it?after?we?are?done
????????????using?（OleDbConnection?connection?=?new?OleDbConnection（connectionString））
????????????{
????????????????connection.Open（）;

????????????????//?Call?the?overload?that?takes?a?connection?in?place?of?the?connection?stri

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件??????21384??2010-04-21?08:52??DBUtility\AccessHelper.cs

?????文件??????11776??2010-05-20?13:55??DBUtility\bin\Debug\DBUtility.dll

?????文件??????32256??2010-05-20?13:55??DBUtility\bin\Debug\DBUtility.pdb

?????文件???????2268??2010-04-16?19:55??DBUtility\DBUtility.csproj

?????文件????????322??2010-02-18?19:49??DBUtility\obj\DBUtility.csproj.FileListAbsolute.txt

?????文件????????669??2010-08-31?11:28??DBUtility\obj\Debug\DBUtility.csproj.FileListAbsolute.txt

?????文件??????11776??2010-05-20?13:55??DBUtility\obj\Debug\DBUtility.dll

?????文件??????32256??2010-05-20?13:55??DBUtility\obj\Debug\DBUtility.pdb

?????文件???????1331??2010-01-02?15:34??DBUtility\Properties\AssemblyInfo.cs

?????文件??????19040??2010-05-20?13:55??DBUtility\SqlServerHelper.cs

?????文件??????25600??2010-05-09?00:55??Lib\bin\Debug\Lib.dll

?????文件??????60928??2010-05-09?00:55??Lib\bin\Debug\Lib.pdb

?????文件??????54190??2010-02-04?09:23??Lib\Common.cs

?????文件???????2281??2010-04-16?19:56??Lib\Lib.csproj

?????文件???????5174??2009-12-31?17:11??Lib\Log.cs

?????文件????????561??2010-08-31?11:28??Lib\obj\Debug\Lib.csproj.FileListAbsolute.txt

?????文件??????25600??2010-05-09?00:55??Lib\obj\Debug\Lib.dll

?????文件??????60928??2010-05-09?00:55??Lib\obj\Debug\Lib.pdb

?????文件????????268??2010-02-18?19:49??Lib\obj\Lib.csproj.FileListAbsolute.txt

?????文件???????1319??2010-01-02?15:34??Lib\Properties\AssemblyInfo.cs

?????文件???????2493??2010-01-07?09:15??Lib\SystemConfig.cs

?????文件??????11776??2010-05-20?13:55??Photography.AccessDAL\bin\Debug\DBUtility.dll

?????文件??????32256??2010-05-20?13:55??Photography.AccessDAL\bin\Debug\DBUtility.pdb

?????文件??????23552??2010-08-31?11:28??Photography.AccessDAL\bin\Debug\Photography.AccessDAL.dll

?????文件??????54784??2010-08-31?11:28??Photography.AccessDAL\bin\Debug\Photography.AccessDAL.pdb

?????文件???????5632??2010-08-31?11:28??Photography.AccessDAL\bin\Debug\Photography.IDAL.dll

?????文件???????7680??2010-08-31?11:28??Photography.AccessDAL\bin\Debug\Photography.IDAL.pdb

?????文件???????7168??2010-08-31?11:28??Photography.AccessDAL\bin\Debug\Photography.Model.dll

?????文件??????34304??2010-08-31?11:28??Photography.AccessDAL\bin\Debug\Photography.Model.pdb

?????文件???????1851??2010-08-31?11:28??Photography.AccessDAL\obj\Debug\Photography.AccessDAL.csproj.FileListAbsolute.txt

............此處省略731個文件信息