DataList分页、增加、删除、修改实例

datalist控件没有内置的分页功能，所以对于分页需自己写程序去实现；本示例还包括了DataList的所有基本操作，如添加，删除，修改，选择等；具体代码如下:

前台代码：Default.aspx

----------------------------------------

<%@ Page language="c#" Codebehind="Default.aspx.cs" AutoEventWireup="false" Inherits="Example.DataListTest" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >

<HTML>

<HEAD>

<title>DataListTest</title>

</style>

</HEAD>

<tr>

<td><a href="DlNested.aspx">DataList嵌套实例</a></td>

</tr>

<tr>

<td>

<table cellSpacing="0" borderColorDark="white" cellPadding="0" width="100%" align="center"

border="1">

<tr>

<td><asp:datalist id="DataList1" runat="server" Width="90%" Height="280px" RepeatColumns="2" RepeatDirection="Horizontal"

RepeatLayout="Flow">

<table id="Table6" cellspacing="0" bordercolordark="white" cellpadding="0" width="100%"

border="1">

<tr>

<td width="80%"><font face="宋体">TypeName</font></td>

</tr>

</table>

</headertemplate>

<tr>

<td><font face="宋体">TypeID</font></td>

<td><font face="宋体" color="#ff3366"><font face="宋体">TypeName</font></font></td>

</tr>

<tr>

<asp:Label id=lblTypeID runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "I_TypeID") %>'>

</asp:Label></font></td>

<asp:Label id=lblTypeName runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "C_TypeName") %>'>

</asp:Label></font></td>

</tr>

<tr>

<asp:Button id="btnBack" runat="server" CommandName="cancel" Text="返回"></asp:Button></td>

</tr>

</table>

</font>

</selecteditemtemplate>

<table id="Table8" cellspacing="0" bordercolordark="white" cellpadding="0" width="100%"

border="1">

<tr>

<td><font face="宋体">TypeID</font></td>

<td>

<asp:TextBox id="txtTypeIDInsert" runat="server"></asp:TextBox></td>

<td><font face="宋体">TypeName</font></td>

<td>

<asp:TextBox id="txtTypeNameInsert" runat="server"></asp:TextBox></td>

<asp:Button id="btnInsert" runat="server" Text="新增" CommandName="Insert"></asp:Button></td>

</tr>

</table>

</footertemplate>

<tr>

<%# DataBinder.Eval(Container.DataItem,"C_TypeName")%>

</font>

</td>

<asp:Button id="btnSelect" runat="server" CommandName="select" Text="选择"></asp:Button></td>

<asp:Button id="btnModify" runat="server" CommandName="edit" Text="编辑" EnableViewState="true"></asp:Button></td>

<asp:Button id=btnDelete runat="server" CommandName="delete" Text="删除" CommandArgument='<%# DataBinder.Eval(Container.DataItem, "I_TypeID") %>'>

</asp:Button></font></td>

</tr>

</table>

</itemtemplate>

<tr>

<td style="WIDTH: 75px; HEIGHT: 23px"><font face="宋体"><font face="宋体">TypeName</font></font></td>

<asp:TextBox id=txtTypeName runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "C_TypeName") %>'>

</asp:TextBox></font></td>

</tr>

<tr>

<asp:Button id=btnUpdate runat="server" CommandName="update" Text="更新" CommandArgument='<%# DataBinder.Eval(Container.DataItem, "I_TypeID") %>'>

</asp:Button></font></td>

<asp:Button id="btnCancle" runat="server" CommandName="cancel" Text="取消"></asp:Button></font></td>

</tr>

</table>

</edititemtemplate>

</asp:datalist></td>

</tr>

</table>

</td>

</tr>

<tr>

<td>

<TD noWrap width="10%">共

<asp:label id="lblRecNum" runat="server"></asp:label>条记录</TD>

<TD noWrap width="30%">第

<asp:label id="lblCurPageNO" runat="server"></asp:label>页/共

<asp:label id="lblPageNum" runat="server"></asp:label>页</TD>

<TD noWrap width="20%">转到

<asp:dropdownlist id="ddlJumpToPageNum" runat="server" AutoPostBack="True"></asp:dropdownlist>页</TD>

</TR>

</TABLE>

</td>

</tr>

</table>

</form>

</body>

</HTML>

后台代码：Default.aspx.cs

----------------------------------------

/*----------------------------------------------------------------

// 网站地址: Http://www.easewe.com

// 联系方式: 87015203(QQ),easewe@126.com(Email)

// 整理日期: 2005.09.14

//----------------------------------------------------------------*/

using System;

using System.Collections;

using System.ComponentModel;

using System.Data;

using System.Data.SqlClient;

using System.Drawing;

using System.Web;

using System.Web.SessionState;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

using System.Data.OleDb;

namespace Example

{

/// <summary>

/// DataListTest 的摘要说明。

/// </summary>

public class DataListTest : System.Web.UI.Page

{

protected System.Web.UI.WebControls.DataList DataList1;

protected System.Web.UI.WebControls.Label lblRecNum;

protected System.Web.UI.WebControls.Label lblCurPageNO;

protected System.Web.UI.WebControls.Label lblPageNum;

protected System.Web.UI.WebControls.Button btnFirst;

protected System.Web.UI.WebControls.Button btnPreview;

protected System.Web.UI.WebControls.Button btnNext;

protected System.Web.UI.WebControls.Button btnLast;

protected System.Web.UI.WebControls.DropDownList ddlPageRowNum;

protected System.Web.UI.WebControls.DropDownList ddlJumpToPageNum;

protected string connString;

protected int pageNum = -1;

protected int recNum = -1;

protected int pageRecNum = -1;

protected int curPageNO = -1;

private void Page_Load(object sender, System.EventArgs e)

{

// 在此处放置用户代码以初始化页面

connString = @"Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + Request.PhysicalApplicationPath + "DataList.mdb";

if ( !Page.IsPostBack )

{

//-----------recNum

OleDbConnection conn = new OleDbConnection();

conn.ConnectionString = connString;

conn.Open();

OleDbCommand cmd = new OleDbCommand("select count(*) from ArticleType",conn);

recNum = Convert.ToInt32(cmd.ExecuteScalar());

conn.Close();

//-----------pageRecNum

ddlPageRowNum.Items.Clear();

for( int i=1;i<=recNum;i++ )

{

ddlPageRowNum.Items.Add(i.ToString());

}

if ( recNum < 5 )

{

ddlPageRowNum.SelectedIndex = recNum - 1;

}

else

{

ddlPageRowNum.SelectedIndex = 4;

}

//------------------pageRecNum,pageNum

pageRecNum = Convert.ToInt32(ddlPageRowNum.SelectedValue);

if ( Convert.ToInt32(recNum % pageRecNum) == 0 )

{

pageNum = Convert.ToInt32(recNum/pageRecNum);

}

else

{

pageNum = Convert.ToInt32(recNum/pageRecNum) + 1;

}

ddlJumpToPageNum.Items.Clear();

for( int i=1;i<=pageNum;i++ )

{

ddlJumpToPageNum.Items.Add(i.ToString());

}

lblPageNum.Text = pageNum.ToString();

ViewState["PageRowNum"] = pageRecNum;

ViewState["RecNum"] = recNum;

ViewState["PageNum"] = pageNum;

//-----------------curPageNO

curPageNO = 1;

ViewState["CurPageNO"] = curPageNO;

//------------------

}

pageRecNum = Convert.ToInt32(ViewState["PageRowNum"]);

recNum = Convert.ToInt32(ViewState["RecNum"]);

curPageNO = Convert.ToInt32(ViewState["CurPageNO"]);

pageNum = Convert.ToInt32(ViewState["PageNum"]);

//------------pageNum

if ( pageRecNum==-1 || recNum==-1 )

{

Response.Write("发生错误!");

Response.End();

}

if ( curPageNO <= 1 )

{

curPageNO = 1;

btnFirst.Enabled = false;

btnPreview.Enabled = false;

}

//-----------------

lblRecNum.Text = recNum.ToString();

lblCurPageNO.Text = curPageNO.ToString();

//-----------------

if ( !Page.IsPostBack )

{

BindData();

}

#region Web 窗体设计器生成的代码

override protected void OnInit(EventArgs e)

{

// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。

InitializeComponent();

base.OnInit(e);

}

/// <summary>

/// 设计器支持所需的方法 - 不要使用代码编辑器修改

/// 此方法的内容。

/// </summary>

private void InitializeComponent()

{

this.DataList1.ItemCommand += new System.Web.UI.WebControls.DataListCommandEventHandler(this.DataList1_ItemCommand);

this.DataList1.CancelCommand += new System.Web.UI.WebControls.DataListCommandEventHandler(this.DataList1_CancelCommand);

this.DataList1.EditCommand += new System.Web.UI.WebControls.DataListCommandEventHandler(this.DataList1_EditCommand);

this.DataList1.UpdateCommand += new System.Web.UI.WebControls.DataListCommandEventHandler(this.DataList1_UpdateCommand);

this.DataList1.DeleteCommand += new System.Web.UI.WebControls.DataListCommandEventHandler(this.DataList1_DeleteCommand);

this.DataList1.ItemDataBound += new System.Web.UI.WebControls.DataListItemEventHandler(this.DataList1_ItemDataBound);

this.btnFirst.Click += new System.EventHandler(this.btnFirst_Click);

this.btnPreview.Click += new System.EventHandler(this.btnPreview_Click);

this.btnNext.Click += new System.EventHandler(this.btnNext_Click);

this.btnLast.Click += new System.EventHandler(this.btnLast_Click);

this.ddlPageRowNum.SelectedIndexChanged += new System.EventHandler(this.ddlPageRowNum_SelectedIndexChanged);

this.ddlJumpToPageNum.SelectedIndexChanged += new System.EventHandler(this.ddlJumpToPageNum_SelectedIndexChanged);

this.Load += new System.EventHandler(this.Page_Load);

}

#endregion

#region datelist

private void BindData()

{

string commandText = "select * from ArticleType";

//----------

OleDbConnection conn = new OleDbConnection();

conn.ConnectionString = connString;

conn.Open();

OleDbDataAdapter da = new OleDbDataAdapter(commandText,conn);

DataSet ds = new DataSet();

da.Fill(ds,(curPageNO-1) * pageRecNum,pageRecNum,"ArticleType");

//----------

DataList1.DataSource = ds.Tables["ArticleType"];

DataList1.DataBind();

ds.Clear();

conn.Close();

lblCurPageNO.Text = curPageNO.ToString();

}

private void DataList1_EditCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)

{

DataList1.EditItemIndex = e.Item.ItemIndex;

BindData();

}

private void DataList1_DeleteCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)

{

string typeID = e.CommandArgument.ToString();

string commandText = "Delete From ArticleType Where I_TypeID=@TypeID";

OleDbConnection conn = new OleDbConnection();

conn.ConnectionString = connString;

conn.Open();

OleDbCommand cmd = new OleDbCommand(commandText,conn);

OleDbParameter[] param = new OleDbParameter[1];

param[0] = new OleDbParameter("TypeID",typeID);

cmd.Parameters.Add(param[0]);

cmd.ExecuteNonQuery();

cmd.Parameters.Clear();

conn.Close();

//----------------------

recNum --;

lblRecNum.Text = recNum.ToString();

//-----------pageRecNum

ddlPageRowNum.Items.Clear();

for( int i=1;i<=recNum;i++ )

{

ddlPageRowNum.Items.Add(i.ToString());

}

ddlPageRowNum.SelectedValue = ViewState["PageRowNum"].ToString();

//------------------pageRecNum,pageNum

pageRecNum = Convert.ToInt32(ddlPageRowNum.SelectedValue);

if ( Convert.ToInt32(recNum % pageRecNum) == 0 )

{

pageNum = Convert.ToInt32(recNum/pageRecNum);

}

else

{

pageNum = Convert.ToInt32(recNum/pageRecNum) + 1;

}

ddlJumpToPageNum.Items.Clear();

for( int i=1;i<=pageNum;i++ )

{

ddlJumpToPageNum.Items.Add(i.ToString());

}

lblPageNum.Text = pageNum.ToString();

lblCurPageNO.Text = pageNum.ToString();

ViewState["PageRowNum"] = pageRecNum;

ViewState["RecNum"] = recNum;

ViewState["PageNum"] = pageNum;

//-----------------curPageNO

curPageNO = Convert.ToInt32(ViewState["CurPageNO"]);

if ( curPageNO>pageNum )

{

curPageNO = pageNum;

}

ddlJumpToPageNum.SelectedValue = "1";

ViewState["CurPageNO"] = curPageNO;

//-----------------

if ( curPageNO == 1 )

{

btnFirst.Enabled = false;

btnPreview.Enabled = false;

}

if ( curPageNO == pageNum )

{

btnNext.Enabled = false;

btnLast.Enabled = false;

}

//----------

DataList1.EditItemIndex = -1;

DataList1.SelectedIndex = -1;

//----------------------

BindData();

}

private void DataList1_ItemDataBound(object sender, System.Web.UI.WebControls.DataListItemEventArgs e)

{

if ( e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem )

{

Button btnDel = (Button)e.Item.FindControl("btnDelete");

btnDel.Attributes.Add("onclick","return confirm('确定要删除[" + DataBinder.Eval(e.Item.DataItem,"C_TypeName") + "]吗？')");

e.Item.Attributes.Add("onmouseover","this.style.backgroundColor='#cccc00'");

e.Item.Attributes.Add("onmouseout","this.style.backgroundColor='white'");

}

private void DataList1_ItemCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)

{

if ( e.CommandName == "select" )

{

DataList1.SelectedIndex = e.Item.ItemIndex;

BindData();

}

if ( e.CommandName == "Insert" )

{

string typeID = ((TextBox)e.Item.FindControl("txtTypeIDInsert")).Text.ToString();

string typeName = ((TextBox)e.Item.FindControl("txtTypeNameInsert")).Text.ToString();

//----------

string commandText = "Insert Into ArticleType(C_TypeName,I_TypeID)";

commandText = commandText + " Values(@TypeName,@TypeID)";

//-----------

OleDbConnection conn = new OleDbConnection();

conn.ConnectionString = connString;

conn.Open();

OleDbCommand cmd = new OleDbCommand(commandText,conn);

OleDbParameter[] param = new OleDbParameter[2];

param[0] = new OleDbParameter("TypeName",typeName);

param[1] = new OleDbParameter("TypeID",typeID);

cmd.Parameters.Add(param[0]);

cmd.Parameters.Add(param[1]);

cmd.ExecuteNonQuery();

cmd.Parameters.Clear();

conn.Close();

//----------------------

recNum ++;

lblRecNum.Text = recNum.ToString();

//-----------pageRecNum

ddlPageRowNum.Items.Clear();

for( int i=1;i<=recNum;i++ )

{

ddlPageRowNum.Items.Add(i.ToString());

}

ddlPageRowNum.SelectedValue = ViewState["PageRowNum"].ToString();

//------------------pageRecNum,pageNum

pageRecNum = Convert.ToInt32(ddlPageRowNum.SelectedValue);

if ( Convert.ToInt32(recNum % pageRecNum) == 0 )

{

pageNum = Convert.ToInt32(recNum/pageRecNum);

}

else

{

pageNum = Convert.ToInt32(recNum/pageRecNum) + 1;

}

ddlJumpToPageNum.Items.Clear();

for( int i=1;i<=pageNum;i++ )

{

ddlJumpToPageNum.Items.Add(i.ToString());

}

lblPageNum.Text = pageNum.ToString();

lblCurPageNO.Text = pageNum.ToString();

ViewState["PageRowNum"] = pageRecNum;

ViewState["RecNum"] = recNum;

ViewState["PageNum"] = pageNum;

//-----------------curPageNO

curPageNO = pageNum;

ddlJumpToPageNum.SelectedValue = "1";

ViewState["CurPageNO"] = curPageNO;

//-----------------

btnFirst.Enabled = true;

btnPreview.Enabled = true;

btnNext.Enabled = false;

btnLast.Enabled = false;

//----------

DataList1.EditItemIndex = -1;

DataList1.SelectedIndex = -1;

BindData();

}

private void DataList1_CancelCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)

{

DataList1.SelectedIndex = -1;

DataList1.EditItemIndex = -1;

BindData();

}

private void DataList1_UpdateCommand(object source, System.Web.UI.WebControls.DataListCommandEventArgs e)

{

string typeID = e.CommandArgument.ToString();

string typeName = ((TextBox)e.Item.FindControl("txtTypeName")).Text.ToString();

//----------

string commandText = "Update ArticleType Set C_TypeName=@TypeName";

commandText = commandText + " Where I_TypeID=@TypeID";

//-----------

OleDbConnection conn = new OleDbConnection();

conn.ConnectionString = connString;

conn.Open();

OleDbCommand cmd = new OleDbCommand(commandText,conn);

OleDbParameter[] param = new OleDbParameter[2];

param[0] = new OleDbParameter("TypeName",typeName);

param[1] = new OleDbParameter("TypeID",typeID);

cmd.Parameters.Add(param[0]);

cmd.Parameters.Add(param[1]);

cmd.ExecuteNonQuery();

cmd.Parameters.Clear();

conn.Close();

//----------------------

DataList1.EditItemIndex = -1;

BindData();

}

#endregion

private void ddlPageRowNum_SelectedIndexChanged(object sender, System.EventArgs e)

{

#region pageRowNum,pageNum

pageRecNum = Convert.ToInt32(ddlPageRowNum.SelectedValue);

if ( Convert.ToInt32(recNum % pageRecNum) == 0 )

{

pageNum = Convert.ToInt32(recNum/pageRecNum);

}

else

{

pageNum = Convert.ToInt32(recNum/pageRecNum) + 1;

}

ddlJumpToPageNum.Items.Clear();

for( int i=1;i<=pageNum;i++ )

{

ddlJumpToPageNum.Items.Add(i.ToString());

}

lblPageNum.Text = pageNum.ToString();

ViewState["PageRowNum"] = pageRecNum;

ViewState["PageNum"] = pageNum;

//-----------

if ( curPageNO > pageNum )

{

curPageNO = 1;

ViewState["CurPageNO"] = curPageNO.ToString();

}

//------

btnFirst.Enabled = true;

btnPreview.Enabled = true;

btnNext.Enabled = true;

btnLast.Enabled = true;

if ( curPageNO == 1 )

{

btnFirst.Enabled = false;

btnPreview.Enabled = false;

}

if ( curPageNO == pageNum )

{

btnNext.Enabled = false;

btnLast.Enabled = false;

}

//---------

BindData();

#endregion

}

#region 移动页面

private void MoveFirst()

{

curPageNO = 1;

ViewState["CurPageNO"] = curPageNO.ToString();

BindData();

//------

btnFirst.Enabled = false;

btnPreview.Enabled = false;

btnNext.Enabled = true;

btnLast.Enabled = true;

}

private void MovePrevious()

{

curPageNO = curPageNO - 1;

ViewState["CurPageNO"] = curPageNO.ToString();

BindData();

//------

if ( curPageNO == 1 )

{

btnFirst.Enabled = false;

btnPreview.Enabled = false;

}

btnNext.Enabled = true;

btnLast.Enabled = true;

}

private void MoveNext()

{

curPageNO = curPageNO + 1;

ViewState["CurPageNO"] = curPageNO.ToString();

BindData();

//------

btnFirst.Enabled = true;

btnPreview.Enabled = true;

if ( curPageNO == pageNum )

{

btnNext.Enabled = false;

btnLast.Enabled = false;

}

private void MoveLast()

{

curPageNO = pageNum;

ViewState["CurPageNO"] = curPageNO.ToString();

BindData();

//------

btnFirst.Enabled = true;

btnPreview.Enabled = true;

btnNext.Enabled = false;

btnLast.Enabled = false;

}

#endregion

private void btnFirst_Click(object sender, System.EventArgs e)

{

MoveFirst();

}

private void btnPreview_Click(object sender, System.EventArgs e)

{

MovePrevious();

}

private void btnNext_Click(object sender, System.EventArgs e)

{

MoveNext();

}

private void btnLast_Click(object sender, System.EventArgs e)

{

MoveLast();

}

private void ddlJumpToPageNum_SelectedIndexChanged(object sender, System.EventArgs e)

{

curPageNO = Convert.ToInt32(ddlJumpToPageNum.SelectedValue);

BindData();

}

'--------------------

分页功能重点用到OleDbDataAdapter的Fill(DataSet, int, int, string)方法，该方法的作用是从指定的ds中读取第N行后的M行；

下载源程序