sql quiry for the below prob

Question

1.00/5 (2 votes)

See more:

hi There are two drop downlist in the front end of the screen.In the data base there is a table which has two columns as shown below.Node_Property and Property_value two columns in the table.
Node_Property Property_Value
Encryption On
Encryption Off
Node_Channel 14
Node_Channel 15
Beacon_Mode On

The table is called Node_Options
In the first dropdown list Node_property Should come and in the second dropdown list The corresponding value should come
Ex: If Encryption is selected only On and Off should be displayed in the second dropdown list.

Please give me an sql quiry for the above.The front end is ASP.NET.Back end coding is C#.

Regards,

Posted 26-Aug-11 20:50pm

sandeepatil

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)

hitech_s · Answer 1 · 2011-08-26T20:57:00

Solution 1

select Property_value from tablename where node_property='first dropdownlist selected item'

then bind property_value to your second dropdown list

Posted 26-Aug-11 20:57pm

hitech_s

Updated 26-Aug-11 21:26pm

v2

Comments

hitech_s 27-Aug-11 2:58am

giv me feedback by leaving a comment

sandeepatil 27-Aug-11 3:05am

ok there are five properties in the first dropdownlist.If the user selects different at different times.the we cant write perticular selected item in the dropdownlist. like
when Encryption is selected only on off should come or if node channel is selected then 14 and 15 should come.Bt above quiry restricted to one
selected item.

hitech_s 27-Aug-11 3:23am

if u dont mind can u post the code what u have write