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

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2016-04-22?18:42??MF000639-ASP.NET網絡課程管理系統源碼\
?????目錄???????????0??2016-04-22?18:42??MF000639-ASP.NET網絡課程管理系統源碼\DBUtility\
?????文件???????21384??2010-04-21?08:52??MF000639-ASP.NET網絡課程管理系統源碼\DBUtility\AccessHelper.cs
?????文件????????2268??2010-04-16?19:55??MF000639-ASP.NET網絡課程管理系統源碼\DBUtility\DBUtility.csproj
?????目錄???????????0??2016-04-22?18:42??MF000639-ASP.NET網絡課程管理系統源碼\DBUtility\Properties\
?????文件????????1331??2010-01-02?15:34??MF000639-ASP.NET網絡課程管理系統源碼\DBUtility\Properties\AssemblyInfo.cs
?????文件???????26328??2016-04-18?20:35??MF000639-ASP.NET網絡課程管理系統源碼\DBUtility\Properties\源碼下載.jpg
?????文件???????19040??2010-05-20?13:55??MF000639-ASP.NET網絡課程管理系統源碼\DBUtility\SqlServerHelper.cs
?????目錄???????????0??2016-04-22?18:42??MF000639-ASP.NET網絡課程管理系統源碼\DBUtility\bin\
?????目錄???????????0??2016-04-22?16:46??MF000639-ASP.NET網絡課程管理系統源碼\DBUtility\bin\Debug\
?????文件???????11776??2012-04-05?09:03??MF000639-ASP.NET網絡課程管理系統源碼\DBUtility\bin\Debug\DBUtility.dll
?????文件???????32256??2012-04-05?09:03??MF000639-ASP.NET網絡課程管理系統源碼\DBUtility\bin\Debug\DBUtility.pdb
?????文件???????26328??2016-04-18?20:35??MF000639-ASP.NET網絡課程管理系統源碼\DBUtility\bin\源碼下載.jpg
?????目錄???????????0??2016-04-22?18:42??MF000639-ASP.NET網絡課程管理系統源碼\DBUtility\obj\
?????文件?????????322??2016-04-22?17:20??MF000639-ASP.NET網絡課程管理系統源碼\DBUtility\obj\DBUtility.csproj.FileListAbsolute.txt
?????目錄???????????0??2016-04-22?16:46??MF000639-ASP.NET網絡課程管理系統源碼\DBUtility\obj\Debug\
?????文件????????1011??2016-04-22?17:20??MF000639-ASP.NET網絡課程管理系統源碼\DBUtility\obj\Debug\DBUtility.csproj.FileListAbsolute.txt
?????文件???????11776??2012-04-05?09:03??MF000639-ASP.NET網絡課程管理系統源碼\DBUtility\obj\Debug\DBUtility.dll
?????文件???????32256??2012-04-05?09:03??MF000639-ASP.NET網絡課程管理系統源碼\DBUtility\obj\Debug\DBUtility.pdb
?????目錄???????????0??2018-01-29?15:47??MF000639-ASP.NET網絡課程管理系統源碼\DBUtility\obj\Debug\TempPE\
?????文件???????26328??2016-04-18?20:35??MF000639-ASP.NET網絡課程管理系統源碼\DBUtility\obj\源碼下載.jpg
?????文件???????26328??2016-04-18?20:35??MF000639-ASP.NET網絡課程管理系統源碼\DBUtility\源碼下載.jpg
?????文件?????????316??2016-04-22?17:20??MF000639-ASP.NET網絡課程管理系統源碼\DBUtility\源碼說明.txt
?????目錄???????????0??2016-04-22?18:42??MF000639-ASP.NET網絡課程管理系統源碼\Lib\
?????文件???????54190??2010-02-04?09:23??MF000639-ASP.NET網絡課程管理系統源碼\Lib\Common.cs
?????文件????????2281??2010-04-16?19:56??MF000639-ASP.NET網絡課程管理系統源碼\Lib\Lib.csproj
?????文件????????5174??2009-12-31?17:11??MF000639-ASP.NET網絡課程管理系統源碼\Lib\Log.cs
?????目錄???????????0??2016-04-22?18:42??MF000639-ASP.NET網絡課程管理系統源碼\Lib\Properties\
?????文件????????1319??2010-01-02?15:34??MF000639-ASP.NET網絡課程管理系統源碼\Lib\Properties\AssemblyInfo.cs
?????文件???????26328??2016-04-18?20:35??MF000639-ASP.NET網絡課程管理系統源碼\Lib\Properties\源碼下載.jpg
?????文件????????2493??2010-01-07?09:15??MF000639-ASP.NET網絡課程管理系統源碼\Lib\SystemConfig.cs
............此處省略787個文件信息