using?System;
using?System.Data;
using?System.Data.OleDb;
using?System.Configuration;
using?System.Collections;
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;

public?partial?class?Cases?:?System.Web.UI.Page
{
????public?string?titlep;
????public?string?Descriptionp;
????public?string?Keywordsp;
????OleDbConnection?MyConn;
????int?PageSize?RecordCount?PageCount?CurrentPage;
????protected?void?Page_Load（object?sender?EventArgs?e）
????{

????????//titledescon
????????GetContent?drt?=?new?GetContent（）;
????????OleDbDataReader?drf?=?drt.GetTDC（）;
????????while?（drf.Read（））
????????{
????????????this.titlep?=?drf[“title“].ToString（）;
????????????this.Descriptionp?=?drf[“Description“].ToString（）;
????????????this.Keywordsp?=?drf[“Keywords“].ToString（）;
????????}
????????drf.Close（）;
????????//設(shè)定PageSize?
????????PageSize?=?12;
????????//連接語句?
????????MyConn?=?DB.CreateDB（）;
????????MyConn.Open（）;
????????//第一次請求執(zhí)行?
????????if?（!Page.IsPostBack）
????????{
????????????ListBind（）;
????????????CurrentPage?=?0;
????????????ViewState[“PageIndex“]?=?0;

????????????//計算總共有多少記錄?
????????????RecordCount?=?CalculateRecord（）;
????????????//
????????????lblRecordCount.Text?=?RecordCount.ToString（）;

????????????//計算總共有多少頁?
????????????if?（RecordCount?%?PageSize?==?0）
????????????{
????????????????PageCount?=?RecordCount?/?PageSize;
????????????}
????????????else
????????????{
????????????????PageCount?=?RecordCount?/?PageSize?+?1;
????????????}
????????????lblPageCount.Text?=?PageCount.ToString（）;
????????????ViewState[“PageCount“]?=?PageCount;
????????}
????}


????//計算總共有多少條記錄?
????public?int?CalculateRecord（）
????{
????????int?intCount;
????????string?strCount?=?“select?count（*）?as?co?from?product?where?pro_name=‘cases‘“;
????????OleDbCommand?MyComm?=?new?OleDbCommand（strCount?MyConn）;
????????OleDbDataReader?dr?=?MyComm.ExecuteReader（）;
????????if?（dr.Read（））
????????{
????????????intCount?=?Int32.Parse（dr[“co“].ToString（））;
????????}
????????else
????????{
????????????intCount?=?0;
????????}
????????dr.Close（）;
????????return?intCount;
????}


????ICollection?CreateSource（）
????{

????????int?StartIndex;

????????//設(shè)定導(dǎo)入的起終地址?
????????StartIndex?=?CurrentPage?*?PageSize;
????????string?strSel?=?“select?*?from?product?where?pro_name=‘cases‘“;
????????DataSet?ds?=?new?DataSet（）;

????????OleDbDataAdapter?MyAdapter?=?new?OleDbDataAdapter（strSel?MyConn）;
????????MyAdapter.Fill（ds?StartIndex?PageSize?“pro_name“）;
????????return?ds.Tables[“pro_name“].DefaultView;
????}



????public?void?ListBind（）
????{
????????DataList1.DataSource?=?CreateSource（）;
????????DataList1.DataBind（）;

????????lbnNextPage.Enabled?=?true;
????????lbnPrevPage.Enabled?=?true;
????????if?（CurrentPage?==?（PageCount?-?1））?lbnNextPage.Enabled?=?false;

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

?????文件??????20480??2006-09-19?09:13??OleDbHelper\bin\Debug\OleDbHelper.dll

?????文件??????19968??2006-09-19?09:13??OleDbHelper\bin\Debug\OleDbHelper.pdb

?????目錄??????????0??2008-01-09?11:43??OleDbHelper\bin\Debug

?????目錄??????????0??2008-01-09?11:43??OleDbHelper\bin

?????文件??????20480??2006-09-19?09:13??OleDbHelper\obj\Debug\OleDbHelper.dll

?????文件??????19968??2006-09-19?09:13??OleDbHelper\obj\Debug\OleDbHelper.pdb

?????目錄??????????0??2008-01-09?11:43??OleDbHelper\obj\Debug

?????文件????????150??2006-09-19?20:33??OleDbHelper\obj\OleDbHelper.csproj.FileList.txt

?????目錄??????????0??2008-01-09?11:43??OleDbHelper\obj

?????文件???????3647??2008-01-09?12:01??OleDbHelper\OleDbHelper.cs

?????文件???????2138??2006-09-17?09:14??OleDbHelper\OleDbHelper.csproj

?????文件???????1341??2006-09-17?09:06??OleDbHelper\Properties\AssemblyInfo.cs

?????目錄??????????0??2008-01-09?11:43??OleDbHelper\Properties

?????文件???????1484??2006-09-17?09:28??OleDbHelper\SystemError.cs

?????文件???????1477??2006-09-19?09:12??OleDbHelper\SystemTools.cs

?????目錄??????????0??2008-01-09?11:43??OleDbHelper

?????文件???????2503??2008-01-09?12:02??51aspx源碼必讀.txt

?????文件???????6776??2006-09-18?08:07??Cases.aspx

?????文件???????3847??2006-09-18?11:08??Cases.aspx.cs

?????文件???????2736??2006-09-18?08:08??Cases_More.aspx

?????文件???????2518??2006-09-19?16:56??Cases_More.aspx.cs

?????文件???????2605??2006-09-18?08:07??Contact.aspx

?????文件???????1123??2006-09-18?11:08??Contact.aspx.cs

?????文件???????4157??2006-09-18?08:07??Customer.aspx

?????文件???????1489??2006-09-18?11:08??Customer.aspx.cs

?????文件???????2739??2006-09-18?08:07??Customer_More.aspx

?????文件???????2586??2008-01-09?12:00??Customer_More.aspx.cs

?????文件????????445??2006-09-22?10:00??Default2.aspx

?????文件????????409??2006-09-22?10:00??Default2.aspx.cs

?????文件???????8613??2006-09-22?10:19??Default.aspx

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