Data Binding ASP.Net Tutorial

  1. Home
  2. ASP.Net Tutorial
  3. Data Binding
  4. Set asp
<%@ Page Language="C#" %>



    Untitled Page


    
    

                      runat="server" 
                  DataSourceID="sourceProducts"
                  AutoGenerateColumns="False" 
                  DataKeyNames="ProductID">           
        
          
          
          
          
        
    
                           runat="server" 
                       SelectCommand="SELECT ProductID, ProductName, UnitPrice FROM Products" 
                       ConnectionString="<%$ ConnectionStrings:Northwind %>"
                       UpdateCommand="UPDATE Products SET ProductName=@ProductName, UnitPrice=CONVERT(money,@UnitPrice) WHERE ProductID=@ProductID">
    
    

    


File: Web.config