insert data to datagrid

[matcathy]

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

[Lyla]

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.

[hkmai]

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