How to cascading dropdownlist in gridview in asp.net?

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

Dear sir,

I want to Display three dropwnlist in gridview.
First DropdownList As Country.
Second DropdownList As State.
third DropdownList As District.
How to bind multiple DropDownList in Gridview in asp.net?
Then
How to implement cascading of Dropdownlist in Gridview in asp.net?

Please You will send link or Code.

Thanks
Mahendra Kumar Das

Posted 4-Apr-11 22:56pm

Mahendra kumar das

Add a Solution

8 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Orcun Iyigun** · Answer 1 · 2011-04-05T00:06:00

Solution 3

Well there is a control named:
ASP.NET AJAX Cascading Drop Down Control :) you can implement it easily;
AJAX Cascading Drop Down Control[^]
AJAX Cascading Drop Down with Database[^]
A video tutorial[^]
A similar example that you may want to look[^]

Posted 5-Apr-11 0:06am

Orcun Iyigun

Updated 5-Apr-11 0:07am

v2

Mahendra.p25 · Answer 2 · 2011-04-04T22:59:00

Solution 1

Try this Link

Link [^]

Posted 4-Apr-11 22:59pm

Mahendra.p25

Updated 16-Jul-13 20:21pm

v2

Sandeep Mewara · Answer 3 · 2011-04-05T00:37:00

Solution 4

Have a look at these:
Implementing Cascading DropDownList in ASP.NET GridView[^]
Ajax Cascading DropDownList With Database Example in GridView[^]

If needed, look here[^] for more.

Posted 5-Apr-11 0:37am

Sandeep Mewara

P RAJENDAR REDDY · Answer 4 · 2012-07-09T00:27:00

Solution 5

check this solution http://www.4microsoftsolutions.com/post/CascadingDropDown-Control-in-ASPNET-AJAX.aspx[^]

Posted 9-Jul-12 0:27am

P RAJENDAR REDDY

Naufel Basheer · Answer 5 · 2013-05-27T19:26:00

Solution 6

Implementation of MVC3 Cascading Dropdown using jQuery[^]

Posted 27-May-13 19:26pm

Naufel Basheer

Vindhyachal_Kumar · Answer 6 · 2013-07-16T21:54:00

Use the below code

XML

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>

<!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>

    <script type="text/javascript" language="javascript">
        var actionRID = "";
        function BindStates(objThis) {
            var countryID = objThis.options[objThis.selectedIndex].value;
            if (countryID > 0) {
                PageMethods.getStates(countryID, onSuccessgetStates, onErrorgetStates);
                actionRID = objThis.id.split("_")[1].split("ctl")[1];
            }
        }
        function onSuccessgetStates(result, userContext, methodName) {
            var objState = document.getElementById("GridView1_ctl" + actionRID + "_ddlState");
            objState.options.length = 0;
            objState.add(new Option("--Select--", "0"));
            for (var i = 0; i < result.length; i++) {
                objState.add(new Option(result[i].StateName, result[i].StateID));
            }
        }
        function onErrorgetStates() {
            alert("error in retrieving Cities.");
            var objState = document.getElementById("GridView1_ctl" + actionRID + "_ddlState");
            objState.options.length = 0;
        }

        function BindCities(objThis) {
            var CityID = objThis.options[objThis.selectedIndex].value;
            if (CityID > 0) {
                PageMethods.getCities(CityID, onSuccessgetCities, onErrorgetCities);
                actionRID = objThis.id.split("_")[1].split("ctl")[1];
            }
        }
        function onSuccessgetCities(result, userContext, methodName) {
            var objState = document.getElementById("GridView1_ctl" + actionRID + "_ddlCity");
            objState.options.length = 0;
            objState.add(new Option("--Select--", "0"));
            for (var i = 0; i < result.length; i++) {
                objState.add(new Option(result[i].CityName, result[i].CityID));
            }
        }
        function onErrorgetCities() {
            alert("error in retrieving Cities.");
            var objState = document.getElementById("GridView1_ctl" + actionRID + "_ddlCity");
            objState.options.length = 0;
        }
    </script>

</head>
<body>
    <form id="form1" runat="server">
    <asp:ScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="true">
    </asp:ScriptManager>
    <div>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
            <Columns>
                <asp:BoundField DataField="ID" HeaderText="ID" />
            </Columns>
            <Columns>
                <asp:TemplateField HeaderText="Country">
                    <ItemTemplate>
                        <asp:DropDownList runat="server" ID="ddlCountry" onchange="BindStates(this)">
                            <asp:ListItem Text="--Select--" Value="0">
                            </asp:ListItem>
                            <asp:ListItem Text="INDIA" Value="1">
                            </asp:ListItem>
                        </asp:DropDownList>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
            <Columns>
                <asp:TemplateField HeaderText="State">
                    <ItemTemplate>
                        <asp:DropDownList runat="server" ID="ddlState" onchange="BindCities(this)">
                        </asp:DropDownList>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
            <Columns>
                <asp:TemplateField HeaderText="City">
                    <ItemTemplate>
                        <asp:DropDownList runat="server" ID="ddlCity">
                        </asp:DropDownList>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
        </asp:GridView>
    </div>
    </form>
</body>
</html>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Web.Services;

