Bind Sharepoint list data to asp.net dropdown list

Question

I have an employee list in Sharepoint 2013 that has 2 lookup fields(manager and department).

I want to know how to bind the lookup field values to the asp.net DropDownList.

So I get a dropdown with SharePoint list data bound to the gridview.

Thanks! Please help!

Rajkiran Swain · Answer

What is the error you are getting ?

Sanjana V · Answer

Hey! this doesn't work I mean with the following lines : SPList list = web.Lists[ NameOfYourList ]; MatGrp.DataSource = list.Items;

Rajkiran Swain · Answer

using (SPSite site = new ( http://yoursharepointsite )) { using (SPWeb web = site.OpenWeb()) { SPList list = web.Lists[ NameOfYourList ]; MatGrp.DataSource = list.Items; MatGrp.DataValueField = Title ; // List field holding value - first column is called Title anyway! MatGrp.DataTextField = Title ; // List field holding name to be displayed on page MatGrp.DataBind(); } } gvDetail runat= server CellPadding= 4 EnableModelValidation= True ForeColor= #333333 GridLines= None autogeneratecolumns= False > No > No runat= server Text= '' > Group > MatGrp runat= server >