Using OleDbDataAdapter Fill when INNER JOIN specified

[Ian]

I want to produce a Crystal Report in ADO.NET that uses a dataset with data from more than one table. There are references everywhere that ADO.NET datasets can use more than one table, such as the quote from the Crystal Reports walkthroughs reproduced on MDSN: "...the Fill method connects to the specified database, fetches the data, and disconnects from the database. If you want to add more than one table from the
database to the report, use a SQL JOIN statement to join the tables together; then
specify the single resultant table in the Fill method."

I''ve tried this and it simply doesn''t work. Am I missing something, or is this a case of another bug that is documented somewhere in the Microsoft KB that I haven''t found yet?

 

[Patrice]

Doesn't work ? What exactly do you see ?

IMO the doc is misleading. INNER JOIN actually allows to add columns
belonging to other tables on the same row. To have multiple tables in a
single dataset, you'll have AFAIK to issue multiple statements (or a
statement returning multiple result sets) or to get the result as an XML
stream...

Patrice

--

I want to produce a Crystal Report in ADO.NET that uses a dataset with

data from more than one table. There are references everywhere that ADO.NET
datasets can use more than one table, such as the quote from the Crystal
Reports walkthroughs reproduced on MDSN: "...the Fill method connects to the
specified database, fetches the data, and disconnects from the database. If
you want to add more than one table from the

database to the report, use a SQL JOIN statement to join the tables together; then
specify the single resultant table in the Fill method."

I''ve tried this and it simply doesn''t work. Am I missing something, or

is this a case of another bug that is documented somewhere in the Microsoft
KB that I haven''t found yet?

 

[Elton Wang]

Could you show us the sql join query, .NET code, and error
message (You mentioned it doesn't work, so I suppose some
error comes out.)

Elton Wang
(e-mail address removed)

-----Original Message-----
I want to produce a Crystal Report in ADO.NET that uses a

dataset with data from more than one table. There are
references everywhere that ADO.NET datasets can use more
than one table, such as the quote from the Crystal Reports
walkthroughs reproduced on MDSN: "...the Fill method
connects to the specified database, fetches the data, and
disconnects from the database. If you want to add more
than one table from the

database to the report, use a SQL JOIN statement to join the tables together; then
specify the single resultant table in the Fill method."

I''ve tried this and it simply doesn''t work. Am I

missing something, or is this a case of another bug that
is documented somewhere in the Microsoft KB that I
haven''t found yet?