using?System;
using?System.Data;
using?System.Configuration;
using?System.Web;
using?System.Web.Security;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Web.UI.WebControls.WebParts;
using?System.Web.UI.HtmlControls;
using?System.Data.SqlClient;

namespace?shoppingCart
{
????public?class?DB
????{
????????public?DB（）
????????{
????????????//
????????????//?TODO:?在此處添加構造函數邏輯
????????????//
????????}
????????///?配置連接字符串
????????///?
????????///?返回SqlConnection對象
????????public?static?SqlConnection?GetCon（）
????????{
????????????return?new?SqlConnection（ConfigurationManager.AppSettings[“GetCon“]）;//配置連接字符串
????????}

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

????????///?執行SQL語句
????????///?

????????///?用來執行的SQL語句
????????///?返回是否成功成功返回True否則返回False
????????public?static?bool?ExSql（string?P_str_cmdtxt）
????????{
????????????SqlConnection?con?=?DB.GetCon（）;//連接數據庫
????????????con.Open（）;//打開連接
????????????SqlCommand?cmd?=?new?SqlCommand（P_str_cmdtxt?con）;
????????????try
????????????{
????????????????cmd.ExecuteNonQuery（）;//執行SQL?語句并返回受影響的行數
????????????????return?true;
????????????}
????????????catch?（Exception?e）
????????????{
????????????????return?false;
????????????}
????????????finally
????????????{
????????????????con.Dispose（）;//釋放連接對象資源
????????????}
????????}
????????///?

????????///?返回DataSet結果集
????????///?

????????///?用來查詢的SQL語句
????????///?結果集
????????public?static?DataSet?reDs（string?P_str_cmdtxt）
????????{
????????????SqlConnection?con?=?DB.GetCon（）;//連接上數據庫
????????????SqlDataAdapter?da?=?new?SqlDataAdapter（P_str_cmdtxt?con）;
????????????DataSet?ds?=?new?DataSet（）;
????????????da.Fill（ds）;
????????????return?ds;//返回DataSet對象
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-12-06?19:06??shoppingCart\
?????目錄???????????0??2012-12-06?20:16??shoppingCart\shoppingCart\
?????文件?????????926??2012-12-06?18:26??shoppingCart\shoppingCart.sln
?????文件???????16896??2012-12-31?12:28??shoppingCart\shoppingCart.suo
?????目錄???????????0??2012-12-06?19:06??shoppingCart\shoppingCart\App_Data\
?????文件????10485760??2012-12-06?18:48??shoppingCart\shoppingCart\App_Data\ASPNETDB.MDF
?????文件??????516096??2012-12-06?18:48??shoppingCart\shoppingCart\App_Data\aspnetdb_log.ldf
?????目錄???????????0??2012-12-06?19:06??shoppingCart\shoppingCart\bin\
?????文件???????14848??2012-12-29?19:44??shoppingCart\shoppingCart\bin\shoppingCart.dll
?????文件???????38400??2012-12-29?19:44??shoppingCart\shoppingCart\bin\shoppingCart.pdb
?????文件????????2143??2012-12-06?18:48??shoppingCart\shoppingCart\DB.cs
?????文件????????6693??2012-12-06?20:16??shoppingCart\shoppingCart\Default.aspx
?????文件????????2844??2012-12-06?20:16??shoppingCart\shoppingCart\Default.aspx.cs
?????文件????????4266??2012-12-06?18:28??shoppingCart\shoppingCart\Default.aspx.designer.cs
?????文件????????3712??2012-12-06?18:48??shoppingCart\shoppingCart\Describe.aspx
?????文件????????1181??2012-12-06?18:48??shoppingCart\shoppingCart\Describe.aspx.cs
?????文件????????3276??2012-12-06?18:32??shoppingCart\shoppingCart\Describe.aspx.designer.cs
?????文件????????6679??2012-12-06?18:48??shoppingCart\shoppingCart\GoodsInfo.aspx
?????文件????????3490??2012-12-06?18:48??shoppingCart\shoppingCart\GoodsInfo.aspx.cs
?????文件????????6187??2012-12-06?18:34??shoppingCart\shoppingCart\GoodsInfo.aspx.designer.cs
?????目錄???????????0??2012-12-06?19:06??shoppingCart\shoppingCart\Image\
?????文件??????111125??2007-05-07?11:38??shoppingCart\shoppingCart\Image\02-_small9[20061102090405].jpg
?????文件????????3303??2007-05-07?11:40??shoppingCart\shoppingCart\Image\3.gif
?????文件???????57546??2012-12-06?18:56??shoppingCart\shoppingCart\Image\3e1fdc17f7fcf71ec83d6d17.jpg
?????文件???????22081??2007-06-14?13:58??shoppingCart\shoppingCart\Image\fjtp.jpg
?????文件???????11814??2007-04-02?09:00??shoppingCart\shoppingCart\Image\fu.jpg
?????文件??????241208??2007-04-13?09:31??shoppingCart\shoppingCart\Image\圖片2.jpg
?????文件??????177490??2012-12-06?18:58??shoppingCart\shoppingCart\Image\手套.jpg
?????文件???????21772??2007-04-12?10:03??shoppingCart\shoppingCart\Image\水杯.bmp
?????目錄???????????0??2012-12-06?19:06??shoppingCart\shoppingCart\Image\購物車\
?????目錄???????????0??2012-12-06?19:06??shoppingCart\shoppingCart\Image\購物車\主頁\
............此處省略29個文件信息