,

Bind Drop-down with SharePoint List and display list items in a Gridview

SharePointCafe Admin Avatar
In this blog, I will explain about below point through C# code:
1. Bind all list in a dropdown
2 Load List items in a Gridview once a user changes list name in dropdown.

You need to create a visual webpart in Visual studio 2010.

Visual WebPart ASCX code:

<asp:DropDownList ID=”ddlList” AutoPostBack=”true” runat=”server” 
    onselectedindexchanged=”ddlList_SelectedIndexChanged”>
</asp:DropDownList>
<p>
    <asp:Label ID=”lblItemCount” runat=”server” Text=””></asp:Label>
</p>
<asp:GridView ID=”gvListItem” AutoGenerateColumns=”false” runat=”server”>
</asp:GridView>

Visual Webpart .ascx.cs code:

Add below name space:

using Microsoft.SharePoint;

 protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                var web = SPContext.Current.Web;
                ddlList.DataSource = web.Lists;
                ddlList.DataTextField = “Title”;
                ddlList.DataBind();
            }
        }

        protected void ddlList_SelectedIndexChanged(object sender, EventArgs e)
        {
            
            var web = SPContext.Current.Web;
            var list = web.Lists[ddlList.SelectedItem.Text];
            lblItemCount.Text = list.Items.Count.ToString();
            gvListItem.DataSource = list.Items.GetDataTable();
            gvListItem.DataBind();

        }

Tagged in :

SharePointCafe Admin Avatar

One response to “Bind Drop-down with SharePoint List and display list items in a Gridview”

  1. Unknown Avatar

    Thanks so much! Your instructions are very clear and helpful. I've been wondering how to do this for months and thrilled to find out how finally!
    sharepoint developer training

Leave a Reply

Your email address will not be published. Required fields are marked *

RSS
YouTube
YouTube
Instagram