DataList的用法

最新推荐文章于 2018-11-18 13:14:20 发布
最新推荐文章于 2018-11-18 13:14:20 发布
阅读量508 收藏 1
点赞数
分类专栏： 代码天堂 知识文档 文章标签： server asp dataset textbox class object
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/blue_sky_16/article/details/7100717
版权

1 数据绑定,绑定的方式为

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

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

{

    SqlConnection sqlcon;

    string strCon = "Data Source=(local);Database=db_04;Uid=sa;Pwd=why20080104019";

    protected void Page_Load(object sender, EventArgs e)

    {

        sqlcon = new SqlConnection(strCon);

        string sqlstr = "select top 1* from tb_Member";

        SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);

        DataSet myds = new DataSet();

        sqlcon.Open();

        myda.Fill(myds, "tb_Member");

        DataList1.DataSource = myds;

        DataList1.DataBind();

        DataRowView mydrv = myds.Tables["tb_Member"].DefaultView[0];//ds中缓存的表格“tb_Member”

        for (int i = 0; i <= DataList1.Items.Count - 1; i++)

        {

            Label lab = (Label)DataList1.Items[i].FindControl("Label1");

            int money = Convert.ToInt32(mydrv["money"]);

            lab.Text = money.ToString("￥#,###.00");

        }

        sqlcon.Close();

    }

}

2.分页功能

int curpage = Convert.ToInt32(this.Label2.Text.ToString().Trim());

        PagedDataSource ps = new PagedDataSource();

        sqlcon = new SqlConnection(strcon);

        SqlDataAdapter sda = new SqlDataAdapter("select * from tb_GoodsType", sqlcon);

        DataSet ds = new DataSet();

        sda.Fill(ds, "tb_GoodsType");

        ps.DataSource = ds.Tables["tb_GoodsType"].DefaultView;

        ps.AllowPaging = true;

        ps.PageSize = 2;//实现分页

        LinkButton1.Enabled = true;

        LinkButton2.Enabled = true;

        LinkButton3.Enabled = true;

        LinkButton4.Enabled = true;

        ps.CurrentPageIndex = curpage-1;

        if (curpage == 1)

        {

            this.LinkButton1.Enabled = false;

            this.LinkButton2.Enabled = false;

        }

        if (curpage == ps.PageCount)

        {

            this.LinkButton3.Enabled = false;

            this.LinkButton4.Enabled = false;

        }

        this.Label3.Text = Convert.ToString(ps.PageCount);

        DataList1.DataSource = ps;

        this.DataList1.DataKeyField = "GoodsTypeID";

        DataList1.DataBind();

}

2.查找Datalist中的控件

CheckBox cb=（CheckBox）Datalist.Item[0].FindControl(“CheckBox1”)

Datalist的属性是：

  <asp:DataList ID="DataList1" runat="server" BorderColor="#FFFF99"

            BorderWidth="2px" onitemdatabound="DataList1_ItemDataBound" Height="400px"

            ondeletecommand="DataList1_DeleteCommand" Width="300px">

            <ItemTemplate>

                <table class="style1">

                    <tr>

                    <td>

                        &nbsp;</td>

                        <td class="style2">

                            <span lang="zh-cn">ID：</span></td>

                        <td>

                            <asp:Label ID="Label1" runat="server"

                                Text='<%# DataBinder.Eval(Container.DataItem,"ID") %>'></asp:Label>

                        </td>

                    </tr>

                    <tr>

                     <td>

                         &nbsp;</td>

                        <td class="style2">

                            <span lang="zh-cn">姓名：</span></td>

                        <td>

                            <asp:Label ID="Label2" runat="server"

                                Text='<%# DataBinder.Eval(Container.DataItem,"au_lname") %>'></asp:Label>

                        </td>

                    </tr>

                    <tr>

                     <td>

                         &nbsp;</td>

                        <td class="style2">

                            <span lang="zh-cn">性别：</span></td>

                        <td>

                            <asp:DropDownList ID="DropDownList1" runat="server" DataTextField="sex"

                                DataValueField="sex">

                                <asp:ListItem>男</asp:ListItem>

                                <asp:ListItem>女</asp:ListItem>

                            </asp:DropDownList>

                        </td>

                    </tr>

                    <tr>

                     <td class="style3">

                         <asp:CheckBox ID="cb1" runat="server" Text="勾选此项" AutoPostBack="True" />

                        </td>

                        <td class="style4">

                            <span lang="zh-cn">学位：</span></td>

                        <td class="style3">

                            <asp:Label ID="Label3" runat="server"

                                Text='<%# DataBinder.Eval(Container.DataItem,"state") %>'></asp:Label>

                        </td>

                    </tr>

                    <tr>

                     <td>

                         &nbsp;</td>

                        <td class="style2">

                            <span lang="zh-cn">电话:</span></td>

                        <td>

                            <asp:Label ID="Label4" runat="server"

                                Text='<%# DataBinder.Eval(Container.DataItem,"phone") %>'></asp:Label>

                        </td>

                    </tr>

                    <tr>

                     <td>

                         &nbsp;</td>

                        <td class="style2">

                            <span lang="zh-cn">地址：</span></td>

                        <td>

                            <asp:Label ID="Label5" runat="server"

                                Text='<%# DataBinder.Eval(Container.DataItem,"address") %>'></asp:Label>

                        </td>

                    </tr>

                    <tr><td></td>

                    <td class="style2">

                        <asp:LinkButton ID="LinkButton1" runat="server" CommandName="delete">删除该项目</asp:LinkButton>

                        </td>

                    <td></td>

                    </tr>

                </table>

            </ItemTemplate>

        </asp:DataList>

