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 subidsub1sub2sub3 and etc. And I want to bind these column names to the dropdown list in my frontend(.NET).

Nanhe Siddique · Answer

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

Shuvojit Halder · Answer

Your sql query will be like that select COLUMN_NAMEORDINAL_POSITION from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='Subject' then you bind the result in your dropdown.