SharePoint快速入门(2)之WebPart

浏览数：55 / 时间：2015年06月09日

本节学习目标：用Linq读取Sharepoint List数据，并通过SPGridView展示数据

生成 Linq to sharepoint代理类

　　通过命令行定位到“c:\program files\common files\microsoft shared\web server extensions\14\bin”

输入以下代码生成代理类

spmetal.exe /web:http://intranet.contoso.com /namespace:Jonny.VisualWebPart1 /code:SPLinq.cs

　　备注：/web为你的站点，/namespace生成类的命名空间，最好和你要引用的项目命名空间一致，/code生成的类名。默认生成的类与spmetal.exe同一个目录

项目中引用代理类

通过右键项目-->新增-->现有项-->选择我们刚刚生成的代理类

项目中添加Microsoft.SharePoint.Linq.dll

通过右键项目-->添加引用-->浏览(C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\ISAPI)

通过Linq to sharepoint读取list数据

在上一节创建的空web part中，添加SPGridView

<SharePoint:SPGridView id="spGridView" runat="server" AutoGenerateColumns="false"> 
<HeaderStyle HorizontalAlign="Left" ForeColor="Navy" Font-Bold="true" />
 <Columns>
 <SharePoint:SPBoundField DataField="Title" HeaderText="Title"></SharePoint:SPBoundField> 
<SharePoint:SPBoundField DataField="JobTitle" HeaderText="JobTitle"></SharePoint:SPBoundField> 
<SharePoint:SPBoundField DataField="ProjectTitle" HeaderText="ProjectTitle"></SharePoint:SPBoundField> 
<SharePoint:SPBoundField DataField="DueDate" HeaderText="DueDate"></SharePoint:SPBoundField> 
</Columns> 
</SharePoint:SPGridView>

添加代码后的效果图

在Page_load事件中添加读取List的代码

var dc = new SPLinqDataContext(SPContext.Current.Web.Url); 
var Employees = dc.GetList<EmployeesItem>("Employees"); 
var empQuery = from emp in Employees
where emp.Project.DueDate < DateTime.Now.AddMonths(6) select new { emp.Title, emp.JobTitle, ProjectTitle = emp.Project.Title, DueDate = emp.Project.DueDate.Value.ToShortDateString() }; 
spGridView.DataSource = empQuery; 
spGridView.DataBind();