WinForm - Is there a way to do Data Mapping on DataGridView (ID to Name)

[iHandler]

I have a datagridview on WinForm and I need to convert the ID to Name.

For example,
---------------------------------------------------
Product Name Category
Product-A 1234
Product-B 2345
Product-C 4569

Category Table contains two fields which are category_id, category_name

Is there something I can do such as Data Mapping like Dictionary (it looks like DataGridView does not support for this feature) ?

And my requirement is that I am not allowed to modify the existing SQL statement (so I can't do joining tables there)

Please help ~ Appreciate for your time ~

Continue reading...