Retrieve Listdata Using CAML in SharePoint 2010 Programmatically Using VS 2012

</tr>

<tr>

<td align="center">

<br />

<br />

<asp:gridview id="GridView1" runat="server" backcolor="LightGoldenrodYellow" bordercolor="Tan"

borderwidth="1px" cellpadding="2" enablemodelvalidation="True" forecolor="Black"

gridlines="None" autogeneratecolumns="False"><AlternatingRowStyle BackColor="PaleGoldenrod" /><FooterStyle BackColor="Tan" /><HeaderStyle BackColor="Tan" Font-Bold="True" /><PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue" HorizontalAlign="Center" /><SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" /><Columns><asp:BoundField DataField="ID" HeaderText="Student Id" ReadOnly="true" SortExpression="ID" /><asp:BoundField DataField="Title" HeaderText="First Name" ReadOnly="true" /><asp:BoundField DataField="LastName" HeaderText="Last Name" ReadOnly="true" /><asp:BoundField DataField="Age" HeaderText="Age" ReadOnly="true" /></Columns></asp:gridview>

</td>

</tr>

</table>

</div>

Step 5: The complete code of visualwebpart1usercontrol.ascx.cs looks like this:

using Microsoft.SharePoint;

using System;

using System.ComponentModel;

using System.Web.UI.WebControls.WebParts;namespace RetrieveListDataUsingCAML.VisualWebPart1

{

[ToolboxItemAttribute(false)]

public partial class VisualWebPart1 : WebPart

{// Uncomment the following SecurityPermission attribute only when doing Performance Profiling 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 VisualWebPart1()

{

}

protected override void OnInit(EventArgs e)

{

base.OnInit(e);

InitializeControl();

}

protected void Page_Load(object sender, EventArgs e)

{

}

protected void Button1_Click(object sender, EventArgs e)

{

SPWeb web = SPContext.Current.Web;

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

SPQuery query = new SPQuery();

query.ViewFields = "<FieldRef Name='ID'/>" +"<FieldRef Name='Title'/>" + "<FieldRef Name='LastName'/>" +"<FieldRef Name='Age'/>";

SPListItemCollection item = list.GetItems(query);

GridView1.DataSource = item.GetDataTable();

GridView1.DataBind();

}

}

}

Step 6: Deploy the solution file and add the new webpart to a SharePoint site.

Step 7: The output of the application looks like this:

Step 8: The list data output of the application looks like this:

I hope this article is useful for you.