Click to See Complete Forum and Search --> : DataGrid


cyseng10
April 22nd, 2001, 09:17 PM
I would like to ask question on Visual Basic. i using a datafrid to display information which connect to my database. can the datagrid calling 2 table and displayed the information in the same table.

FYI, the fields and data type for the 2 table are same.

Regards,
Wilson Chai

O.K
April 23rd, 2001, 02:09 AM
You'll have to use the "UNION"-statement of SQL to display two tables in one grid:
e.g.:
set DTA.Recordsource="Select * from table1 union select * from table2") '-->