using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Configuration;
using?System.Data.SqlClient;
using?System.Data;

namespace?DBUtility
{
????public?abstract?class?DBHelper
????{
????????private?static?readonly?string?connectionstring?=?ConfigurationManager.ConnectionStrings[“Sqlconnction“].ConnectionString;

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

????????///?執行有參數的查詢
????????///?

????????///?連接字符串
????????///?查詢類型，Text?or?Store?Procesure
????????///?查詢的T-SQL命令
????????///?返回?SqlDataReacer
????????public?static?SqlDataReader?ExecuteDataReader（CommandType?comType?string?comText?params?SqlParameter[]?Paramreters）
????????{
????????????SqlCommand?cmd?=?new?SqlCommand（）;
????????????SqlConnection?conn?=?new?SqlConnection（connectionstring）;
????????????try
????????????{
????????????????//公共預處理方法
????????????????PrepareCommand（cmd?conn?null?comType?comText?Paramreters）;
????????????????SqlDataReader?dr?=?cmd.ExecuteReader（CommandBehavior.CloseConnection）;
????????????????cmd.Parameters.Clear（）;
????????????????return?dr;
????????????}
????????????catch
????????????{
????????????????conn.Close（）;
????????????????throw;
????????????}
????????}
????????
????????///?

????????///?執行有參數的查詢
????????///?

????????///?連接字符串
????????///?查詢類型，Text?or?Store?Procesure
????????///?查詢的T-SQL命令
????????///?返回?DataSet
????????public?static?DataSet?ExecuteDataSet（CommandType?cmdType?string?cmdText?params?SqlParameter[]?commandParameters）
????????{

????????????SqlCommand?cmd?=?new?SqlCommand（）;
????????????SqlConnection?conn?=?new?SqlConnection（connectionstring）;
????????????try
????????????{
????????????????//公共預處理方法
????????????????PrepareCommand（cmd?conn?null?cmdType?cmdText?commandParameters）;
????????????????SqlDataAdapter?da?=?new?SqlDataAdapter（）;
????????????????da.SelectCommand?=?cmd;
????????????????DataSet?ds?=?new?DataSet（）;
????????????????da.Fill（ds）;
????????????????cmd.Parameters.Clear（）;
????????????????return?ds;
????????????}
????????????catch
????????????{
????????????????conn.Close（）;
????????????????throw;
????????????}
????????}

????????//?

????????///?執行有參數的查詢
????????///?

????????///?連接字符串
????????///?查詢類型，Text?or?Store?Procesure
????????///?查詢的T-SQL命令
????????///?返回操作成功的記錄數
????????public?static?int?ExecuteNonQuery（CommandType?cmdType?string?cmdText?params?SqlParameter[]?commandParamrters）
????????{
????????????SqlCommand?cmd?=?new?SqlCommand（）;
????????????SqlConnection?conn?=?new?SqlConnection（connectionstring）;
????????????PrepareCo

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

?????文件???????6634??2011-04-20?15:28??Wish\WebSite.sln

????..A..H.?????66560??2011-04-25?10:35??Wish\WebSite.suo

?????文件????????160??2011-03-18?09:13??Wish\ForumBLL\Class1.cs

?????文件???????3054??2011-03-21?12:38??Wish\ForumBLL\ForumBLL.csproj

?????文件??????22016??2011-04-25?10:34??Wish\ForumBLL\bin\Debug\ForumDAL.dll

?????文件??????17408??2011-04-25?10:34??Wish\ForumBLL\bin\Debug\Model.dll

?????文件???????6144??2011-04-25?10:34??Wish\ForumBLL\bin\Debug\DBUtility.dll

?????文件??????38400??2011-04-25?10:34??Wish\ForumBLL\bin\Debug\ForumDAL.pdb

?????文件??????11776??2011-04-25?10:34??Wish\ForumBLL\bin\Debug\Model.pdb

?????文件??????13824??2011-04-25?10:34??Wish\ForumBLL\bin\Debug\DBUtility.pdb

?????文件???????8192??2011-04-25?10:34??Wish\ForumBLL\bin\Debug\ForumBLL.dll

?????文件??????28160??2011-04-25?10:34??Wish\ForumBLL\bin\Debug\ForumBLL.pdb

?????文件???????5120??2011-04-18?01:19??Wish\ForumBLL\obj\Debug\Refactor\ForumBLL.dll

?????文件???????1513??2011-04-25?10:34??Wish\ForumBLL\obj\Debug\ForumBLL.csproj.FileListAbsolute.txt

?????文件???????7698??2011-04-25?10:34??Wish\ForumBLL\obj\Debug\ResolveAssemblyReference.cache

?????文件??????28160??2011-04-25?10:34??Wish\ForumBLL\obj\Debug\ForumBLL.pdb

?????文件???????8192??2011-04-25?10:34??Wish\ForumBLL\obj\Debug\ForumBLL.dll

?????文件???????1348??2011-03-18?09:13??Wish\ForumBLL\Properties\AssemblyInfo.cs

?????文件???????1676??2011-04-15?00:19??Wish\ForumBLL\CategoryManage.cs

?????文件???????1950??2011-04-15?09:53??Wish\ForumBLL\ForumsManage.cs

?????文件???????2878??2011-04-18?00:23??Wish\ForumBLL\UsersManage.cs

?????文件???????2005??2011-04-18?02:25??Wish\ForumBLL\TopicsManage.cs

?????文件???????1897??2011-04-18?12:16??Wish\ForumBLL\ReplyManage.cs

?????文件????????160??2011-03-18?09:20??Wish\ForumDAL\Class1.cs

?????文件???????3057??2011-03-28?11:37??Wish\ForumDAL\ForumDAL.csproj

?????文件???????6144??2011-04-25?10:34??Wish\ForumDAL\bin\Debug\DBUtility.dll

?????文件??????17408??2011-04-25?10:34??Wish\ForumDAL\bin\Debug\Model.dll

?????文件??????11776??2011-04-25?10:34??Wish\ForumDAL\bin\Debug\Model.pdb

?????文件??????13824??2011-04-25?10:34??Wish\ForumDAL\bin\Debug\DBUtility.pdb

?????文件??????22016??2011-04-25?10:34??Wish\ForumDAL\bin\Debug\ForumDAL.dll

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