Listing 1

<asp:sqldatasource id="sqldsEmployeeData" runat="server"
 selectcommand="GetEmployeeData"
 providername="System.Data.SqlClient" connectionstring="User ID=sa;Initial
 Catalog=Northwind;Data Source=HERMES-WIN2K3;" updatecommand="UpdateEmployeeData"
 onupdated="Employee_Updated" >
            <updateparameters>
      	<asp:parameter name="RETURN_VALUE" type="Int32" direction="ReturnValue">
         </asp:parameter>
         <asp:parameter name="LastName" type="String">
			</asp:parameter>
			<asp:parameter name="FirstName" type="String">
			</asp:parameter>
			<asp:parameter name="City" type="String">
			</asp:parameter>
			<asp:parameter name="Region" type="String">
			</asp:parameter>
			<asp:parameter name="PostalCode" type="String">
			</asp:parameter>
			<asp:parameter name="Country" type="String">
			</asp:parameter>
			<asp:parameter name="HomePhone" type="String">
			</asp:parameter>
			<asp:parameter name="Extension" type="String">
			</asp:parameter>
			<asp:parameter name="Notes" type="String">
			</asp:parameter>
			<asp:parameter name="EmployeeID" type="Int32">
                </asp:parameter>
            </updateparameters>
            <selectparameters>
                <asp:controlparameter name="EmployeeID"
			propertyname="SelectedValue" controlid="ddlEmployee">
                </asp:controlparameter>
            </selectparameters>
</asp:sqldatasource>


Listing 2

<%@ page language="C#" %>

<script runat="server">

    void EmployeeUpdated(object sender, SqlDataSourceStatusEventArgs e)
    {
        ddlEmployeeList.DataBind();
    }
</script>

<html>
<head runat="server">
    <title>SqlDataSource Data Page</title>
</head>
<body>
    <form runat="server">
        <asp:label id="Label1" runat="server">
            Employee:
         </asp:label>
         <asp:dropdownlist id="ddlEmployeeList"
		 runat="server" datavaluefield="EmployeeID"
		 datasourceid="sqldsEmployeeList" data	textfield="FullName"
		 autopostback="True">
       	</asp:dropdownlist>
         <asp:detailsview id="DetailsView1" runat="server"
		 datasourceid="sqldsEmployee Details" autogeneraterows="False"
		 backcolor="White" bordercolor="#999999" border	style="None"
		 borderwidth="1px" cell	padding="3" gridlines="Vertical" datakey
		 names="EmployeeID">
            <pagerstyle forecolor="Black" font-italic="False" font-bold="False"
			horizontalalign="Center" backcolor="#999999">
            </pagerstyle>
            <rowfields>
                <asp:templatefield showheader=
				"False" headertext= "FullName">
                    <itemtemplate>
						<asp:label width="100%" runat="server" text='<%#
						 DataBinder.Eval(Container, "DataItem.FullName") %>'
						 id="Label2" backcolor="#000040" forecolor="White">
                        </asp:label>
                    </itemtemplate>
			</asp:templatefield>
			<asp:boundfield insertvisible="False" visible="False"
			sortexpression="EmployeeID"
			datafield="EmployeeID" readonly="True"
			headertext="EmployeeID">
			</asp:boundfield>
			<asp:boundfield sortexpression="LastName"
			datafield="LastName" headertext= "LastName">
			</asp:boundfield>
			<asp:boundfield sortexpression="FirstName"
			datafield="FirstName" headertext="FirstName">
			</asp:boundfield>
			<asp:boundfield sortexpression="City"
			datafield="City" headertext="City">
			</asp:boundfield>
			<asp:boundfield sortexpression="Region"
			datafield="Region" headertext="Region">
			</asp:boundfield>
			<asp:boundfield 	
			sortexpression="PostalCode" datafield="PostalCode"
			headertext="PostalCode">
			</asp:boundfield>
			<asp:boundfield sortexpression="Country"
			datafield="Country" headertext="Country">
			</asp:boundfield>
			<asp:boundfield sortexpression="HomePhone"
			datafield="HomePhone" headertext="HomePhone">
			</asp:boundfield>
			<asp:boundfield sortexpression="Extension"
			datafield="Extension" headertext="Extension">
			</asp:boundfield>
			<asp:boundfield sortexpression="Notes"
			datafield="Notes" headertext="Notes">
			</asp:boundfield>
			<asp:commandfield showeditbutton="True">
			</asp:commandfield>
			</rowfields>
			<rowstyle forecolor="Black"
			backcolor="#EEEEEE" font-italic="False"	font-bold="False">
            </rowstyle>
            <headerstyle forecolor="White" backcolor="#000084"
			font-italic="False" font-bold="True">
            </headerstyle>
            <footerstyle forecolor="Black"
            backcolor="#CCCCCC" font-italic="False"
            font-bold="False">
            </footerstyle>
				</asp:detailsview>
				<asp:sqldatasource id="sqldsEmployeeList"
				runat="server" selectcommand="Select
				FirstName + ' ' + LastName as FullName,
				EmployeeID from Employees"
            	providername="System.Data.SqlClient"
	            connectionstring="User ID=bosco;Initial
    	        Catalog=Northwind;Data Source=HERMES-
        	    WIN2K3" enablecaching="True"
            	cacheduration="300">
	</asp:sqldatasource>
	<asp:sqldatasource id="sqldsEmployeeDetails"
	runat="server" selectcommand= "GetEmployeeData" 
	onupdated="EmployeeUpdated" providername=
	"System.Data.SqlClient"	connectionstring="User
	ID=bosco;Initial Catalog=Northwind;Data
	Source=HERMES-WIN2K3" enablecaching="True"
	cacheduration="300" updatecommand="UpdateEmployeeData">
	<updateparameters>
	<asp:parameter name="RETURN_VALUE" type="Int32"
	direction="ReturnValue">
	</asp:parameter>
	<asp:parameter name="LastName" type="String">
	</asp:parameter>
	<asp:parameter name="FirstName" type="String">
	</asp:parameter>
	<asp:parameter name="City" type="String">
	</asp:parameter>
	<asp:parameter name="Region" type="String">
	</asp:parameter>
	<asp:parameter name="PostalCode" type="String">
	</asp:parameter>
	<asp:parameter name="Country" type="String">
	</asp:parameter>
	<asp:parameter name="HomePhone" type="String">
	</asp:parameter>
	<asp:parameter name="Extension" type="String">
	</asp:parameter>
	<asp:parameter name="Notes" type="String">
	</asp:parameter>
	<asp:parameter name="EmployeeID" type="Int32">
	</asp:parameter>
	</updateparameters>
	<selectparameters>
	<asp:controlparameter name="RETURN_VALUE"
	propertyname="SelectedValue"
		type="Int32"
		direction="ReturnValue"	controlid="ddlEmployeeList">
		</asp:controlparameter>
			<asp:controlparameter name="EmployeeID" 
			propertyname="SelectedValue"
			type="Int32"
             controlid="ddlEmployeeList">
                </asp:controlparameter>
            </selectparameters>
        </asp:sqldatasource>

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