1.A,运行效果图
1.B,源代码
复制代码 代码如下:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="DropLvw.aspx.cs" Inherits="DropLvw" %>
<!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 runat="server">
<div>
请选择大分类：<asp:DropDownList runat="server" AutoPostBack="True"
DataSourceID="SqlDataSource1" DataTextField="CategoryName"
DataValueField="CategoryID">
</asp:DropDownList>
<asp:SqlDataSource runat="server"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand="SELECT [CategoryID], [CategoryName] FROM [Categories]">
</asp:SqlDataSource>
<hr />
该分类下的产品：<br />
<asp:ListView runat="server" DataKeyNames="ProductID"
DataSourceID="SqlDataSource2">
<ItemTemplate>
<tr>
<td>
<asp:Label runat="server" Text='<%# Eval("ProductID") %>' />
</td>
<td>
<asp:Label runat="server"
Text='<%# Eval("ProductName") %>' />
</td>
<td>
<asp:Label runat="server"
Text='<%# Eval("CategoryID") %>' />
</td>
<td>
<asp:Label runat="server" Text='<%# Eval("UnitPrice") %>' />
</td>
</tr>
</ItemTemplate>
<AlternatingItemTemplate>
<tr>
<td>
<asp:Label runat="server" Text='<%# Eval("ProductID") %>' />
</td>
<td>
<asp:Label runat="server"
Text='<%# Eval("ProductName") %>' />
</td>
<td>
<asp:Label runat="server"
Text='<%# Eval("CategoryID") %>' />
</td>
<td>
<asp:Label runat="server" Text='<%# Eval("UnitPrice") %>' />
</td>
</tr>
</AlternatingItemTemplate>
<EmptyDataTemplate>
<table runat="server">
<tr>
<td>
未返回数据。</td>
</tr>
</table>
</EmptyDataTemplate>
<InsertItemTemplate>
<tr>
<td>
<asp:Button runat="server" CommandName="Insert" Text="插入" />
<asp:Button runat="server" CommandName="Cancel" Text="清除" />
</td>
<td>
</td>
<td>
<asp:TextBox runat="server"
Text='<%# Bind("ProductName") %>' />
</td>
<td>
<asp:TextBox runat="server"
Text='<%# Bind("CategoryID") %>' />
</td>
<td>
<asp:TextBox runat="server"
Text='<%# Bind("UnitPrice") %>' />
</td>
</tr>
</InsertItemTemplate>
<LayoutTemplate>
<table runat="server">
<tr runat="server">
<td runat="server">
<table runat="server">
<tr runat="server">
<th runat="server">
ProductID</th>
<th runat="server">
ProductName</th>
<th runat="server">
CategoryID</th>
<th runat="server">
UnitPrice</th>
</tr>
<tr runat="server">
</tr>
</table>
</td>
</tr>
<tr runat="server">
<td runat="server">
</td>
</tr>
</table>
</LayoutTemplate>
<EditItemTemplate>
<tr>
<td>
<asp:Button runat="server" CommandName="Update" Text="更新" />
<asp:Button runat="server" CommandName="Cancel" Text="取消" />
</td>
<td>
<asp:Label runat="server"
Text='<%# Eval("ProductID") %>' />
</td>
<td>
<asp:TextBox runat="server"
Text='<%# Bind("ProductName") %>' />
</td>
<td>
<asp:TextBox runat="server"
Text='<%# Bind("CategoryID") %>' />
</td>
<td>
<asp:TextBox runat="server"
Text='<%# Bind("UnitPrice") %>' />
</td>
</tr>
</EditItemTemplate>
<SelectedItemTemplate>
<tr>
<td>
<asp:Label runat="server" Text='<%# Eval("ProductID") %>' />
</td>
<td>
<asp:Label runat="server"
Text='<%# Eval("ProductName") %>' />
</td>
<td>
<asp:Label runat="server"
Text='<%# Eval("CategoryID") %>' />
</td>
<td>
<asp:Label runat="server" Text='<%# Eval("UnitPrice") %>' />
</td>
</tr>
</SelectedItemTemplate>
</asp:ListView>
<asp:SqlDataSource runat="server"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand="SELECT [ProductID], [ProductName], [CategoryID], [UnitPrice] FROM [Products] WHERE ([CategoryID] = @CategoryID)">
<SelectParameters>
<asp:ControlParameter ControlID="drop" DefaultValue="1"
PropertyName="SelectedValue" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
/web.config
复制代码 代码如下: