Bind SharePoint List Items in a Gridview

Vinodh Narayanan

11y90.4k19100Article

ASP.NET SharePoint GridViewBind SharePoint List

19 Comments

Join the conversation! Your thoughts help the community grow.

Mahipal Reddy8y ago
Simple and good one
- Vinodh Narayanan8y ago
  Thanks for your valuable comment
venkat Kotaiah8y ago
Thanks a lot it helped me lot
Vinodh Narayanan11y ago
Vaikesh K P Thanks a lot
Vaikesh K P11y ago
Nice
Vinodh Narayanan11y ago
Gowtham Rajamanickam Thanks a lot
Gowtham Rajamanickam11y ago
good one...
Vinodh Narayanan11y ago
Karthikeyan K Thank u
Karthikeyan K11y ago
Thanks for share sir..
Vinodh Narayanan11y ago
Gopi Chand thank you
Gopi Chand11y ago
Very nice
Vinodh Narayanan11y ago
Santhakumar Munuswamy Thanks sir
Santhakumar Munuswamy11y ago
Thanks for Nice article
Vinodh Narayanan11y ago
Thank you guys
Mohammed Ibrahim11y ago
nice....
Sibeesh Venu11y ago
Nice Share
Vinodh Narayanan11y ago
Thanks a lot friends
Rajeesh Menoth11y ago
Nice One
Rakesh11y ago
Good one

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

Now deploy the webpart.

Deploy

Now the result.

result

Happy SharePointing!

Regards: Vinodh.N (SharePoint developer / administrator).