I have one query table that holds three columns namely id, name, query. I want to bind id as a value name as a text in drop down and when I change the drop down list that query column is executed in web grid dynamically. I don't know how to do this.
Thank you
| qry_id |
qry_name |
qry_query |
| 1 |
customer |
select cus_name, cus_street, cus_address, cus_place, cus_mobile from customer_master |
| 2 |
product |
select sup_code, sup_name from supplier_master |