471,330 Members | 1,239 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,330 software developers and data experts.

SELECT data from DataSet tables (INNER JOIN)

Hi all

I have a DataSet with 2 tables.
Now I want to select data like a INNER JOIN from these tables.

In SQL Syntax I would write:
SELECT *
FROM table1 t1
INNER JOIN table2 t2
ON t1.f1 = t2.f1
WHERE t2.xy = 'search'

How do I select data like this from a DataSet ?

Thanks for any comments

Best regards
Frank

Jun 27 '08 #1
1 4523
You can't.

The .Select function of a ds.Table is very basic.

...

If you have 3.5, then you can look at LINQ.

"Frank Uray" <Fr*******@discussions.microsoft.comwrote in message
news:36**********************************@microsof t.com...
Hi all

I have a DataSet with 2 tables.
Now I want to select data like a INNER JOIN from these tables.

In SQL Syntax I would write:
SELECT *
FROM table1 t1
INNER JOIN table2 t2
ON t1.f1 = t2.f1
WHERE t2.xy = 'search'

How do I select data like this from a DataSet ?

Thanks for any comments

Best regards
Frank

Jun 27 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Denis St-Michel | last post: by
5 posts views Thread by Reestit Mutton | last post: by
6 posts views Thread by Carlo B | last post: by
6 posts views Thread by Jon Bilbao | last post: by
5 posts views Thread by =?Utf-8?B?RnJhbmsgVXJheQ==?= | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.