Displaying data in Datagrid
I'm trying to display data from a table in a gridview but instead of showing the 'ID' fields from this table(Table 'A'), I want to show related fields of these ID fileds from other tables. For example if I'm displaying the Vendor 'ID' from Table 'A' it doesn't really mean anything to anyone, so I want to show the Vendor name from the Vendor file whose key value is the Vendor ID field in the datagrid. Is this possible?
|