public partial class Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        DataTable dt = new DataTable("tbl1");
        dt.Columns.Add("ID");
        for (int i = 0; i < 10; i++)
        {
            DataRow dr = dt.NewRow();
            dr["ID"] = "ROW " + i.ToString();
            dt.Rows.Add(dr);
        }
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }


    [WebMethod]
    public static StateList getStates(Int32 countryID)
    {
        StateList oBOStateList = new StateList();

        if (countryID == 1)
        {
            oBOStateList.Add(new State { StateID = 1, StateName = "New Delhi" });
            oBOStateList.Add(new State { StateID = 2, StateName = "UP" });
            oBOStateList.Add(new State { StateID = 3, StateName = "BIHAR" });
            oBOStateList.Add(new State { StateID = 4, StateName = "West Bengal" });
        }

        return oBOStateList;
    }

    [WebMethod]
    public static CityList getCities(Int32 cityID)
    {
        CityList oBOCityList = new CityList();

        switch (cityID)
        {
            case 1:
                oBOCityList.Add(new City { CityID = 1, CityName = "Lajpat Nagar" });
                oBOCityList.Add(new City { CityID = 2, CityName = "South Ex." });
                oBOCityList.Add(new City { CityID = 3, CityName = "Nehru Place" });
                oBOCityList.Add(new City { CityID = 4, CityName = "Greater Kailash" });
                break;
            case 2:
                oBOCityList.Add(new City { CityID = 1, CityName = "NOIDA" });
                oBOCityList.Add(new City { CityID = 2, CityName = "Ghaziabad" });
                oBOCityList.Add(new City { CityID = 3, CityName = "Kanpur" });
                oBOCityList.Add(new City { CityID = 4, CityName = "Lucknow" });
                break;
            case 3:
                oBOCityList.Add(new City { CityID = 1, CityName = "Patna" });
                oBOCityList.Add(new City { CityID = 2, CityName = "Aurangabad" });
                oBOCityList.Add(new City { CityID = 3, CityName = "Gaya" });
                oBOCityList.Add(new City { CityID = 4, CityName = "Jahanabad" });
                break;
            default:
                break;
        }

        return oBOCityList;
    }
}

public class State
{
    public State()
    { }

    public Int32 StateID
    { get; set; }
    public string StateName
    { get; set; }
}
public class StateList : List<State>
{
    public StateList()
    { }
}

public class City
{
    public City()
    { }

    public Int32 CityID
    { get; set; }
    public string CityName
    { get; set; }
}
public class CityList : List<City>
{
    public CityList()
    { }
}

Zafar A khan · Answer 7 · 2013-07-16T21:53:00

Solution 8

C#

do it through  SqlDataSource

Posted 16-Jul-13 21:53pm

Zafar A khan

Pratik Bhesaniya · Answer 8 · 2011-04-04T23:16:00

Hi Mahendra,

Try this,

First you have to create 3 DropDown into your aspx page and set AutoPostBack="ture" and also it's OnCheckedChanged Event which will call code behind function.

First in Page load you have to bind Country DropDown and on Country DropDown OnCheckedChanged event you have to bind State DropDown and on State DropDown OnCheckedChanged event you have to bind City DropDown .

Like This,

On .Aspx Page :=

XML

<asp:DropDownList ID="ddlCountry" runat="server" Width="100%" AutoPostBack="true"
                                                       CausesValidation="false" 
                                                       OnSelectedIndexChanged="ddlCountry_SelectedIndexChanged" CssClass="divisionClass">
                                                   </asp:DropDownList>

XML

<asp:DropDownList ID="ddlState" runat="server" AutoPostBack="true" Width="100%" OnSelectedIndexChanged="ddlState_SelectedIndexChanged"
                                                        CausesValidation="false"  CssClass="divisionClass">
                                                    </asp:DropDownList>

XML

<asp:DropDownList ID="ddlCity" runat="server" AutoPostBack="true" Width="100%" OnSelectedIndexChanged="ddlCity_SelectedIndexChanged"
                                                        CausesValidation="false"  CssClass="divisionClass">
                                                    </asp:DropDownList>

On Code Behind Page that is .cs :=

In Page Load Write Below Function :

SQL

ddlCountry.DataSource = fn_getCountry()
            ddlCountry.DataTextField = "CountryName"
            ddlCountry.DataValueField = "CountryID"
            ddlCountry.DataBind()
            ddlCountry.Items.Insert(0, New ListItem("Select Country", ""))
            ddlState.Items.Insert(0, New ListItem("Select State", ""))
            ddlCity.Items.Insert(0, New ListItem("Select City", ""))
            ddlState.Enabled = False
            ddlCity.Enabled = False

then

C#

protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e)
{
<pre lang="sql">ddlState.DataSource = fn_getStateByCountryID(countryID)
                ddlState.DataTextField = "StateName"
                ddlState.DataValueField = "StateID"
                ddlState.DataBind()
                ddlState.Items.Insert(0, New ListItem("Select State", ""))
                ddlCity.SelectedIndex = 0
                ddlState.Enabled = True
                ddlCity.Enabled = False

}

C#

protected void ddlState_SelectedIndexChanged(object sender, EventArgs e)
{

<pre lang="sql">ddlCity.DataSource = fn_getCityByStateID(stateID)
                ddlCity.DataTextField = "CityName"
                ddlCity.DataValueField = "CityID"
                ddlCity.DataBind()
                ddlCity.Items.Insert(0, New ListItem("Select City", ""))
                ddlCity.Enabled = True

}

C#

protected void ddlCity_SelectedIndexChanged(object sender, EventArgs e)
{

}

Here,
fn_getCountry is a function which will Execute a query and Holding a list of Country.
fn_getStateByCountryID(countryID) is function which will hold a State list of Selected Country.
and
fn_getCityByStateID(stateID) is function which will hold a City list of Selected State.

All d Best,

I Hope this will help You.