Solved

Sharepoint List Querry

Posted on 2013-01-20
3
240 Views
Last Modified: 2013-01-25
I need to show the qurry result of a list in sharepoint in datagrid view that I have in a web part. How can I do this? How can I run a querrry based on the list data and bind it in gridview? Is there a sample code that someone might have??
0
Comment
Question by:pauledwardian
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 1

Expert Comment

by:bounty457
ID: 38798195
0
 
LVL 14

Accepted Solution

by:
KoenVosters earned 500 total points
ID: 38800363
You can use CAML Designer to build the query:

http://sharepoint.biwug.be/SitePages/Caml_Designer.aspx

You can use SPQuery Class to run the query (see example)

http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spquery.aspx

You can get the DataTable propertie on the returned listitems to bind to your grid.
0
 

Author Closing Comment

by:pauledwardian
ID: 38820352
thanks!
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question