Link to home
Start Free TrialLog in
Avatar of ArunAchudh
ArunAchudh

asked on

How can i create my custom data grid which will contain data from different table?

hi all,

i have  a trouble in my application that am creating.
I have a situation that i need to get some data from db and using that i need to get some other data from another table of same db and display all relevant information in a grid.

for eg. i get the emp. id from a table and using that i get all the information of employee from another table and display all details in a grid of both the tables in that grid.

how is this possible? any suggestions? help pls
ASKER CERTIFIED SOLUTION
Avatar of GrahamSkan
GrahamSkan
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Field3 would be the empID field.
Avatar of ArunAchudh
ArunAchudh

ASKER

thans a lot buddy. great work
but wil it be good if i use a disconnected recordset  and store the data which i rceive frm the table manually?

thats how i first did it. this is great.
I am not very familiar with disconnected recordsets, but I don't think that you can query them. To be sure, I suggest that you raise a separate question.