SQL Queries in ADO.NET datatables

  • Thread starter Thread starter Brian Henry
  • Start date Start date
B

Brian Henry

I wish someday they would add the ability to perform SQL commands on data
tables in ADO.net... it would make some stuff so much easier...
 
Brian Henry said:
I wish someday they would add the ability to perform SQL commands on data
tables in ADO.net... it would make some stuff so much easier...
Click to expand...

Were you aware of the DataTable.Select method?

John Saunders
 
The problem with the DataTable.Select method is that it works on a single
datatable and is very poor in comparison to real SQL commands. Does anyone
knows about a way to run SQL commands on a dataset? I.e, to query the
in-memory dataset...

Thanks,
Arnon.
 
Arnon Axelrod said:
The problem with the DataTable.Select method is that it works on a single
datatable and is very poor in comparison to real SQL commands. Does anyone
knows about a way to run SQL commands on a dataset? I.e, to query the
in-memory dataset...
Click to expand...

Sorry, you'll have to "roll your own', using DataTable.Select,
DataTable.Compute, DataRelations and adding computed columns.

It's usually better to let databases do the "database" work...

John Saunders
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with multiple connector/table query 1
How to view to be submitted query string in ADO.NET 1
Transactions in ADO.NET or SQL SP 1
Need ConnectionString text when using ADO.NET DataTable as source 1
ADO.NET Abstraction Layer: Basic SQL building blocks? 1
SQL queries and datasets etc 4
Find duplicate rows in datatable 2
Some doubts about ado.net 2

Back
Top