SQL query on DataSet

  • Thread starter Thread starter PawelR
  • Start date Start date
P

PawelR

Hello Group,
I've dataSet with 3 tables. How to make Sql Querys with 1.join and 2. sql
function min, max :
- Select a,b,c from tab1 as t1 join tab1 as t2 on (t1.id1=t2.id) where
t2.id2<100
- Select a, max(b), min(c) from tab1 group by a
on the DataSet object

Thx PawelR
 
Hello Pawel,

To the best of my knowledge, JOIN queries are not supported on datasets. As
for the aggregation functions, please check the documentation on the
DataColumn.Expression property.
 

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

Query Sql in linq 1
SELECT data from DataSet tables (INNER JOIN) 1
SELECT data from DataSet tables 7
Possible in Linq to Sql? 3
can LinQ perform Top/Group By/subqueries on local dataset? 4
SELECT with GROUP BY Joined to Subquery 0
SQL Tinyint / LINQ / cast not valid - please help 15
ADO Query gives "No value given for one or more required parameters" onjoin 1

Back
Top