Re: Using OleDbDataAdapter Fill when INNER JOIN specified
From: Patrice (nobody_at_nowhere.com)
Date: 03/01/05
- Next message: Chris Simmons: "Output parameters for OleDbParameter"
- Previous message: Beve Lyni: "Does ADO.net have equivalent to ADODB.Recordset.GetString() in VB6"
- In reply to: Ian: "Using OleDbDataAdapter Fill when INNER JOIN specified"
- Next in thread: Elton Wang: "Using OleDbDataAdapter Fill when INNER JOIN specified"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 1 Mar 2005 17:59:48 +0100
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
-- "Ian" <ian.wildman@anite.com> a écrit dans le message de news:654562332383945@asp.forumszone.com... > 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 >
- Next message: Chris Simmons: "Output parameters for OleDbParameter"
- Previous message: Beve Lyni: "Does ADO.net have equivalent to ADODB.Recordset.GetString() in VB6"
- In reply to: Ian: "Using OleDbDataAdapter Fill when INNER JOIN specified"
- Next in thread: Elton Wang: "Using OleDbDataAdapter Fill when INNER JOIN specified"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
