ADO Net Database ASP.Net Tutorial

  1. Home
  2. ASP.Net Tutorial
  3. ADO Net Database
  4. Asp
<%@ Page Language="C#" AutoEventWireup="true"%>



    Untitled Page


    
    

        Categories:
                                   runat="server" 
                           ConnectionString="<%$ ConnectionStrings:Northwind %>"
                           SelectCommand="SELECT * FROM Categories">
        
                              runat="server" 
                      DataSourceID="sourceCategories" 
                      DataKeyNames="CategoryID">
            
                
            
            
            
            
        
        
        Products in this category:
                                   runat="server" 
                           ConnectionString="<%$ ConnectionStrings:Northwind %>"
                           SelectCommand="SELECT ProductID, ProductName, UnitPrice FROM Products WHERE CategoryID=@CategoryID">
            
              
            
        
                    >
            
            
            
        
    

    


File: Web.config