Bind Sharepoint list data to asp.net dropdown list

Sanjana V

9y3.6k

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!

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajkiran Swain9y ago
What is the error you are getting ?
Sanjana V9y ago
Hey! this doesn't work I mean with the following lines :
SPList list = web.Lists["NameOfYourList"];
MatGrp.DataSource = list.Items;
Rajkiran Swain9y ago
1. using (SPSite site = new ("http://yoursharepointsite"))
2. {
3. using (SPWeb web = site.OpenWeb())
4. {
5. SPList list = web.Lists["NameOfYourList"];
6. MatGrp.DataSource = list.Items;
7. MatGrp.DataValueField = "Title"; // List field holding value - first column is called Title anyway!
8. MatGrp.DataTextField = "Title"; // List field holding name to be displayed on page
9. MatGrp.DataBind();
10. }
11. }
14. "gvDetail" runat="server" CellPadding="4" EnableModelValidation="True" ForeColor="#333333" GridLines="None" autogeneratecolumns="False">
17. "No">
19. "No" runat="server" Text=''>
22. "Group">
24. "MatGrp" runat="server">