将 splist 的数据绑定到gridview中

  Aspx代码：

<%@ Page MasterPageFile="~/_layouts/application.master"  Language="C#" AutoEventWireup="true" CodeFile="QueryPager.aspx.cs" Inherits="QueryPager" %>

 

<%@ Register Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" Namespace="Microsoft.SharePoint.WebControls" TagPrefix="cc1" %>

 

       <asp:Content ID="Content1" ContentPlaceHolderID="PlaceHolderMain" runat="server">

       <asp:GridView ID="GridView1" runat="server" DataSourceID="ObjectDataSource1" AutoGenerateColumns="true">

        </asp:GridView>

   

        <asp:ObjectDataSource ID="ObjectDataSource1" runat="server"></asp:ObjectDataSource> </asp:Content>

后台代码：

using System;

using System.Data;

using System.Configuration;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using Microsoft.SharePoint;

using Microsoft.SharePoint.Utilities;

public partial class QueryPager : System.Web.UI.Page

{

    SPWeb site = SPContext.Current.Web;

    public DataTable GetDataTable()

    {

        SPList splist = site.Lists["管理类课程"];

        DataTable dt = splist.Items.GetDataTable();

 

        return dt;

    }

 

    protected void Page_Load(object sender, EventArgs e)

    {

        ObjectDataSource1.TypeName = this.GetType().FullName + "," + this.GetType().Assembly.FullName;

        ObjectDataSource1.SelectMethod = "GetDataTable";

 

    }

}