Editing-Data-with-the-FormView-Control

Data Binding ASP.Net Tutorial

            <%@ Page Language="C#" %>
  "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">


    
    
            id="frmProducts"
        DataSourceID="srcProducts"
        DataKeyNames="Id"
        AllowPaging="true"
        Runat="server">
        
        <%# Eval("Title") %>

        Directed By:
        <%# Eval("Director") %>
        
        Box Office Totals:
        <%#Eval("Totals", "{0:c}") %>
        
                    id="lnkEdit"
            Text="Edit Product"
            CommandName="Edit"
            Runat="server" />
        
        
                    id="lblTitle"
            Text="Product Title:"
            AssociatedControlID="txtTitle"
            Runat="server" />
        
                    id="txtTitle"
            Text='<%# Bind("Title") %>
            Runat="server" />
        
                    id="lblDirector"
            Text="Product Director:"
            AssociatedControlID="txtDirector"
            Runat="server" />
        
                    id="txtDirector"
            Text='<%# Bind("Director") %>
            Runat="server" />
        
                    id="lblTotals"
            Text="Box Office Totals:"
            AssociatedControlID="txtTotals"
            Runat="server" />
        
                    id="txtTotals"
            Text='<%# Bind("Totals") %>
            Runat="server" />
        
                    id="lnkUpdate"
            Text="Update Product"
            CommandName="Update"
            Runat="server" />
        |
                    id="lnkCancel"
            Text="Cancel Update"
            CommandName="Cancel"
            Runat="server" />
        
    
            id="srcProducts"
        ConnectionString="<%$ ConnectionStrings:Products %>"
        SelectCommand="SELECT Id,Title,Director,Totals
            FROM Products"
        UpdateCommand="UPDATE Products SET Title=@Title,
            Director=@Director,Totals=@Totals
            WHERE Id=@Id"
        Runat="server" />