DataList控件的分页

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) lbnPrevPage.Enabled = false;

lblCurrentPage.Text = (CurrentPage + 1).ToString();

}

public void Page_OnClick(Object sender, CommandEventArgs e)

{

CurrentPage = (int)IndexOfPage;

PageCount = (int)CountOfPage;

string cmd = https://www.360docs.net/doc/fa12490027.html,mandName;

switch (cmd)

{

case"next":

if (CurrentPage < (PageCount - 1)) CurrentPage++;

break;

case"prev":

if (CurrentPage > 0) CurrentPage--;

break;

}

IndexPage = CurrentPage;

ListBind();

}