<%@ Assembly Name="Microsoft.Web.CommandUI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@ Register TagPrefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls"
Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@ Register TagPrefix="Utilities" Namespace="Microsoft.SharePoint.Utilities" Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@ Register TagPrefix="asp" Namespace="System.Web.UI" Assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" %>
<%@ Import Namespace="Microsoft.SharePoint" %>
<%@ Register TagPrefix="WebPartPages" Namespace="Microsoft.SharePoint.WebPartPages"
Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>
<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="SPSelectWPUserControl.ascx.cs"
Inherits="SPMetalSelectApp.SPSelectWP.SPSelectWPUserControl" %>
<center>
<div>
<table>
<tr>
<td colspan="2">
<asp:label id="Label1" runat="server" text="LINQ-TO-SharePoint Select - SharePoint 2010 Programatically"
font-bold="true" font-size="Large" font-names="Verdana" forecolor="Maroon"></asp:label>
</td>
</tr>
<tr>
<td colspan="2">
<br />
<asp:button id="Button1" runat="server" text="Show List Data" font-names="Verdana"
width="282px" backcolor="Orange" font-bold="True" onclick="Button1_Click" />
</td>
</tr>
<tr>
<td colspan="2" align="center">
<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="Person 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="Gender" HeaderText="Gender" ReadOnly="true" /><asp:BoundField DataField="Age" HeaderText="Age" ReadOnly="true" /></Columns></asp:gridview>
</td>
</tr>
</table>
</div>
</center>
Step 7: The complete code of visualwebpart1usercontrol.ascx.cs looks like this:
using System;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using Microsoft.SharePoint.Linq;
using System.Linq;
namespace SPMetalSelectApp.SPSelectWP
{
public partial class SPSelectWPUserControl : UserControl
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
StudentDataContext dataContext = new StudentDataContext("http://win-5d57sl2rvt1:9107/");
var select = from r in dataContext.PersonList select r;
GridView1.DataSource = select;
GridView1.DataBind();
}
}
}
Step 8: Deploy the solution file and add the created webpart to SharePoint site.
Step 9: The output of the person list looks like this:
Step 10: The output of the application looks like this:
I hope this article is useful for you.