Display result in Gridview based on multiple seleted dropdown items.

Question

0.00/5 (No votes)

See more:

Hi

I want to Display result in Gridview based on multiple seleted dropdown items.i tried with single dropdownlist its working.But i want to select District in first dropdown, Select Taluka in Second Dropdown List, Select village in third drop down list. finally i want to display result in Gridview.

How do i do this any idea pls ..?

Posted 26-Sep-10 7:51am

shiva.kore

Add a Solution

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

Sandeep Mewara · Answer 1 · 2010-09-26T07:59:00

Solution 1

Well, you need to have Cascading Dropdown in place and then based on the dropdown values a filter on Grid data.

Google/CodeProjectSearch for Cascading dropdown. That would give you first part.
For filtering, at time of dropdown change you need to filter the data (dataview probably!) and then use that as source for your grid.

Try!

Posted 26-Sep-10 7:59am

Sandeep Mewara

Comments

shiva.kore 26-Sep-10 14:12pm

Thank You sandeep. let me try!

Abhijit Jana 27-Sep-10 1:12am

Sandeep, I am not sure that, he is looking for Cascading dropdown. As, he want to display the data based on the selection and he never told he wants to populate the dropdown list based on another dropdown.

Abhijit Jana · Answer 2 · 2010-09-26T19:11:00

Solution 2

How did you get the data when you used the single dropdown ? I beleive You are filtering the data based on the value dropdown. So, for multiple dropdown, you have to the same thing, where you have to write query like

select * from table name where Column1='dropdownlist1value' and column2='dropdownlist2value' and Columun='dropdownlist3value'

Based on the result set you can bind the data to grid.

Posted 26-Sep-10 19:11pm

Abhijit Jana

Comments

Sandeep Mewara 27-Sep-10 1:49am

But I am sure of that based on what he is selecting:
District -> Taluka -> Village

And based on the selection Grid data.

Abhijit Jana 27-Sep-10 2:01am

Yes, but I think OP is not looking for Cascadding Dropdown. If yes, then you are a good Mind Reader my friend ;)

MalikRizwan 27-Sep-10 9:12am

based on his question, logically its cascadding dropdown. as District has taluka and then village