About Me

Having 12 years experience in Microsoft technologies.Since more than 7 years working in SharePoint technologies. Expert in providing consultation for SharePoint projects. Hands on with development and administration.
Showing posts with label webpart. Show all posts
Showing posts with label webpart. Show all posts

Thursday, 12 December 2013

Binding Drop-Down with Sharepoint List data



if (!Page.IsPostBack)
{
    DataSet ds = new DataSet();
    SPSite mySite = SPContext.Current.Site;
    SPWeb myWeb = mySite.OpenWeb();
    SPList list = myWeb.Lists["ListName"];
    DataTable DTable_List = list.Items.GetDataTable();
    DTable_List.TableName = "Table1";
    ds.Tables.Add(DTable_List);

    DropDownList.DataSource = ds.Tables["Table1"];
    DropDownList.DataTextField = "FieldName";
    DropDownList.DataValueField = "FieldName";
    DropDownList.DataBind();
    DropDownList.SelectedIndex = 0;
}