data grid control in vb6.0

[skadu3]

i want to know how to use data grid control to retrieve data from two different table.
where one table contain reference of other table. i.e. i have two tables like result and administrator. Now there is result_id in administrator table which is a primary key of result table ,now i want to show percentage from result table and all the fields from administrator table in one data environment.

[Ali Rizwan]

i want to know how to use data grid control to retrieve data from two different table.
where one table contain reference of other table. i.e. i have two tables like result and administrator. Now there is result_id in administrator table which is a primary key of result table ,now i want to show percentage from result table and all the fields from administrator table in one data environment.

Ok
# Tell me which version of vb you are using
# Are you using ADO or any other or simple data
If you are using ADO and access then definately you want to make a link betweeen them. OK
Then I ll send you an example as you required.
One thing more if you want to see the both tables on a single grid or on two grids.
Answer these and i ll send you the example.
Examle helps you a lot instead of gib=ving you code here.
Waiting just for you

[WhiteShore]

Hi there.
Would you like to give me the source code as well?
I got a study assignment from my lecturer to make a datagrid display data from two tables, let's say Ms_Customer and Tr_Customer.
I need to choose the customer id from Ms in datagrid (probably I'm gonna use combo box to choose the id) and show the total of purchasing from its customer in Tr. All data need to be on datagrid.
I'm using VB6 and ADODB.
Thanks in advance.

[debasisdas]

Hi there.
Would you like to give me the source code as well?
I got a study assignment from my lecturer to make a datagrid display data from two tables, let's say Ms_Customer and Tr_Customer.
...

We are not here to supply you with free code and do your assignments.

Please follow the posting guidelines.

[WhiteShore]

We are not here to supply you with free code and do your assignments.

Please follow the posting guidelines.

Sorry, just i read the post before that he/she has the source code of the question and i have the same question as well.
I didnt ask to do my assignments, that just one part i dont understand so that i asked to get the answer.
So how to retrieve 2 tables and show it in datagrid?
Thanks