DODONG

博客园 首页 新随笔 联系 订阅 管理
                SPWeb web = SPControl.GetContextWeb(this.Context);
                SPList tasks 
= web.Lists[this.ListName];

                SPQuery query 
= new SPQuery();    
                query.Query 
=@"<Where><Contains>
                    <FieldRef Name='Title'/><Value Type='Text'>DODONG</Value>
                    </Contains></Where>
";

                SPListItemCollection items 
= tasks.GetItems(query);
                DataTable table 
= items.GetDataTable();
                dgCustomer1.DataSource 
= table;
                dgCustomer1.DataBind();

解释一下:其中<FieldRef Name='Title'/>,其实我PSP表里的字段为Name,在这里不能用<FieldRef Name='Name'/>,否则查询出错,dgCustomer1显示出来为:
ID Title Modified Created Author Editor Attachments LinkTitleNoMenu LinkTitle Age NickName RealName EMail
7 DODONG1 2006-6-30 15:07:31 2006-6-28 21:38:29 DODONG\Administrator DODONG\Administrator 0 DODONG1 DODONG1 290 Code Test Test Sample Test@gmail.com
posted on 2006-06-30 17:50  DODONG  阅读(463)  评论(1编辑  收藏  举报