How to generate DropDownListFor text and value field as table column name's?

Asked Dec 10 '15 at 12:50

Active Dec 10 '15 at 17:01

Viewed 28 times

I am facing the Issue where I have to generate a ddL from database in which value and text fields are the table column name's not row data.

like I have a table Employee in which my column name's are EmployeeId, EmplyeeName, EmpDept, EmpDesig, etc....

so how to populate dlL like this

text            value    
EmployeeId       EmployeeId
EmplyeeName      EmplyeeName
EmpDept          EmpDept
EmpDesig         EmpDesig

asked Dec 10 '15 at 12:50

Imran Luhur

Have you considered using UNPIVOT (https://msdn.microsoft.com/en-us/library/ms141723.aspx)? – David Rushton Dec 10 '15 at 13:08
This link https://dotnetfiddle.net/q4CfqA may help you – Ibrahim Khan Dec 10 '15 at 18:06
Azim try to understand the question please – Imran Luhur Dec 11 '15 at 06:38

0 Answers0