具体的代码是：

protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e)

    {

        SqlCon = new SqlConnection(strcon);

        for (int i = 0; i < DataList1.Items.Count; i++)

        {

            CheckBox cb = (CheckBox)DataList1.Items[i].FindControl("cb1");

            if (cb.Checked)

            {

                string strdel = "delete from tb_mrEmp05 where ID='" + DataList1.DataKeys[i].ToString() + "'";

                SqlCon.Open();

                SqlCommand sqlcmd = new SqlCommand(strdel, SqlCon);

                sqlcmd.ExecuteNonQuery();

                SqlCon.Close();

            }

            else

            {

                Response.Write("请选择！");

            }

        }

        bind();

    }

3.Datalist实现自动编号功能

protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)

    {

        int id = e.Item.ItemIndex+1;

        ((Label)e.Item.FindControl("Label3")).Text = id.ToString();

 

    }

4.Datalist实现删除功能

在Datalist中的Button控件的Commandname必须设置为delete

protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e)

    {

        string strdel="delete from tb_Revert where RevertID='"+DataList1.DataKeys[e.Item.ItemIndex].ToString()+"'";

       sqlcon=new SqlConnection(strcon);

        sqlcon.Open();

        SqlCommand sqlcmd=new SqlCommand(strdel,sqlcon);

        sqlcmd.ExecuteNonQuery();

        sqlcon.Close();

        bind();

    }

5.Datalist实现主细表

Datalist的详细属性是：

  <asp:DataList ID="DataList1" runat="server" BackColor="#DEBA84"

            BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px" CellPadding="3"

            CellSpacing="2" GridLines="Both">

            <FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />

            <ItemStyle BackColor="#FFF7E7" ForeColor="#8C4510" />

            <SelectedItemStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />

            <HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />

            <ItemTemplate>

                <table class="style1">

                    <tr>

                        <td>

                            <span lang="zh-cn">员工ID：</span><asp:Label ID="Label1" runat="server"

                                Text='<%# DataBinder.Eval(Container.DataItem,"UserID") %>'></asp:Label>

                        </td>

                    </tr>

                    <tr>

                        <td>

                            <asp:DataList ID="DataList2" runat="server" DataSource='<%#((System.Data.DataRowView)Container.DataItem).CreateChildView("tableRelation") %>' DataKeyField="UserID">

            <ItemTemplate>

               UserID:

                <asp:Label ID="UserIDLabel" runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"UserID") %>' />

              

                UserLoginName:

                <asp:Label ID="UserLoginNameLabel" runat="server"

                    Text='<%# DataBinder.Eval(Container.DataItem,"UserLoginName") %>' />

              

                UserSex:

                <asp:Label ID="UserSexLabel" runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"UserSex") %>' />

               <br />

                UserPwd:

                <asp:Label ID="UserPwdLabel" runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"UserPwd") %>' />

             

                UserName:

                <asp:Label ID="UserNameLabel" runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"UserName") %>' />

                 <br />

                UserQuePwd:

                <asp:Label ID="UserQuePwdLabel" runat="server"

                    Text='<%# DataBinder.Eval(Container.DataItem,"UserQuePwd") %>' />

               

                UserAnsPwd:

                <asp:Label ID="UserAnsPwdLabel" runat="server"

                    Text='<%# DataBinder.Eval(Container.DataItem,"UserAnsPwd") %>' />

                <br />

                UserTel:

                <asp:Label ID="UserTelLabel" runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"UserTel") %>' />

             

                UserEmail:

                <asp:Label ID="UserEmailLabel" runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"UserEmail") %>' />

                 <br />

                UserAddress:

                <asp:Label ID="UserAddressLabel" runat="server"

                    Text='<%# DataBinder.Eval(Container.DataItem,"UserAddress") %>' />

            

                UserPostCode:

                <asp:Label ID="UserPostCodeLabel" runat="server"

                    Text='<%# DataBinder.Eval(Container.DataItem,"UserPostCode") %>' />

                <br />

                UserQQ:

                <asp:Label ID="UserQQLabel" runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"UserQQ") %>' />

               

                UserDate:

                <asp:Label ID="UserDateLabel" runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"UserDate") %>' />

                

            </ItemTemplate>

        </asp:DataList></td>

                    </tr>

                </table>

            </ItemTemplate>

       </asp:DataList> 

