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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Field3 would be the empID field.
ASKER
thans a lot buddy. great work
ASKER
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.
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.