ASP.NET中 DropDownList+DetailsView(详细视图)的使用前台绑定

ylbtech-ASP.NET-Control-Bind:DropDownList+DetailsView(详细视图)的使用前台绑定

ASP.NET中 DropDownList+DetailsView(详细视图)的使用前台绑定。

1.A,运行效果图返回顶部

View Code

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="DropDvw.aspx.cs" Inherits="DropDvw" %>

<!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>
<body>
    <form id="form1" runat="server">
    <div>
        请选择大分类：<asp:DropDownList ID="dropYuanBo" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource1"
            DataTextField="CategoryName" DataValueField="CategoryID">
        </asp:DropDownList>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
            SelectCommand="SELECT [CategoryID], [CategoryName] FROM [Categories]"></asp:SqlDataSource>
        <hr />
        该类的产品：
        <asp:DetailsView ID="dvwYuanBo" runat="server" Height="50px" Width="125px" DataSourceID="SqlDataSource2"
            AllowPaging="True" AutoGenerateRows="False" DataKeyNames="ProductID">
            <Fields>
                <asp:BoundField DataField="ProductID" HeaderText="ProductID" InsertVisible="False"
                    ReadOnly="True" SortExpression="ProductID" />
                <asp:BoundField DataField="ProductName" HeaderText="ProductName" SortExpression="ProductName" />
                <asp:BoundField DataField="CategoryID" HeaderText="CategoryID" SortExpression="CategoryID" />
                <asp:BoundField DataField="UnitPrice" HeaderText="UnitPrice" SortExpression="UnitPrice" />
            </Fields>
        </asp:DetailsView>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
            SelectCommand="SELECT [ProductID], [ProductName], [CategoryID], [UnitPrice] FROM [Products] WHERE ([CategoryID] = @CategoryID)">
            <SelectParameters>
                <asp:ControlParameter ControlID="dropYuanBo" DefaultValue="1" Name="CategoryID" PropertyName="SelectedValue"
                    Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
    </div>
    </form>
</body>
</html>

/web.config

<connectionStrings>
        <add name="NorthwindConnectionString" connectionString="Data
                    Source=.;Initial Catalog=Northwind;Integrated Security=True"
                        providerName="System.Data.SqlClient"/>
    </connectionStrings>

1.C,资源下载返回顶部

https://files.cnblogs.com/ylbtech/WebForm-Drop-XList.rar

作者：ylbtech
出处：http://ylbtech.cnblogs.com/
本文版权归作者和博客园共有，欢迎转载，但未经作者同意必须保留此段声明，且在文章页面明显位置给出原文连接，否则保留追究法律责任的权利。

posted on 2013-03-05 10:46 ylbtech 阅读(810) 评论(0) 编辑收藏举报