How to use ControlParameter in asp.net
Example: Country-->State-->City selection in asp.net
Asp.net Page Source:
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
#form1
{ height: 283px;
width: 218px; }
</style>
</head>
<body>
<form id="form1" runat="server">
<asp:SqlDataSource ID="SqldataSourceCountry" runat="server"
ConnectionString="<%$ ConnectionStrings:TestDBConnectionString %>"
SelectCommand="SELECT [countryID], [countryName] FROM [tblCountry] ORDER BY [countryName]">
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSourceState" runat="server"
ConnectionString="<%$ ConnectionStrings:TestDBConnectionString %>"
SelectCommand="SELECT [stateID], [stateName] FROM [tblState] WHERE ([countryID] = @countryID) ORDER BY [stateName]">
<SelectParameters>
<asp:ControlParameter ControlID="cmbCountry" DefaultValue="0" Name="countryID"
PropertyName="SelectedValue" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSourceCity" runat="server"
ConnectionString="<%$ ConnectionStrings:TestDBConnectionString %>"
SelectCommand="SELECT [cityId], [cityName] FROM [tblCity] WHERE ([stateID] = @stateID) ORDER BY [cityName]">
<SelectParameters>
<asp:ControlParameter ControlID="cmbStates" DefaultValue="0" Name="stateID"
PropertyName="SelectedValue" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
<br />Select Country:<br>
<asp:DropDownList ID="cmbCountry" runat="server"
DataSourceID="SqldataSourceCountry" DataTextField="countryName"
DataValueField="countryID" Height="18px" Width="169px" AutoPostBack="True">
</asp:DropDownList>
<br />
<br />Select State:<br />
<asp:DropDownList ID="cmbStates" runat="server"
DataSourceID="SqlDataSourceState" DataTextField="stateName"
DataValueField="stateID" Height="50px" Width="163px" AutoPostBack="True">
</asp:DropDownList>
<br />
<br />Select City <br />
<asp:DropDownList ID="cmbCity" runat="server" Height="33px" Width="167px"
DataSourceID="SqlDataSourceCity" DataTextField="cityName"
DataValueField="cityId">
</asp:DropDownList>
</form>
</body>
</html>
SQL Queries:
Create Country/State/City Tables as follows
CREATE TABLE [dbo].[tblCountry](
[countryID] [int] IDENTITY(1,1) NOT NULL,
[countryName] [varchar](50) NOT NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[tblState](
[stateID] [int] IDENTITY(1,1) NOT NULL,
[stateName] [varchar](50) NOT NULL,
[countryID] [int] NOT NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[tblCity](
[cityId] [int] IDENTITY(1,1) NOT NULL,
[cityName] [varchar](50) NOT NULL,
[stateID] [int] NOT NULL
) ON [PRIMARY]
Insert Data into tblCountry/State/City Tables
No comments:
Post a Comment