ADO Database ASP.Net

  1. Home
  2. ASP.Net
  3. ADO Database
  4. Executing a Stored Procedure using SqlDataSource Control
<%@ Page Language="C#" %>


    Executing a Stored Procedure using SqlDataSource Control


    
    

                    ProviderName="System.Data.SqlClient"
            ConnectionString="<%$ ConnectionStrings:AdventureWorks %>"
            SelectCommand="GetProductSubCategories" SelectCommandType="StoredProcedure">            
        
        Categories: 
                    DataValueField="ProductSubcategoryID" DataTextField="Name" AutoPostBack="true"
            ID="lstCategories" />
                    ProviderName="System.Data.SqlClient"
            ConnectionString="<%$ ConnectionStrings:AdventureWorks %>"
            SelectCommand="GetProductsByCategoryID" SelectCommandType="StoredProcedure">
            
                                    PropertyName="SelectedValue" />
            
        
                    HeaderStyle-HorizontalAlign="Center" HeaderStyle-Font-Bold="True"
            HeaderStyle-BackColor="blue" HeaderStyle-ForeColor="White" />