Change-parameters-of-SqlDataSource-in-your-own-code


            <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="SqlDataSourceLimits" %>
               "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">


    Untitled Page


    
    
                                   runat="server" 
                           ProviderName="System.Data.SqlClient" 
                           ConnectionString="<%$ ConnectionStrings:Northwind %>" 
                           SelectCommand="SELECT EmployeeID, FirstName, LastName, Title, City FROM Employees WHERE City=@City" 
                           OnSelecting="sourceEmployees_Selecting">
            
                                                      Name="City" 
                                      PropertyName="SelectedValue" />
            
        
                                   runat="server" 
                           ProviderName="System.Data.SqlClient" 
                           ConnectionString="<%$ ConnectionStrings:Northwind %>" 
                           SelectCommand="SELECT DISTINCT City FROM Employees">
        
                                  runat="server"
                          DataTextField="City" 
                          Width="205px" 
                          AutoPostBack="True" >
        
        
                              runat="server" 
                      DataSourceID="sourceEmployees" 
                      CellPadding="4"
                      Font-Names="Verdana" 
                      Font-Size="Small" 
                      ForeColor="Navy" 
                      GridLines="None" 
                      AutoGenerateColumns="False" 
                      DataKeyNames="EmployeeID">
            
            
            
            
            
            
            
                                    ReadOnly="True" SortExpression="EmployeeID" />
                
                
                
                
            
        
    
    

    


File: Default.aspx.cs
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class SqlDataSourceLimits : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
    if (!Page.IsPostBack)
    {
      lstCities.DataSource = sourceEmployeeCities.Select(DataSourceSelectArguments.Empty);
      lstCities.DataBind();
      lstCities.Items.Insert(0, "(Choose a City)");
      lstCities.Items.Insert(1, "(All Cities)");
      lstCities.SelectedIndex = 0;
    }
    }
  protected void sourceEmployees_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
  {
    if ((string)e.Command.Parameters["@City"].Value == "(Choose a City)")
    {
      e.Cancel = true;
    }
    else if ((string)e.Command.Parameters["@City"].Value == "(All Cities)")
    {
      e.Command.CommandText = "SELECT * FROM Employees";
    }
  }
}
File: Web.config
ADO Database ASP.Net
