Bind SharePoint List Items in a Gridview

Vinodh Narayanan
9y
89.4k
0
3

Article

Open the team site.

Create a sample list “Employee”.

Add some values into the list.

Open Visual Studio then create a new Visual Webpart.

Enter a valid site URL then select Deploy as a Farm solution.

Create a new Visual Webpart in the project.

Now open EmployeeRegistration.ascx.

Create a GridView.

Code

<asp:GridView ID="mygrid" runat="server" AutoGenerateColumns="false">
<Columns>
<asp:BoundField DataField="Name" HeaderText="
Name" />
<asp:BoundField DataField="Email" HeaderText="Email" />
</Columns>
</asp:GridView>

Now open EmployeeRegistration.ascx.cs.

Code

using System;
using System.ComponentModel;
using System.Web.UI.WebControls.WebParts;
using Microsoft.SharePoint;
using System.Data;
namespace BindListData.EmployeeRegistration
{
[ToolboxItemAttribute(false)]
public partial class EmployeeRegistration : WebPart
{
// Uncomment the following SecurityPermission attribute only when doing Performance Profiling on a farm solution
// using the Instrumentation method, and then remove the SecurityPermission attribute when the code is ready
// for production. Because the SecurityPermission attribute bypasses the security check for callers of
// your constructor, it's not recommended for production purposes.
// [System.Security.Permissions.SecurityPermission(System.Security.Permissions.SecurityAction.Assert, UnmanagedCode = true)]
public EmployeeRegistration()
{
}
protected override void OnInit(EventArgs e)
{
base.OnInit(e);
InitializeControl();
}
protected void Page_Load(object sender, EventArgs e)
{
SPWeb web = SPContext.Current.Web;
SPList list = web.Lists["Employee"];
SPListItemCollection items = list.Items;
mygrid.DataSource = items.GetDataTable();
mygrid.DataBind();
}
}
}