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-73 extracted from chapter ASP.NET 2


Listing 23-72<     > Listing 23-74



Example_23_73.aspx
<%@ Page Language="C#" %>
<html xmlns="http://www.w3.org/1999/xhtml" >
  <body>
    <form id="Form1" runat="server">
      <asp:SqlDataSource ID="DataSrc" runat="server" ConnectionString=
          "server = localhost; uid=sa ; pwd =; database = ORGANIZATION"
          SelectCommand="SELECT EmployeeId, SurName, Phone FROM EMPLOYEES" 
          UpdateCommand= "UPDATE EMPLOYEES SET Phone = @Phone WHERE 
                          EmployeeId = @Original_EmployeeId"/>
      <asp:FormView ID="Details" DataSourceID="DataSrc" runat="server" 
                    DataKeyNames="EmployeeId"  AllowPaging="True" >
         <ItemTemplate>
             SurName: <%# Eval("SurName") %> <br/>
             Phone: <%# Eval("Phone") %> <br/>
             <asp:Button ID="BtnEdit" runat="server" CommandName="Edit"
             Text="Edit phone number"/>
         </ItemTemplate>
         <EditItemTemplate>
             SurName: <%# Eval("SurName") %> <br/>
             Phone: <asp:TextBox ID="EditPhone" runat="server" 
                                      Text=<%# Bind("Phone") %> /> <br/>
            <asp:Button ID="BtnUpdate" CommandName="Update"
                        Text="Update phone number." runat="server" />
            <asp:Button ID="BtnCancel" CommandName="Cancel"
                        Text="Cancel update" runat="server" />
         </EditItemTemplate>
      </asp:FormView>
    </form>
  </body>
</html>	
Copyright Patrick Smacchia 2006 2007