How to bind database table column names to the dropdown list

Question

Hai Sir,
       I have one table "Subject" in my database with column names subid,sub1,sub2,sub3 and etc.
        And I want to bind these column names to the dropdown list in my frontend(.NET).

 

Answer 1

hi sureshma

 

read this link

 

http://www.aspsnippets.com/Articles/Bind-Fill-Populate-DropDownList-control-from-database-in-ASPNet-using-C-and-VBNet.aspx 

 

it may help you 

 

Answer 2

Your sql query will be like that

 

 

select COLUMN_NAME,ORDINAL_POSITION from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='Subject'

 

 

 

then you bind the result in your dropdown.