当前文件路径：DaDaNews/Default.aspx.cs

		            
  1using System;
  2using System.Collections;
  3using System.Configuration;
  4using System.Data;
  5using System.Data.SqlClient;
  6using System.Web;
  7using System.Web.Security;
  8using System.Web.UI;
  9using System.Web.UI.HtmlControls;
 10using System.Web.UI.WebControls;
 11using System.Web.UI.WebControls.WebParts;
 12
 13public partial class _Default : System.Web.UI.Page
 14...{
 15    Db pn163 = new Db();
 16    protected void Page_Load(object sender, EventArgs e)
 17    ...{
 18        SqlConnection Conn = new SqlConnection(pn163.strConn);
 19
 20        SqlDataAdapter Da1 = new SqlDataAdapter("Select * from NewView where Class_id=14 order by id desc", Conn);
 21
 22        DataSet Ds1 = new DataSet();
 23
 24        Da1.Fill(Ds1, "NewView");
 25
 26        PagedDataSource Pds = new PagedDataSource();
 27
 28        Pds.DataSource = Ds1.Tables["NewView"].DefaultView;
 29
 30        Pds.AllowPaging = true;
 31
 32        Pds.PageSize = 16;
 33
 34        Repeater1.DataSource = Pds;
 35
 36        Repeater1.DataBind();
 37
 38        Rep2();
 39
 40        Rep3();
 41
 42        Rep4();
 43
 44        R();
 45
 46    }
 47    public void Rep2()
 48    ...{
 49        SqlConnection Conn = new SqlConnection(pn163.strConn);
 50
 51        SqlDataAdapter Da2 = new SqlDataAdapter("Select * from NewView where Class_id=2 order by id desc", Conn);
 52
 53        DataSet Ds2 = new DataSet();
 54
 55        Da2.Fill(Ds2, "NewView");
 56
 57        PagedDataSource Pds = new PagedDataSource();
 58
 59        Pds.DataSource = Ds2.Tables["NewView"].DefaultView;
 60
 61        Pds.AllowPaging = true;
 62
 63        Pds.PageSize = 16;
 64
 65        Repeater2.DataSource = Pds;
 66
 67        Repeater2.DataBind();
 68    }
 69
 70    public void Rep3()
 71    ...{
 72        SqlConnection Conn = new SqlConnection(pn163.strConn);
 73
 74        SqlDataAdapter Da3 = new SqlDataAdapter("Select * from NewView where Class_id=16 order by id desc", Conn);
 75
 76        DataSet Ds3 = new DataSet();
 77
 78        Da3.Fill(Ds3, "NewView");
 79
 80        PagedDataSource Pds = new PagedDataSource();
 81
 82        Pds.DataSource = Ds3.Tables["NewView"].DefaultView;
 83
 84        Pds.AllowPaging = true;
 85
 86        Pds.PageSize = 16;
 87
 88        Repeater3.DataSource = Pds;
 89
 90        Repeater3.DataBind();
 91    }
 92
 93    public void Rep4()
 94    ...{
 95        SqlConnection Conn = new SqlConnection(pn163.strConn);
 96
 97        SqlDataAdapter Da4 = new SqlDataAdapter("Select * from NewView where Class_id=13 order by id desc", Conn);
 98
 99        DataSet Ds4 = new DataSet();
100
101        Da4.Fill(Ds4, "NewView");
102
103        PagedDataSource Pds = new PagedDataSource();
104
105        Pds.DataSource = Ds4.Tables["NewView"].DefaultView;
106
107        Pds.AllowPaging = true;
108
109        Pds.PageSize = 16;
110
111        Repeater4.DataSource = Pds;
112
113        Repeater4.DataBind();
114    }
115    public void R()
116    ...{
117        SqlConnection Conn = new SqlConnection(pn163.strConn);
118
119        SqlDataAdapter DaR = new SqlDataAdapter("Select * from NewView order by id desc", Conn);
120
121        DataSet DsR = new DataSet();
122
123        DaR.Fill(DsR, "NewView");
124
125        PagedDataSource Pds = new PagedDataSource();
126
127        Pds.DataSource = DsR.Tables["NewView"].DefaultView;
128
129        Pds.AllowPaging = true;
130
131        Pds.PageSize = 40;
132
133        RepeaterR.DataSource = Pds;
134
135        RepeaterR.DataBind();
136    }
137}
138