后台代码是：

protected void Page_Load(object sender, EventArgs e)

    {

        string strselect = "select top 3* from tb_EmpID select top 3a.*,b.UserID from tb_Employee as a inner join tb_EmpID as b on a.UserID=b.UserID";

        SqlConnection sqlcon = new SqlConnection("Data Source=localhost;Initial Catalog=db_04;uid=sa;pwd=why20080104019");

        sqlcon.Open();

        SqlDataAdapter sda = new SqlDataAdapter(strselect, sqlcon);

        DataSet ds = new DataSet();

        sda.Fill(ds);

        ds.Tables[0].TableName = "tb_EmpID";

        ds.Tables[1].TableName = "tb_Employee";

        DataColumn Parent = ds.Tables["tb_EmpID"].Columns["UserID"];

        DataColumn Child = ds.Tables["tb_Employee"].Columns["UserID"];

        DataRelation tableRelation = new DataRelation("tableRelation", Parent, Child,false);

        ds.Relations.Add(tableRelation);

        DataList1.DataSource = ds.Tables["tb_EmpID"].DefaultView;

        DataList1.DataBind();

        sqlcon.Close();

 ｝

6.Datalist实现编辑功能：

.Datalist的属性为：

<asp:DataList ID="DataList1" runat="server"

            oncancelcommand="DataList1_CancelCommand" oneditcommand="DataList1_EditCommand"

            onupdatecommand="DataList1_UpdateCommand">

            <EditItemTemplate>

                <table class="style2">

                    <tr>

                        <td>

                            <span lang="zh-cn">类型编号</span></td>

                        <td>

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

                        </td>

                    </tr>

                    <tr>

                        <td>

                            <span lang="zh-cn">类型名称</span></td>

                        <td>

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

                        </td>

                    </tr>

                    <tr>

                        <td>

                            <span lang="zh-cn">商店名称</span></td>

                        <td>

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

                        </td>

                    </tr>

                    <tr>

                    <td>

                        <asp:Button ID="Button2" runat="server" Text=" 更新" CommandName="update" />

                        </td> <td>

                            <asp:Button ID="Button3" runat="server" CommandName="cancel" Text="取消"

                                οnclick="Button3_Click" />

                        </td>

                    </tr>

                </table>

            </EditItemTemplate>

            <ItemTemplate>

                <table class="style1">

                    <tr>

                        <td>

                            <span lang="zh-cn">姓名：</span></td>

                        <td>

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

                        </td>

                        <td>

                            <asp:Button ID="Button1" runat="server" CommandName="edit" Text="编辑" />

                        </td>

                    </tr>

                </table>

            </ItemTemplate>

        </asp:DataList>

后台代码是：

protected void DataList1_EditCommand(object source, DataListCommandEventArgs e)//进入编辑状态

    {

        DataList1.EditItemIndex = e.Item.ItemIndex;

        bind();

    }

    protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e)//取消编辑    {

        DataList1.EditItemIndex = -1;

        bind();

    }

    protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e)//实现更新

    {

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

        string strname = ((TextBox)e.Item.FindControl("TextBox1")).Text;

        string strstore = ((TextBox)e.Item.FindControl("TextBox2")).Text;

        string strupdate = "update tb_GoodsType set GoodsTypeName='"+strname+"',StoreID='"+strstore+"' where GoodsTypeID='"+id+"'";

        sqlcon = new SqlConnection(strcon);

        SqlCommand sqlcmd = new SqlCommand(strupdate, sqlcon);

        sqlcon.Open();

        sqlcmd.ExecuteNonQuery();

        sqlcon.Close();

        DataList1.EditItemIndex = -1;

        bind();

    }

}

