dropdown selection in .net

Question

1.00/5 (1 vote)

See more:

if one category select then display subcategory in dropdown.when select other category then display othe dropdown of subcategory...so how can i do it????

Posted 3-Jun-12 18:21pm

Member 9027483

Add a Solution

Comments

Sergey Alexandrovich Kryukov 4-Jun-12 0:23am

What's the problem?
--SA

3 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)

prateekfgiet · Answer 1 · 2012-06-03T18:27:00

Hi,

you must have 2 table in your database 1st table(Category_master) where you store category with his uniq id(PK),and category name.
and in second Table Category_Detail where store all sub category with CategoryId(FK).

on dropdown selected index changed event according to either selected item or value you can fill Sub category.

you need to bind subcategory dropdown at the time of categorydrop down selected index changed.

Linto Leo Tom · Answer 2 · 2012-06-03T18:37:00

Hi,

I think you are having mulitiple dropdowns and you want filteration on the changing of one dropdown for another dropdown. If it is like that, you can use selectedindexchange event of dropdown.

On the selected index change of the first dropdown, pass the value of the first dropdown to the your load method, and fill the result to the next drop down.

Happy Coding :)

vangapally Naveen Kumar · Answer 3 · 2012-06-03T18:43:00

try like this

under page load event load the dropdown1 then bind dropdown2 under dropdownlist1 selected index changed event
EX:

SQL

cmd = New SqlCommand("select * from sample", con)
        dr = cmd.ExecuteReader()

 DropDownList1.DataSource = dr
        DropDownList1.DataTextField = "name"
        DropDownList1.DataValueField = "name"

        DropDownList1.DataBind()
        dr.Close()
        con.Close()

under dropdownlist1 selected index changed event

SQL

Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropDownList1.SelectedIndexChanged
        con.Open()
        cmd = New SqlCommand("select * from sample1 where name='" + DropDownList1.SelectedItem.ToString() + "' ", con)
        dr = cmd.ExecuteReader()
        DropDownList2.DataSource = dr
        DropDownList2.DataTextField = "name"
        DropDownList2.DataValueField = "name"

        DropDownList2.DataBind()
        dr.Close()
        con.Close()

  End Sub

dropdown selection in .net

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0