how can we fill data in same mshflexgrid using two recordset?

[dnb]

how can we fill data in same mshflexgrid using two recordset?
Some from one & some from another recordset?
please give reply

[QVeen72]

Hi,

A Flex Grid can have only one Datasource, you cannot give multiple.

An alternative is to Change the Query itself..
Column Names, and ColumnTypes of both recordsets are same...?
If yes, then Change your Query itself.. Use "Union All" from 2 tables

Something like this :

Select T1.ID, T1.TName, T1.Addr1, T1.Amt  From Table1 T1
UNION ALL
Select T2.ID, T2.TName, T2.Addr1, T2.Amt  From Table2 T2
 

Another Alternative is open both recordset and Fill each Row by looping through..

REgards
Veena

[dnb]

Thank You So Much.....It works.....Bye....

Hi,

A Flex Grid can have only one Datasource, you cannot give multiple.

An alternative is to Change the Query itself..
Column Names, and ColumnTypes of both recordsets are same...?
If yes, then Change your Query itself.. Use "Union All" from 2 tables

Something like this :

Select T1.ID, T1.TName, T1.Addr1, T1.Amt  From Table1 T1
UNION ALL
Select T2.ID, T2.TName, T2.Addr1, T2.Amt  From Table2 T2
 

Another Alternative is open both recordset and Fill each Row by looping through..

REgards
Veena