DataList增加复选框方法,以及获选中项的值

最新推荐文章于 2024-07-18 16:34:35 发布

原创最新推荐文章于 2024-07-18 16:34:35 发布 · 6.2k 阅读

3 ·

CC 4.0 BY-SA版权

文章标签：

#server #asp #object #dataset #webform #textbox

.Net(Web) 专栏收录该内容

7 篇文章

订阅专栏

本文介绍如何在ASP.NET中实现带有复选框的数据列表分页及数据绑定功能，详细展示了前台和后台代码实现过程。

1、为了有复选框，增加CheckBox到DataList上

2、在DataList上的项上设置数据列

3、确认选择获得选择项对应分店编号值

<ItemTemplate>
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr>
                    <td width="30%" align="left">
                        <asp:CheckBox ID="CheckBox1" runat="server" />
                        <asp:Label ID="lbFdbh" Text=' <%#DataBinder.Eval(Container.DataItem,"fdbh")%>' runat="server" />
                    </td>
                    <%--<td width="30%" align="center"><%#DataBinder.Eval(Container.DataItem,"senduser")%></td> --%>
                    <td width="30%" align="center">
                       <asp:Label ID="lbFdMc" Text='<%#DataBinder.Eval(Container.DataItem,"fdmc")%>' runat="server" />
                    </td>
                </tr>
            </table>
        </ItemTemplate>

完整前台代码：

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ShopList.aspx.cs" Inherits="NewGoodTrack.GoodsForms.ShopList" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> </head> <head> <title>WebForm8</title> <meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR"> <meta content="C#" name="CODE_LANGUAGE"> <meta content="javascript" name="vs_defaultClientScript"> <meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema"> </head> <body ms_positioning="GridLayout"> <form id="Form1" method="post" runat="server"> <asp:DataList ID="datalist1" AlternatingItemStyle-BackColor="#f3f3f3" Width="100%" CellSpacing="0" CellPadding="0" runat="server"> <ItemTemplate> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="30%" align="left"> <asp:CheckBox ID="CheckBox1" runat="server" /> <asp:Label ID="lbFdbh" Text=' <%#DataBinder.Eval(Container.DataItem,"fdbh")%>' runat="server" /> </td> <%--<td width="30%" align="center"><%#DataBinder.Eval(Container.DataItem,"senduser")%></td> --%> <td width="30%" align="center"> <asp:Label ID="lbFdMc" Text='<%#DataBinder.Eval(Container.DataItem,"fdmc")%>' runat="server" /> </td> </tr> </table> </ItemTemplate> <AlternatingItemStyle BackColor="#F3F3F3"></AlternatingItemStyle> </asp:DataList> <div align="center"> <asp:Button ID="BtnOk" runat="server" Text ="确认选择" onclick="BtnOk_Click" /> 共<asp:Label ID="LPageCount" runat="server" ForeColor="#ff0000"></asp:Label>页/共 <asp:Label ID="LRecordCount" runat="server" ForeColor="#ff0000"></asp:Label>记录 <asp:LinkButton ID="Fistpage" runat="server" CommandName="0" OnClick="Fistpage_Click">首页</asp:LinkButton> <asp:LinkButton ID="Prevpage" runat="server" CommandName="prev" OnClick="Prevpage_Click">上一页</asp:LinkButton> <asp:LinkButton ID="Nextpage" runat="server" CommandName="next" OnClick="Nextpage_Click">下一页</asp:LinkButton> <asp:LinkButton ID="Lastpage" runat="server" CommandName="last" OnClick="Lastpage_Click">尾页</asp:LinkButton> 当前第<asp:Label ID="LCurrentPage" runat="server" ForeColor="#ff0000"></asp:Label>页跳页<asp:TextBox ID="gotoPage" runat="server" Width="30px" MaxLength="5" AutoPostBack="True" ontextchanged="gotoPage_TextChanged"></asp:TextBox> </div> </form> </body> </html>

