ADO Net Database ASP.Net Tutorial

<%@ Page Language="C#" AutoEventWireup="true" %>



    Untitled Page


    
    

                           runat="server" 
                       ConnectionString="<%$ ConnectionStrings:Northwind %>"
                       SelectCommand="SELECT * FROM Products">
            
                                  runat="server" 
                          AutoPostBack="True" 
                          DataSourceID="sourceProducts"
                          DataTextField="ProductName" 
                          DataValueField="ProductID" 
                          Width="184px">
        
        
                                   runat="server" 
                           ConnectionString="<%$ ConnectionStrings:Northwind %>"
              SelectCommand="SELECT * FROM Products WHERE ProductID=@ProductID">
            
                                              ControlID="lstProducts" 
                                  PropertyName="SelectedValue" />
            

        
                                  runat="server" 
                          DataSourceID="sourceProductFull"
                          Width="184px" 
                          CellPadding="5">
            
                In Stock:
                    <%# Eval("UnitsInStock") %>
                    
                    On Order:
                    <%# Eval("UnitsOnOrder") %>
                    
                    Reorder:
                    <%# Eval("ReorderLevel") %>
                    
                
            

        
    

    


File: Web.config