Using OleDbDataAdapter Fill when INNER JOIN specified

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Elton Wang (anonymous_at_discussions.microsoft.com)
Date: 03/02/05 

Date: Tue, 1 Mar 2005 18:09:33 -0800

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
elton_wang@hotmail.com

>-----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?
>
>-----------------------------
>This message is posted by http://asp.forumszone.com
>
>.
>

Relevant Pages

  • Re: Tricky ADO.NET question: joining data from database with a DataTable
    ... >>The stockinfo engine needs to perform a SELECT which is filtered by the ... >>output of the holdings engine, otherwise the query result will be way ... >>The obvious thing would be to perform some kind of SQL JOIN between the ... >>can I join a DataTable in memory with a database table? ...
    (microsoft.public.dotnet.framework)
  • Re: LEFT JOIN problem
    ... You will not be able to perform a sql join between them given that ... database but I have never seen this syntax. ... LEFT JOIN Goods as g On r.ProductID = ... Group By ProductID ...
    (microsoft.public.inetserver.asp.general)
  • Re: vb6s recordset replacement in vb.net?
    ... OK need to try the command builder. ... then it will be as limited as strongly typed datatables, ... then send the modifications back to the database. ... Very limiting because I usually do sql join ...
    (microsoft.public.dotnet.languages.vb)
  • Re: vb crashes
    ... > all i want to do is link two recordset in ado but every time i do, ... You might want to consider SQL JOIN statements. ... you make the SQL engine of your database ... INNER JOIN where common entries on both tabes are joined. ...
    (microsoft.public.data.ado)