By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 915 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

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

dnb
P: 34
how can we fill data in same mshflexgrid using two recordset?
Some from one & some from another recordset?
please give reply
Jan 4 '08 #1
Share this Question
Share on Google+
2 Replies


QVeen72
Expert 100+
P: 1,445
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 :
Expand|Select|Wrap|Line Numbers
  1. Select T1.ID, T1.TName, T1.Addr1, T1.Amt  From Table1 T1
  2. UNION ALL
  3. Select T2.ID, T2.TName, T2.Addr1, T2.Amt  From Table2 T2
  4.  
Another Alternative is open both recordset and Fill each Row by looping through..

REgards
Veena
Jan 4 '08 #2

dnb
P: 34
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 :
Expand|Select|Wrap|Line Numbers
  1. Select T1.ID, T1.TName, T1.Addr1, T1.Amt  From Table1 T1
  2. UNION ALL
  3. Select T2.ID, T2.TName, T2.Addr1, T2.Amt  From Table2 T2
  4.  
Another Alternative is open both recordset and Fill each Row by looping through..

REgards
Veena
Jan 4 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.