資源簡介
幫同學做的一個小型新聞系統,做的不見得好,但是關鍵是過了,呵呵.系統采用c#+sql2005,使用了一個數據庫操作類,實現一些基本的系統功能,修改下就可以使用了.
代碼片段和文件信息
using?System;
using?System.Data;
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;
using?System.Data.SqlClient;
public?partial?class?_Default?:?System.Web.UI.Page
{
????Database?Db?=?new?Database();//引用數據庫通用操作類
????protected?void?Page_Load(object?sender?EventArgs?e)
????{
????????string?strSQL?=?@“Select?*?from?NewView?where?Class_id=18??and?isdel=0?order?by?id?desc“;?//查詢語句
????????DataSet?Ds1?=??Db.GetDataSet(strSQL);//使用數據庫通用操作類獲取DataSet//使用數據庫通用操作類獲取DataSet
??????????PagedDataSource?Pds?=?new?PagedDataSource();//對數據源進行分頁操作
????????Pds.DataSource?=?Ds1.Tables[0].DefaultView;
????????Pds.AllowPaging?=?true;
????????Pds.PageSize?=?8;
????????Repeater1.DataSource?=?Pds;//設置數據源
????????Repeater1.DataBind();//綁定數據源
????????Rep2();
????????Rep3();
????????Rep4();
????????Rep5();
????????R();
????}
????public?void?Rep2()
????{
????????string?strSQL2?=?@“Select?*?from?NewView?where?Class_id=13?and?isdel=0?order?by?id?desc“;
????????DataSet?Ds2?=?Db.GetDataSet(strSQL2);
??????????PagedDataSource?Pds?=?new?PagedDataSource();//對數據源進行分頁操作
????????Pds.DataSource?=?Ds2.Tables[0].DefaultView;
????????Pds.AllowPaging?=?true;
????????Pds.PageSize?=?8;
????????Repeater2.DataSource?=?Pds;//設置數據源
????????Repeater2.DataBind();//綁定數據源
????}
????public?void?Rep3()
????{
????????string?strSQL3?=?@“Select?*?from?NewView?where?Class_id=12?and?isdel=0?order?by?id?desc“;
????????DataSet?Ds3?=?Db.GetDataSet(strSQL3);
??????????PagedDataSource?Pds?=?new?PagedDataSource();//對數據源進行分頁操作
????????Pds.DataSource?=?Ds3.Tables[0].DefaultView;
????????Pds.AllowPaging?=?true;
????????Pds.PageSize?=?8;
????????Repeater3.DataSource?=?Pds;//設置數據源
????????Repeater3.DataBind();//綁定數據源
????}
????public?void?Rep4()
????{
????????string?strSQL4?=?@“Select?*?from?NewView?where?Class_id=11?and?isdel=0?order?by?id?desc“;
????????DataSet?Ds4?=?Db.GetDataSet(strSQL4);
??????????PagedDataSource?Pds?=?new?PagedDataSource();//對數據源進行分頁操作
????????Pds.DataSource?=?Ds4.Tables[0].DefaultView;
????????Pds.AllowPaging?=?true;
????????Pds.PageSize?=?5;
????????Repeater4.DataSource?=?Pds;//設置數據源
????????Repeater4.DataBind();//綁定數據源
????}
????public?void?Rep5()
????{
????????string?strSQL5?=?@“Select?*?from?linkAddress?where?isdel=0?order?by?id?desc“;
????????DataSet?Ds5?=?Db.GetDataSet(strSQL5);
??????????PagedDataSource?Pds?=?new?PagedDataSource();//對數據源進行分頁操作
????????Pds.DataSource?=?Ds5.Tables[0].DefaultView;
????????Pds.AllowPaging?=?true;
????????Pds.PageSize?=?4;
????????Repeater5.DataSource?=?Pds;//設置數據源
????????Repeater5.DataBind();//綁定數據源
????}
????public?void?R()
????{
????????string?strSQL?=?@“Select?*?from?NewView?order?by?id?desc“;
- 上一篇:C# Winform 模仿360系統安全工具界面-
- 下一篇:C# in Depth
評論
共有 條評論