ASP.NET中 DropDownList+GridView(网格视图)的使用前台绑定[高]。

ASP.NET中 DropDownList+GridView(网格视图)的使用前台绑定[高]_GridView

ASP.NET中 DropDownList+GridView(网格视图)的使用前台绑定[高]_DropDownList_02ASP.NET中 DropDownList+GridView(网格视图)的使用前台绑定[高]_sql_03View Code 

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

<!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 />
    该大分类下的产品<br />

        <asp:GridView ID="gvwYuanBo" runat="server" AllowPaging="True" 
            AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="ProductID" 
            DataSourceID="SqlDataSource2">
            <Columns>
                <asp:CommandField ShowSelectButton="True" />
                <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" />
            </Columns>
        </asp:GridView>
        <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>
        <br />

    </div>
    </form>
</body>
</html>


/web.config


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