fill dataset with 2 table using oledbdataAdaptor

**nigege** · 10-29-2009, 10:40 PM

hi, recently i want to do above process.

i have a query that join 2 table. i need to fill both table into dataAdaptor then fill into a dataset then use for crystalReport.

what should i do?? is this correct?

Code:

        Dim cmd As New OleDbCommand
        Dim conSQL As New OleDbConnection(ConfigurationSettings.AppSettings().Item("connectionStringR"))
        Dim sqlStr as String = "Select * from tableA join tableB on tableA.id=tableB.aid"
        Dim odbcCommand As String 
        conSQL.Open()
        odbcCommand = sqlStr
        cmd.CommandText = odbcCommand
        da.SelectCommand = cmd
        da.SelectCommand.Connection = conSQL
        da.TableMappings.Add("Table", "tableA")
        da.TableMappings.Add("Table1", "tableB")
        da.Fill(ds)
        CrtRptSource.ReportDocument.SetDataSource(ds)

**Hack** · 10-30-2009, 07:33 AM

Your query could join 20 tables if you need it to. The result is still going to be just one recordset

**nigege** · 11-01-2009, 09:14 PM

because my sqlstring is related to 2 tables, so if i join 2 tables together in 1 recordset, then my sqlstring will get those query data correctly or not? so that i can pass the recordset to my crystal reports as datasource. what if i cant get the correct records from the recordset, is there a right way for me to use?

**nigege** · 11-02-2009, 04:32 AM

feel sorry about this post. the method is really function one. i just mis paired the database i retrieve data and report connected database. thank reply from Hacks, u r always helping me~