Solved

Sharepoint List Querry

Posted on 2013-01-20
3
237 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
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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
C# Comparing String Arrays. 5 39
Graphics 2 27
Masterpage unexpected error 7 24
Switching Visual Studio 2015 to normal debug display 3 24
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

813 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now