7.DataList的查看详细信息功能

:DataList的属性为：

asp:DataList ID="DataList1" runat="server"

            onitemcommand="DataList1_ItemCommand">

            <ItemTemplate>

                <table class="style1">

                    <tr>

                        <td>

                            商品<span lang="zh-cn">编号：</span></td>

                        <td>

                            <asp:LinkButton ID="LinkButton1" runat="server"

                                Text='<%# Eval("GoodsTypeName") %>' CommandName="select"></asp:LinkButton>

                        </td>

                    </tr>

                </table>

            </ItemTemplate>

            <SelectedItemTemplate>

                <table class="style1">

                    <tr>

                        <td class="style2">

                            <span lang="zh-cn">类型编号：</span></td>

                        <td>

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

                        </td>

                        <td>

                            &nbsp;</td>

                    </tr>

                    <tr>

                        <td class="style2">

                            <span lang="zh-cn">类型名称：</span></td>

                        <td>

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

                        </td>

                        <td>

                            &nbsp;</td>

                    </tr>

                    <tr>

                        <td class="style2">

                            <span lang="zh-cn">&nbsp;&nbsp;&nbsp; 供应商：</span></td>

                        <td>

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

                        </td>

                        <td>

                            &nbsp;</td>

                    </tr>

                    <tr>

                     </td>

                        <td class="style2">

                    <td>

                        <asp:LinkButton ID="LinkButton2" runat="server" CommandName="back">返回</asp:LinkButton>

                    </td>

                     </td>

                        <td>

                    </tr>

                </table>

            </SelectedItemTemplate>

        </asp:DataList>

后台代码是：

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

{

    SqlConnection sqlcon;

    string strcon = "Data Source=localhost;Initial Catalog=db_04;uid=sa;pwd=why20080104019";

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {

            bind();

        }

    }

    protected void bind()

    {

        sqlcon = new SqlConnection(strcon);

        SqlDataAdapter sda = new SqlDataAdapter("select * from tb_GoodsType", sqlcon);

        DataSet ds = new DataSet();

        sda.Fill(ds, "tb_GoodsType");

        DataList1.DataSource = ds;

        DataList1.DataKeyField = "GoodsTypeID";

        DataList1.DataBind();

    }

    protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)

    {

        if (e.CommandName == "back")

        {

            DataList1.SelectedIndex = -1;

            bind();

        }

        if (e.CommandName == "select")

        {

            DataList1.SelectedIndex = e.Item.ItemIndex;

            bind();

        }

 

    }

 

 

