Calculated Columns in a DataGrid

[Guest]

Visual Studio 2003 .Net C#

I have a DataGrid showing my Job table. Some of the fields in this table
are ID's linking to other tables for the displayable value. i.e. I store the
ID 1003 in the Job.JobStatus field, which links to the JobStatus table, which
holds this ID and a Description such as "Complete". In the DataGrid I want
to go get this value and show that description rather than the ID field.

What is the best way of doing this kind of thing? At the moment my DataGrid
is bound to a Typed DataSet for the Job table. Should I have created some
kind of bespoke DataSet for this datagrid, and populate it when this screen
loads?

Thanks

Ste

 

[Cor Ligthert [MVP]]

Steve,

You can add tables to the used datatable.
Have a look at this very simple sample on our site

http://www.windowsformsdatagridhelp.com/default.aspx?ID=76a81eb8-ea2d-48f4-99c3-a3539697edbd

I hope this helps,

Cor

 

[Guest]

ok, so I are you saying that I should create a datatable at runtime, populate
it from the dataset I already have, plus the extra description fields, and
then bind my grid to it?

Thanks

Steve