Hi to all,
I have a datatable with the following Columns fetched from the sql table:
ID INT (AutoIncrement)
I have assigned this datatable to a DataGridView datasource, everything works fine. Currently i have stored integer values in MType and RType which are the ID's linked to Some text values in another table. I want to display those values instead of ID's in my datagrid.
What will be best option to do this : (One of them which i think is add another two columns to this datatable and update this column with the text values after a database lookup from the other table (will this be performance intensive?))
Kindly suggest !!!