Solved

ADO.NET

Posted on 2004-08-16
5
222 Views
Last Modified: 2010-04-07
is it possible to do a select statement on a datatable or a dataset
0
Comment
Question by:yalamanchir
  • 2
  • 2
5 Comments
 
LVL 8

Assisted Solution

by:daffodils
daffodils earned 100 total points
ID: 11813825
You can execute Transact-SQL statements only against a Data Source.
0
 
LVL 18

Accepted Solution

by:
DotNetLover_Baan earned 400 total points
ID: 11815195
0
 
LVL 8

Expert Comment

by:daffodils
ID: 11815231
wow.. Thanks Baan.. I didn't know this.. this is good stuff !
0
 
LVL 18

Expert Comment

by:DotNetLover_Baan
ID: 11815291
I couldn't get a chance to use them though....
0
 
LVL 10

Expert Comment

by:jnhorst
ID: 11826263
There is a Select method of the datatable object and the syntax is pretty much like the WHERE clause in T-SQL.  It returns an array of DataRow objects.

John
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

In this Article, I will provide a few tips in problem and solution manner. Opening an ASPX page in Visual studio 2003 is very slow. To make it fast, please do follow below steps:   Open the Solution/Project. Right click the ASPX file to b…
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

773 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