insert data to datagrid

to insert data to datagrid, we have to define the datasource and datamember. and we also need to specify the field member on each column.

but what if i have data that are from many different tables (but still have fixed number of columns in datagrid). i retrieve data at run time and want to put them onto the datagrid at that time.

the reason doing this is because i have to based on different criteria to get data. and, hence, i know what table i need to use ONLY at run time.

can anyone give advice?

thanks

Hi there..

Since the Grid has a fixed columns, You could create a Temp table at run time to collect all the elements from different tabels and make thet Temp table as a source of your Grid data.

G Luck.

Hey Lyla,
That's a really good idea. I too have to populate my unbound DataGrid with fields from multiple tables and your idea sounds like it could end my frustration:) Thanks:)