Loading

Getting data in sharepoint list using drop down control

Sree

Hi,

I have created a list in sharepoint 2010 in that i have two columns empname and emplocation
i added items to it and i want to show emplocation as a drop down list need to show in web part using microsoft visual studio i want to take drop down control in asp.net.

1 Reply

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

Manesh Golekar12y ago
You can pull sharepoint list data and bind emplocation to your drop down . here is sample code

using (SPSite site = new SPSite("<>"))
{
using (SPWeb web = site.OpenWeb())
{
SPList list = web.Lists["<>"];
ddl.DataSource = list.Items;
ddl.DataValueField = "emplocation";
ddl.DataTextField = "emplocation";
ddl.DataBind();
}
}