Solved

ADO.NET

Posted on 2004-08-16
5
221 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
Comment Utility
You can execute Transact-SQL statements only against a Data Source.
0
 
LVL 18

Accepted Solution

by:
DotNetLover_Baan earned 400 total points
Comment Utility
0
 
LVL 8

Expert Comment

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

Expert Comment

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

Expert Comment

by:jnhorst
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

728 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

9 Experts available now in Live!

Get 1:1 Help Now