SPQuery 搜索不适用于"BeginsWith"

Question

所以，我的问题是我对CAML和Sharepoint的了解非常差。

问题：我需要SPQuery进行建筑查询搜索，从文本框中搜索文本。我希望我的查询返回我的项目（例如，我在文本框中键入"Jo"，查询返回所有姓"Johnson"或名"John"的项目，等等）

1） TextChanged工作正常。我已经检查过了，没有问题2） SPGridView可以查看项目。SPList中的项目我添加到gridView中-那里是由gridView查看的。3） 但我的查询不起作用。请提供链接帮助/建议

 public class VisualWebPart1 : WebPart
{
    SPSite site;
    SPWeb web;
    SPGridView gridView;
    SPDataSource dataSource;
    TextBox searchTextBox;
    UpdatePanel panel;
    SPList list;
    SPList resultList;
    string currentList;
    // Visual Studio might automatically update this path when you change the Visual Web Part project item.
    private const string _ascxPath = @"~/_CONTROLTEMPLATES/CRMSearchWebPart/VisualWebPart1/VisualWebPart1UserControl.ascx";
    protected override void CreateChildControls()
    {
        gridView = new SPGridView();
        searchTextBox = new TextBox();
        panel = new UpdatePanel();
        searchTextBox.AutoPostBack = true;
        searchTextBox.Visible = true;
        searchTextBox.Enabled = true;
        searchTextBox.TextChanged += new EventHandler(searchTextBox_TextChanged);
        gridView.Visible = true;
        gridView.Enabled = true;
        gridView.AutoGenerateColumns = false;
        AddColumnToSPGridView("Surname", "Surname");
        panel.UpdateMode = UpdatePanelUpdateMode.Conditional;
        panel.ContentTemplateContainer.Controls.Add(searchTextBox);
        panel.ContentTemplateContainer.Controls.Add(gridView);

        Control control = Page.LoadControl(_ascxPath);
        Controls.Add(control);
        Controls.Add(panel);
    }
    protected override void Render(HtmlTextWriter writer)
    {
        panel.RenderControl(writer);
    }
    //Open WebSite with List "listName"
    private void OpenWebSite(string listName)
    {
        site = SPContext.Current.Site;
        web = site.OpenWeb();
        list = web.Lists[listName];
    }
    //Add Column to gridView
    private void AddColumnToSPGridView(string HeaderText, string Datafield)
    {
        SPBoundField boundField = new SPBoundField();
        boundField.HeaderText = HeaderText;
        boundField.DataField = Datafield;
        gridView.Columns.Add(boundField);
    }
    //Build query for search; fieldName - Name of column of current List, searchQuery - our query
    private string BuildQuery(string fieldRefName, string searchQuery)
    {
        string query = "";
        switch (fieldRefName)
        {
            case "Surname":
                query = "<Where><BeginsWith><FieldRef Name='Surname'/>" +
            "<Value Type=Text>"+searchQuery+"</Value></BeginsWith></Where>";
                break;
            case "Name":
                query = query = "<Where><BeginsWith><FieldRef Name='Name'/>" +
            "<Value Type=Text>"+searchQuery+"</Value></BeginsWith></Where>";
                break;
            case "PassportNumber":
                query = "<Where><BeginsWith><FieldRef Name='PassportNumber'/>" +
            "<Value Type=Text>"+searchQuery+"</Value></BeginsWith></Where>";
                break;
            default: break;
        }
        return query;
    }
    // search in List for selected items and returns SPGridView
    private void searchTextBox_TextChanged(object sender, EventArgs e)
    {
        dataSource = new SPDataSource();
        string querySearch = searchTextBox.Text;
        OpenWebSite("Surnames");
        string query = BuildQuery("Surname", querySearch);
        SPQuery spQuery = new SPQuery();
        spQuery.ViewFields = "<FieldRef Name = 'Title'/><FieldRef Name = 'Surname'/><FieldRef Name = 'Name'/>";
        spQuery.Query = query;
        SPListItemCollection items = list.GetItems(query);
        foreach (SPListItem item in items)
        {
            searchTextBox.Text += item["Surname"] + " ";
        }
        //resultList = web.Lists["TempSurnames"];
        //resultList = AddItemsToSPList(resultList, items);
        BindDataSource(dataSource, resultList);
        //resultList = AddSPList("Result2", "Result list");
        //resultList = AddItemsToSPList(resultList, items);
        list = AddItemsToSPList(list, items);
        //BindDataSource(dataSource, resultList);
        BindDataSource(dataSource, list);
        BindGridView(gridView, dataSource);
        //var item = list.Items[3];
        //var item = resultList.Items[1];
        //searchTextBox.Text = item["Surname"].ToString();
        //resultList.Delete();
    }
    //Binds datasource of existing gridView with SPDataSource
    private void BindGridView(SPGridView gridview, SPDataSource datasource)
    {
        gridview.DataSource = datasource;
        gridview.DataBind();
    }
    //Add SPListItem items to SPList
    private SPList AddItemsToSPList(SPList spList, SPListItemCollection collection)
    {
        foreach (SPListItem item in collection)
        {
            var listItem = spList.AddItem();
            listItem = item;
        }
        return spList;
    }
    //Binds existing SPDataSource to SPList
    private void BindDataSource(SPDataSource spDataSource, SPList spList)
    {
        spDataSource.List = spList;
    }
    private SPList AddSPList(string listName, string listDescription)
    {
        OpenWebSite("Surnames");
        SPListCollection collection = web.Lists;
        collection.Add(listName, listDescription, SPListTemplateType.CustomGrid);
        resultList = web.Lists[listName];
        return resultList;
    }

更新：

这部分给了我一个错误：

SPListItemCollection items = list.GetItems(query); 
foreach (SPListItem item in items) 
{ 
  searchTextBox.Text += item["Surname"] + " "; 
} 

System.ArgumentException：值不在预期范围内测距

Answer 1

您必须将字段姓氏包含在查询的视图字段中：

SPQuery query = // ...
query.ViewFields = "<FieldRef Name='Surname' />";
// ...

您可以理解视图字段，如SQL查询的SELECT部分。

Answer 2

您是否调试了代码以检查生成的查询字符串？此外，在"名称"开关下还有query=query=。

此外，您知道开关是区分大小写的，因此请确保正确输入searchQuery选项。