Category dropdown filter should only include categories that are actually has data ? How to generate dynamic dropdown ?

Question

0.00/5 (No votes)

See more:

Hi,

I have a dropdown which gets filled from databse . this is actually a filter.
on selected index change of this drop down i am showing data in gridview which is related to that id of selected index.

But now what i want to do is i want to display only those categories in dropdowns which are surely give me the data .. There should not be else part in selected index changed .. if nothing found related to selected dropdown id then "No data available". I want 100 persent sure categories from databse ..

How can i do that plz suggest .

Posted 19-Oct-13 0:59am

Torakami

Add a Solution

1 solution

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)

thatraja · Accepted Answer · 2013-10-21T03:17:00

Torakami wrote:
But now what i want to do is i want to display only those categories in dropdowns which are surely give me the data

It's not a big deal. Just load the data which matches the details table data.
For example, you have two tables Country & City.

------------------------------
Country
------------------------------
CountryID | CountryName
------------------------------
1         | US
2         | UK
3         | Canada
------------------------------
City
------------------------------
CountryID CityID | CityName
------------------------------
1        |1      | New york
1        |2      | Los Angles
2        |1      | London
2        |2      | Luton
------------------------------

Now you have to write a query to load Available Countries(for Dropdown) like below

SQL

SELECT B.CountryID,A.CountryName FROM Country A, City B
WHERE A.CountryID=B.CountryID

Now it'll load only Countries which has cities.

------------------------------
Available Countries
------------------------------
CountryID | CountryName
------------------------------
1         | US
2         | UK
------------------------------

That's it.