Home
Browse all 647 examples
Download all 647 examples
Download sample chapters
Reviews
Errata
Acknowledgments
Links on .NET
Paradoxal Press
Buy directly from Paradoxal Press at $33.99 (Save 43%)
Category: Programming
Level: Beginner to seasoned
900 pages
ISBN-10 097661322-0
ISBN-13 978-097661322-0
$59.99 USA
$79.99 CANADA
|
Listing 23-61 extracted from chapter ASP.NET 2
Listing 23-60< > Listing 23-62
Example_23_61.aspx
<%@ Page Language="C#" %>
<html xmlns="http://www.w3.org/1999/xhtml" >
<body>
<form id="Form1" runat="server">
<asp:SqlDataSource ID="DataSrc1" runat="server" ConnectionString=
"server = localhost ; uid=sa ; pwd =; database = ORGANIZATION"
SelectCommand=
"SELECT DISTINCT DepId FROM EMPLOYEES ORDER BY DepId" />
<asp:DropDownList ID="ListDep" DataSourceID="DataSrc1"
DataTextField="DepId" Autopostback="true" runat="server" />
<asp:SqlDataSource ID="DataSrc2" runat="server" ConnectionString=
"server = localhost ; uid=sa ; pwd =; database = ORGANIZATION"
SelectCommand="SELECT * FROM EMPLOYEES WHERE DepId=@ParamDepId">
<SelectParameters>
<asp:ControlParameter Name="ParamDepId" ControlID="ListDep"
PropertyName="SelectedValue" />
</SelectParameters>
</asp:SqlDataSource>
<asp:ListBox ID="MyList" DataSourceID="DataSrc2" runat="server"
DataTextField="SurName" />
</form>
</body>
</html>
Copyright Patrick Smacchia 2006 2007
|