DataList编辑、更新、取消、删除、分页

来源：互联网发布：linux源代码分析博客编辑：程序博客网时间：2024/04/29 11:39

html代码：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="DataList_DeleteUpdate1.aspx.cs"

Inherits="DataList_DataList_DeleteUpdate1" %>

<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>DataList编辑、更新、取消、删除、分页</title>

</head>

<body>

<div>

<tr>

<td>

<asp:DataList ID="DataList1" runat="server" Font-Size="12px" Width="100%" DataKeyField="ProductID"

OnCancelCommand="DataList1_CancelCommand" OnDeleteCommand="DataList1_DeleteCommand"

OnEditCommand="DataList1_EditCommand" OnUpdateCommand="DataList1_UpdateCommand">

<td>

au_id</td>

<td>

au_lname</td>

<td>

au_fname</td>

<td>

phone</td>

<td>

address</td>

<td>

编辑</td>

<td>

删除</td>

</HeaderTemplate>

<td>

<asp:Label ID="Lbl_au_id" Text='<%#Eval("au_id")%>' runat="server"></asp:Label>

</td>

<td>

<asp:Label ID="Lbl_au_lname" Text='<%#Eval("au_lname")%>' runat="server"></asp:Label>

</td>

<td>

<asp:Label ID="Lbl_au_fname" Text='<%#Eval("au_fname")%>' runat="server"></asp:Label>

</td>

<td>

<asp:Label ID="Lbl_phone" Text='<%#Eval("phone")%>' runat="server"></asp:Label>

</td>

<td>

<asp:Label ID="Lbl_address" Text='<%#Eval("address")%>' runat="server"></asp:Label>

</td>

<td>

<asp:LinkButton ID="LinkButton1" Text="编辑" CommandName="Edit" runat="server"></asp:LinkButton>

</td>

<td>

<asp:LinkButton ID="LinkButton3" Text="删除" CommandName="Delete" runat="server"></asp:LinkButton>

</td>

</ItemTemplate>

<td>

<asp:Label ID="Lbl_au_id" Text='<%#Eval("au_id")%>' runat="server"></asp:Label>

</td>

<td>

<asp:TextBox ID="Txt_au_lname" Text='<%#Eval("au_lname")%>' runat="server"></asp:TextBox>

</td>

<td>

<asp:TextBox ID="Txt_au_fname" Text='<%#Eval("au_fname")%>' runat="server"></asp:TextBox>

</td>

<td>

<asp:TextBox ID="Txt_phone" Text='<%#Eval("phone")%>' runat="server"></asp:TextBox>

</td>

<td>

<asp:TextBox ID="Txt_address" Text='<%#Eval("address")%>' runat="server"></asp:TextBox>

</td>

<td>

<asp:LinkButton ID="LinkButton1" Text="更新" CommandName="Update" runat="server"></asp:LinkButton>

<asp:LinkButton ID="LinkButton2" Text="取消" CommandName="Cancel" runat="server"></asp:LinkButton>

</td>

<td>

<asp:LinkButton ID="LinkButton3" Text="删除" CommandName="Delete" runat="server"></asp:LinkButton>

</td>

</EditItemTemplate>

</FooterTemplate>

</asp:DataList>

</td>

</tr>

<tr>

<webdiyer:AspNetPager ID="pager1" runat="server" Font-Size="12px" ShowCustomInfoSection="Left"

OnPageChanged="ChangePage" ShowInputBox="Always" CustomInfoSectionWidth="80%"

SubmitButtonText="go">

</webdiyer:AspNetPager>

</td>

</tr>

</table>

</div>

</form>

</body>

</html>

cs代码：

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 Wuqi.Webdiyer;

public partial class DataList_DataList_DeleteUpdate1 : System.Web.UI.Page