blue_sky_16
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
DataList用法
11-20
DataList用法DataList用法DataList用法DataList用法DataList用法DataList用法DataList用法DataList用法DataList用法
asp.net datalist 用法
10-29
asp.net datalist 用法,需要的朋友可以参考下。
datalist的用法
黄长旭的专栏
11-27 673
DataList 提供相关的编辑模板，但和DataGrid不一样的是，DataList没有编辑按钮。要在DataList中使用编辑功能,可在项模板中增加一个按 钮，Linkbutton和Button都可以。在CommandName中设置为Edit就可以把此按钮和DataList的编辑事件联系起来了。 如： 编辑按钮可以使用CommandName="Edit" 更新按钮可以使用CommandN
DataList用法总结
半亩方塘
11-12 1892
设计模版： 页眉    页脚 数据记录     交替显示项 选中时的显示方式     编辑时的显示方式    数据记录分隔符 编辑模版，里面可以嵌入控件,绑定数据。                      设置外观 RepeatLayout         属性设置显示方式RepeatDirection      显示方向RepeatColumns       列数事
datalist用法详解
06-13
2. **删（移除选项）**: 使用`removeChild()`或jQuery的`remove()`方法删除指定的`<option>`。 ```javascript $('#browsers option[value="OldOption"]').remove(); ``` 3. **改（修改选项）**: 直接修改`...
VB DataList用法-源码演示.rar
07-10
本资源"VB DataList用法-源码演示.rar"旨在帮助初学者快速理解和掌握DataList控件的使用方法。 DataList控件通常用于展示数据库或数组中的数据，它可以以网格或其他自定义布局展示数据项。以下是一些关于VB ...
Datalist用法
半亩方塘
11-12 1523
dataolist绑定判断：       Item效果：//类里写    RowCreated事件用GridView public static void rowColor(GridViewRow row)    {       if (row.RowType == DataControlRowType.DataRow){row.Attributes.Add("onmouseover","
DataList 用法详解
weixin_30710457的博客
12-16 1351
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="DataList.aspx.cs" Inherits="FileUpload自动上传文件.DataList" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http...
datalist简单用法
11-20
简述html中datalist的一些简单应用场景以及示例。
DataList的使用
03-27
Android开发中常用的控件DataList的详细使用方法讲解，很实用，对Android开发初学者很有帮助
DataList
web开发自学
07-15 193
今天几天一下午的时候都在弄这个东西，所以觉得很有必要总结一下，dataList也是第一次用，以前用repeater的时候比较多。下面就通过几个小例子来展开吧，也是对自己学习的一个回顾。 基本内容介绍： datalist中的模板： datalist中的四个常用事件： 一、利用sqldatasource作为数据源，让它呈现数据。（这种方法不需要写一个代码就可以实现。） 1...
DataList的基本用法
李艳平
11-15 2070
今天在做项目的时候我又学到了一些新的东西！DataList的用法！下面我来简单的讲一下啊！    我今天用到的DateList是因为我要做一个显示我数据库中某个表里存的日志信息！这需要一个格式！比如说：标题，内容，发表人，发表时间！    这样，同学给介绍了DateList！    第一步，在工具栏的数据里，找到DateList！然后为了方便布局，可以建一个表！也就是table!    第
DataList的使用方法及代码
记事本
09-07 1068
        ICollection CreateDataSource() {        DataTable dt = new DataTable();        DataRow dr;        dt.Columns.Add(new DataColumn("IntegerValue", typeof(Int32)));        dt.Colum
【Asp.net之旅】--数据绑定控件之DataList
热门推荐
航帆远洋
03-28 3万+
       上篇博客讨论了Repeater控件的基本用法，它是最基本的数据绑定控件，只提供了数据绑定的功能，熟练运用Repeater控件后，其它类似的数据绑定控件就很简单了。接着我们上篇博客的内容继续，今天来讨论下DataList的基本使用方法。 一、绑定控件之DataList        该控件可以以自定义的格式显示各种数据源的字段，其显示数据的格式在创建的模板中定义，可
datalist
qi1271199790的博客
01-16 1万+
在Web设计中,经常会用到如输入框的自动下拉提示,这将大大方便用户的输入。在以前，如果要实现这样的功能，必须要求开发者使用一些Javascript的技巧或相关的框架进行ajax调用，需要一定的编程工作量。但随着HTML5 的慢慢普及，开发者可以使用其中的新的DataList标记就能快速开发出十分漂亮的 AutoComplete组件的效果   一、datalist标签的使用示例  
H5之datalist
weixin_43727391的博客
11-18 917
&amp;lt;!DOCTYPE html&amp;gt; &amp;lt;html&amp;gt; &amp;lt;head&amp;gt; &amp;lt;meta charset=&quot;UTF-8&quot;&amp;gt; &amp;lt;title&amp;gt;&amp;lt;/title&amp;gt; &amp;lt;/head&amp;gt;
ASP.NET DataList控件详解及应用实例
本文档主要介绍了ASP.NET中的DataList控件的使用方法和特性，适合于ASP.NET程序设计的学习者。主要内容分为以下几个部分： 1. **DataList控件概述**： DataList控件是基于模板的数据绑定控件，类似于Repeater控件...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值