fill dataset with 2 table using oledbdataAdaptor

[nigege]

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?

        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]

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

[nigege]

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]

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~

[Hack]

Originally Posted by nigege

feel sorry about this post.

Don't be sorry about anything...glad you got it worked out.