[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Search a DataSet using SQL Select statements

Posted on 2006-06-28
2
Medium Priority
?
1,532 Views
Last Modified: 2008-01-09
Please tell me if it is possible and if it is how to use SQL select statements to query a dataset.

Thank-you
0
Comment
Question by:fly412s
2 Comments
 
LVL 96

Accepted Solution

by:
Bob Learned earned 1500 total points
ID: 17003404
It is not possible to use SQL Select statements to filter a DataSet.  The DataTable has the .Select method, but it is only simple filter expressions, such as:

   DataRow[] findRows = table.Select( "Name = 'Bob' );

Bob
0
 
LVL 25

Expert Comment

by:dstanley9
ID: 17003423
You can Query a DataTable:

DataTable table = new DataTable();
// fill rows
DataRow[] rows = table.Select("{field} = {value}","{sortcolumn}");

the first parameter is essentially the WHERE clause, and the second (optional) parameter is the ORDER BY clause


0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

This article introduced a TextBox that supports transparent background.   Introduction TextBox is the most widely used control component in GUI design. Most GUI controls do not support transparent background and more or less do not have the…
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!
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…

608 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