查询SharePoint列表并写入值

本文关键字：SharePoint 列表查询 | 更新日期: 2023-09-27 18:28:07

我想查询一个共享点列表，返回一行并写出该行。

这是我的ascx页面中的内容

<table>
    <tr>
        <td>Name</td>
        <td><SharePoint:FieldValue runat="server" FieldName="Name" Value="Name" /></td>
    </tr>
</table>

以下是我必须检索的行

using (SPSite site = new SPSite(webUrl))
{
    using (SPWeb web = site.OpenWeb())
    {
        SPList list = web.Lists.TryGetList(listName);
        if (list != null)
        {
            SPQuery query = new SPQuery();
            query.Query = "<Where><Eq><FieldRef Name='PatientID' /><Value Type='Number'>" + PatientID + "</Value></Eq></Where>";
            SPListItemCollection items = list.GetItems();
            if (items != null)
            {
                Name = Convert.ToString(items[0]["Name"]);                      
            }
        }
    }
}

查询SharePoint列表并写入值

<table>
    <tr>
        <td class="">Name</td>
        <td><asp:Label ID="Name" runat="server" /></td>
    </tr>
</table>

using (SPSite site = new SPSite(webUrl))
            {
                using (SPWeb web = site.OpenWeb())
                {
                    SPList list = web.Lists.TryGetList(listName);
                    if (list != null)
                    {
                        SPQuery query = new SPQuery();
                        query.Query = "<Where><Eq><FieldRef Name='PatientID' /><Value Type='Number'>" + PatientID + "</Value></Eq></Where>";
                        SPListItemCollection items = list.GetItems(query);
                        if (items != null)
                        {
                            SPListItem item = items[0];
                            Name.Text = item["Name"].ToString();
                        }
                    }
                }