sql查询以下问题 [英] sql quiry for the below prob
问题描述
Node_Property Property_Value
加密
加密关闭
Node_Channel 14
Node_Channel 15
信标模式开启
该表称为Node_Options
在第一个下拉列表中,应该出现Node_property,在第二个下拉列表中,应该出现相应的值
例如:如果选择了加密",则仅在第二个下拉列表中显示打开"和关闭".
请给我一个以上的SQL查询.前端是ASP.NET.后端编码是C#.
问候,
从表名中选择Property_value,其中node_property =''first dropdownlist selected item''
然后将property_value绑定到第二个下拉列表
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,
select Property_value from tablename where node_property=''first dropdownlist selected item''
then bind property_value to your second dropdown list
这篇关于sql查询以下问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!