Bind List To DDL (Dificulty)
private void BindLocationsDDL()
{
try
{
ddlLocations.AppendDataBoundItems = true;
//ddlLocations.AutoPostBack = true;
ddlLocations.Items.Clear();
ddlLocations.Items.Add(new ListItem("---Select Location---", "-1"));
//SPSecurity.RunWithElevatedPrivileges(delegate()
//{
using (SPSite objSite = new SPSite(SPContext.Current.Site.Url))
{
using (SPWeb objWeb = objSite.OpenWeb())
{
if (!string.IsNullOrEmpty(strLocation))
{
SPList objLocationList = objWeb.Lists[strLocation];
DataTable dtLocations = new DataTable();
if (objLocationList.Items.Count > 0)
{
dtLocations = objLocationList.Items.GetDataTable();
ddlLocations.DataSource = dtLocations;
ddlLocations.DataTextField = "LocationName";
ddlLocations.DataValueField = "ID";
ddlLocations.DataBind();
}
else
{
lblerror.Visible = true;
lblerror.Text += "There is no Locations in " + strLocation + " list";
}
}
else
{
lblerror.Visible = true;
lblerror.Text += "There is no list for Locations";
}
}
}
// });
}
catch (Exception ex)
{
lblerror.Visible = true; lblerror.ForeColor = Color.Red; lblerror.Text += "Error : " + ex.Message;
}
}
Comments