DataList控件的分页.docVIP

 HYPERLINK /aspx-net/archive/2010/09/06/1818807.html DataList控件的分页 ??? 不同于Gridview控件，Datalist控件没有自动分页支持。要支持分页功能，你必须添加代码，如下例所示： ? int PageSize, RecordCount, PageCount, CurrentPage; SqlConnection MyConn; public int IndexOfPage { ??? get { return (int)ViewState[_IndexOfPage]; } ??? set { ViewState[_IndexOfPage ] = value; } } public int CountOfPage { ??? get { return (int)ViewState[_CountOfPage]; } ??? set { ViewState[_CountOfPage] = value; } } public void Page_Load(Object src, EventArgs e) { ??? PageSize = 3; ??? string MyConnString = ???? @Server=(local)\SQLEXPRESS;Integrated Security=SSPI;Database=test;Persist Security Info=True; ??? MyConn = new SqlConnection(MyConnString); ??? MyConn.Open(); ??? if (!Page.IsPostBack) ??? { ??????? ListBind(); ??????? CurrentPage = 0; ??????? IndexOfPage = 0; ??????? RecordCount = CalculateRecord(); ??????? lblRecordCount.Text = RecordCount.ToString(); ??????? PageCount = RecordCount / PageSize; ??????? lblPageCount.Text = PageCount.ToString(); ??????? CountOfPage = PageCount; ??? } }? public int CalculateRecord() { ??? int intCount; ??? string strCount = select count(*) as co from student; ??? SqlCommand MyComm = new SqlCommand(strCount, MyConn); ??? SqlDataReader dr = MyComm.ExecuteReader(); ??? if (dr.Read()) ??? { ??????? intCount = Int32.Parse(dr[co].ToString()); ??? } ??? else ??? { ??????? intCount = 0; ??? } ??? dr.Close(); ??? return intCount; } ICollection CreateSource() { ??? int StartIndex; ??? StartIndex = CurrentPage * PageSize; ??? string strSel = select * from student; ??? DataSet ds = new DataSet(); ??? SqlDataAdapter MyAdapter = new SqlDataAdapter(strSel, MyConn); ??? MyAdapter.Fill(ds, StartIndex, PageSize, Score); ??? return ds.Tables[Score].DefaultView; } public void ListBind() { ??? DataList1.DataSource = CreateSource(); ??? DataList1.DataBind(); ??? lbnNextPage.Enabled = true; ??? lbnPrevPage.Enabled = true; ??? if (CurrentPage == (PageCount - 1)) lbnNextPage.Enabled = false; ??? if (CurrentPage == 0) l