完整后台代码：

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Configuration; using MyPublic; using System.Data; namespace NewGoodTrack.GoodsForms { public partial class ShopList : System.Web.UI.Page { //定义每页显示记录 const int PageSize = 20; //定义几个保存分页参数变量 int PageCount, RecCount, CurrentPage, Pages, JumpPage; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //通过Calc()函数获取总记录数 RecCount = Calc(); //计算总页数（加上OverPage()函数防止有余数造成显示数据不完整） PageCount = RecCount / PageSize + OverPage(); //保存总页参数到ViewState（减去ModPage()函数防止SQL语句执行时溢出查询范围，可以用存储过程分页算法来理解这句） ViewState["PageCounts"] = RecCount / PageSize - ModPage(); //保存一个为0的页面索引值到ViewState ViewState["PageIndex"] = 0; //保存PageCount到ViewState，跳页时判断用户输入数是否超出页码范围 ViewState["JumpPages"] = PageCount; //显示LPageCount、LRecordCount的状态 LPageCount.Text = PageCount.ToString(); LRecordCount.Text = RecCount.ToString(); //判断跳页文本框失效 if (RecCount <= 20) { gotoPage.Enabled = false; } //调用数据绑定函数TDataBind()进行数据绑定运算 TDataBind(); } } //计算余页 public int OverPage() { int pages = 0; if (RecCount % PageSize != 0) pages = 1; else pages = 0; return pages; } //计算余页，防止SQL语句执行时溢出查询范围 public int ModPage() { int pages = 0; if (RecCount % PageSize == 0 && RecCount != 0) pages = 1; else pages = 0; return pages; } // 计算总记录的静态函数 // 本人在这里使用静态函数的理由是：如果引用的是静态数据或静态函数， // 连接器会优化生成代码，去掉动态重定位项（对海量数据表分页效果更明显）。 // 希望大家给予意见、如有不正确的地方望指正。 public static int Calc() { int RecordCount = 0; SqlCommand MyCmd = new SqlCommand("select count(*) as co from eCApFDInfo", MyCon()); SqlDataReader dr = MyCmd.ExecuteReader(); if (dr.Read()) RecordCount = Int32.Parse(dr["co"].ToString()); MyCmd.Connection.Close(); return RecordCount; } //数据库连接语句（从Web.Config中获取） public static SqlConnection MyCon() { SqlConnection MyConnection = new SqlConnection(ConfigClass.GetConfigString("appSettings", "ConnStr").ToString()); MyConnection.Open(); return MyConnection; } protected void Fistpage_Click(object sender, EventArgs e) { //从ViewState中读取页码值保存到CurrentPage变量中进行参数运算 CurrentPage = (int)ViewState["PageIndex"]; //从ViewState中读取总页参数运算 Pages = (int)ViewState["PageCounts"]; CurrentPage = 0; //将运算后的CurrentPage变量再次保存至ViewState ViewState["PageIndex"] = CurrentPage; //调用数据绑定函数TDataBind() TDataBind(); } protected void Prevpage_Click(object sender, EventArgs e) { //从ViewState中读取页码值保存到CurrentPage变量中进行参数运算 CurrentPage = (int)ViewState["PageIndex"]; //从ViewState中读取总页参数运算 Pages = (int)ViewState["PageCounts"]; CurrentPage--; //将运算后的CurrentPage变量再次保存至ViewState ViewState["PageIndex"] = CurrentPage; //调用数据绑定函数TDataBind() TDataBind(); } protected void Nextpage_Click(object sender, EventArgs e) { //从ViewState中读取页码值保存到CurrentPage变量中进行参数运算 CurrentPage = (int)ViewState["PageIndex"]; //从ViewState中读取总页参数运算 Pages = (int)ViewState["PageCounts"]; CurrentPage++; //将运算后的CurrentPage变量再次保存至ViewState ViewState["PageIndex"] = CurrentPage; //调用数据绑定函数TDataBind() TDataBind(); } protected void Lastpage_Click(object sender, EventArgs e) { //从ViewState中读取页码值保存到CurrentPage变量中进行参数运算 CurrentPage = (int)ViewState["PageIndex"]; //从ViewState中读取总页参数运算 Pages = (int)ViewState["PageCounts"]; CurrentPage = Pages; //将运算后的CurrentPage变量再次保存至ViewState ViewState["PageIndex"] = CurrentPage; //调用数据绑定函数TDataBind() TDataBind(); } private void TDataBind() { //从ViewState中读取页码值保存到CurrentPage变量中进行按钮失效运算 CurrentPage = (int)ViewState["PageIndex"]; //从ViewState中读取总页参数进行按钮失效运算 Pages = (int)ViewState["PageCounts"]; //判断四个按钮（首页、上一页、下一页、尾页）状态 if (CurrentPage + 1 > 1) { Fistpage.Enabled = true; Prevpage.Enabled = true; } else { Fistpage.Enabled = false; Prevpage.Enabled = false; } if (CurrentPage == Pages) { Nextpage.Enabled = false; Lastpage.Enabled = false; } else { Nextpage.Enabled = true; Lastpage.Enabled = true; } //数据绑定到DataList控件 DataSet ds = new DataSet(); //核心SQL语句，进行查询运算（决定了分页的效率:)） SqlDataAdapter MyAdapter = new SqlDataAdapter("Select Top " + PageSize + " * from eCApFDInfo where fdbh not in(select top " + PageSize * CurrentPage + " fdbh from eCApFDInfo order by fdbh asc) order by fdbh asc", MyCon()); MyAdapter.Fill(ds, "news"); datalist1.DataSource = ds.Tables["news"].DefaultView; datalist1.DataBind(); //显示Label控件LCurrentPaget和文本框控件gotoPage状态 LCurrentPage.Text = (CurrentPage + 1).ToString(); gotoPage.Text = (CurrentPage + 1).ToString(); //释放SqlDataAdapter MyAdapter.Dispose(); } protected void gotoPage_TextChanged(object sender, EventArgs e) { try { //从ViewState中读取可用页数值保存到JumpPage变量中 JumpPage = (int)ViewState["JumpPages"]; //判断用户输入值是否超过可用页数范围值 if (Int32.Parse(gotoPage.Text) > JumpPage || Int32.Parse(gotoPage.Text) <= 0) { Response.Write("<mce:script type="text/javascript"></mce:script>"); } else { //转换用户输入值保存在int型InputPage变量中 int InputPage = Int32.Parse(gotoPage.Text.ToString()) - 1; //写入InputPage值到ViewState["PageIndex"]中 ViewState["PageIndex"] = InputPage; //调用数据绑定函数TDataBind()再次进行数据绑定运算 TDataBind(); } } //捕获由用户输入不正确数据类型时造成的异常 catch (Exception eXP) { Response.Write("<mce:script type="text/javascript"></mce:script>"); } } /// <summary> /// 确认选择 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void BtnOk_Click(object sender, EventArgs e) { string strSaleShopList = string.Empty; for (int i = 0; i < datalist1.Items.Count; i++) { CheckBox ck = datalist1.Items[i].FindControl("CheckBox1") as CheckBox; Label lk = datalist1.Items[i].FindControl("lbFdbh") as Label; if (ck.Checked) { strSaleShopList = strSaleShopList +"''"+ lk.Text + "'',"; } } strSaleShopList = strSaleShopList.Substring(0, strSaleShopList.Length - 1); } } }