Loading

Error: Data Not show in asp.net dropdown from sharepointList

Error: Data Not show in asp.net dropdown from sharepointList

sachin soni

8y775

I Write that code on page load of visual webpart

if (!Page.IsPostBack)

{

using (SPSite site = new SPSite("http://spserver:1500"))

{

using (SPWeb web = site.OpenWeb())

{

web.AllowUnsafeUpdates = true;

SPList list = web.Lists["questionslist"];

ddlsecurity.DataSource = list.Items;

ddlsecurity.DataValueField = "Title"; // List field holding value - first column is called Title anyway!

ddlsecurity.DataTextField = "Title"; // List field holding name to be displayed on page

ddlsecurity.DataBind();

ddlsecurity.Items.Insert(0, new ListItem("--Select--", ""));

}

}

}

4 Replies

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

Sanghamitra Mohanty8y ago
Accepted answer
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. }
1. <asp:GridView ID="gvDetail" runat="server" CellPadding="4" EnableModelValidation="True" ForeColor="#333333" GridLines="None" autogeneratecolumns="False">
2. <Columns>
3. <asp:TemplateField HeaderText="No">
4. <ItemTemplate>
5. <asp:TextBox ID="No" runat="server" Text=''>asp:TextBox>
6. ItemTemplate>
7. asp:TemplateField>
8. <asp:TemplateField HeaderText="Group">
9. <ItemTemplate>
10. <asp:DropDownList ID="MatGrp" runat="server">
11. asp:DropDownList>
12. ItemTemplate>
13. asp:TemplateField>
14. Columns>
15. asp:GridView>
try it .
0

Reshma Bhalekar

Reshma Bhalekar8y ago

What error you are getting? Can you please post it.

0

Reshma Bhalekar

Reshma Bhalekar8y ago

Hi Sachin,

Try below code

protected void Page_Load(object sender, EventArgs e) {

try {

using(SPSite site = new SPSite("Server url")) {

using(SPWeb web = site.OpenWeb()) {

if (!Page.IsPostBack) {

BindData(web);

}

}

}

} catch (Exception) {}

}

public void BindData(SPWeb oweb) {

SPList list = oweb.Lists["lstName"];

ddlv.DataSource = list.Items;

ddlv.DataValueField = "Title";

ddlv.DataTextField = "Title";

ddlv.DataBind();

}

I tried it and it is working properly.

0

Nanddeep Nachan

Nanddeep Nachan8y ago

Please refer below article:

https://www.c-sharpcorner.com/UploadFile/746cd9/bind-dropdownlist-in-sharepoint-using-C-Sharp/

0