Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Sharepoint List Querry

Posted on 2013-01-20
3
Medium Priority
?
245 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 14

Accepted Solution

by:
KoenVosters earned 1500 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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

721 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