无法使用CAML查询获取LIst项目 [英] Unable to get the LIst items using CAML Query

问题描述

大家好，

- >我已经编写了简单查询片段以获取基于列表ID的listitem并在文本框中显示列表信息，下面是代码



- >任何人都可以帮助我是什么原因我无法通过下面的代码显示数据并在文本框中显示

Hi All,
-> I had written snippet of simple query to get listitem based on List ID and show list info in textboxes,Below is the code

->Can any one help me for what reason I am unable to fetech data and show in textboxes from below code

SPSite mysite = SPContext.Current.Site;
 SPWeb myweb = mysite.OpenWeb();
 SPList mylist = myweb.Lists["Manger"];
 SPItem myitem = mylist.Items.Add();
 SPQuery myquery = new SPQuery();
 string idvalue = txtid.Text.ToString();
                       myquery.Query=
 
@"<where><eq><fieldref name="ID" /><value type="Number">"+txtmanagerid.text.tostring()+"</value> </eq></where>";
 SPListItemCollection queryitems = mylist.GetItems(myquery);
 foreach (SPListItem myitems in queryitems)
 
                      {
 
                         txtlocation.Text = myitems["Month"].ToString();
 
                      }

推荐答案

使用此 CAML查询生成器 [ ^ ]用于测试过滤器并构建查询..

use this CAML Query Builder[^] for testing your filter and build a query..

嗨Karthik，

感谢您对回复的兴趣我知道U2U Builder，我不能在服务器中使用

Hi Karthik,
Thanks for your intrest on replying me.I knew about U2U Builder and i can't use in Server

这篇关于无法使用CAML查询获取LIst项目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！