{

public string tblName = "authors";//表名

public string fldName = "au_id";//主键字段名

public int IsReCount = 1;//是否

public int OrderType = 0;//排序 0升，非0降

public string strWhere = "";//条件

Practice.DAL.authors authorsbll = new Practice.DAL.authors();

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

pager1.CurrentPageIndex = 1;//页数

pager1.PageSize = 5;//每页多少条

pager1.RecordCount = Convert.ToInt32(GetDataSet().Tables[1].Rows[0][0].ToString());//共多少条

DataBindGridView();

}

//返回dataSet

private DataSet GetDataSet()

{

DataSet ds = authorsbll.Minutepage(tblName, fldName, pager1.PageSize, pager1.CurrentPageIndex, IsReCount, OrderType, strWhere);

return ds;

}

//绑定GridView

private void DataBindGridView()

{

DataList1.DataSource = GetDataSet().Tables[0];

DataList1.DataKeyField = fldName;

DataList1.DataBind();

//显示记录信息

pager1.CustomInfoText = "记录总数：<b>" + pager1.RecordCount.ToString() + "</b>";

pager1.CustomInfoText += " 总页数：<b>" + pager1.PageCount.ToString() + "</b>";

pager1.CustomInfoText += " 当前页：<font color="red"><b>" + pager1.CurrentPageIndex.ToString() + "</b></font>";

}

//DataList编辑

protected void DataList1_EditCommand(object source, DataListCommandEventArgs e)

{

DataList1.EditItemIndex = e.Item.ItemIndex;

DataBindGridView();

}

//DataList取消

protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e)

{

DataList1.EditItemIndex = -1;

DataBindGridView();

}

//DataList更新

protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e)

{

string au_id = DataList1.DataKeys[e.Item.ItemIndex].ToString();

string au_lname = ((TextBox)e.Item.FindControl("Txt_au_lname")).Text.Trim();

Response.Write("更新时:<br/>au_id: " + au_id + "<br/>au_lname: " + au_lname);

DataList1.EditItemIndex = -1;

DataBindGridView();

}

//DataList删除

protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e)

{

string au_id = DataList1.DataKeys[e.Item.ItemIndex].ToString();

string au_lname = ((Label)e.Item.FindControl("Lbl_au_lname")).Text.Trim();

Response.Write("删除时:<br/>au_id: " + au_id + "<br/>au_lname: " + au_lname);

DataBindGridView();

}

//分页

protected void ChangePage(object src, PageChangedEventArgs e)

{

pager1.CurrentPageIndex = e.NewPageIndex;

DataBindGridView();

}

分页函数：

//// <summary>

/// </summary>

/// <param name="tblName">表名</param>

/// <param name="fldName">主键字段名</param>

/// <param name="PageSize">页尺寸</param>

/// <param name="PageIndex">页码</param>

/// <param name="IsReCount">返回记录总数, 非 0 值则返回</param>

/// <param name="OrderType">设置排序类型, 非 0 值则降序</param>

/// <param name="strWhere">查询条件 (注意: 不要加 where)</param>

/// <returns>ds</returns>

public DataSet Minutepage(string tblName,string fldName,int PageSize,int PageIndex,int IsReCount,int OrderType,string strWhere)

{

SqlParameter[] parameters = {

new SqlParameter("@tblName", SqlDbType.VarChar,255),

new SqlParameter("@fldName",SqlDbType.VarChar,255),

new SqlParameter("@PageSize", SqlDbType.Int),

new SqlParameter("@PageIndex", SqlDbType.Int),

new SqlParameter("@IsReCount",SqlDbType.Bit),

new SqlParameter("@OrderType",SqlDbType.Bit),

new SqlParameter("@strWhere",SqlDbType.VarChar,1000)

};

parameters[0].Value = tblName;

parameters[1].Value = fldName;

parameters[2].Value = PageSize;

parameters[3].Value = PageIndex;

parameters[4].Value = IsReCount;

parameters[5].Value = OrderType;

parameters[6].Value = strWhere;

return DbHelperSQL.RunProcedure("PR_MinutePage", parameters, "ds");

}