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.

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;
}

No comments:

Post a Comment