Display results in datagrid

[James Goodman]

I have a form with three controls, a button and a datagrid.

The grid is bound to a dataset table.

When the button is pressed, a new row is added to the dataset table.

The datagrid table contains 3 int columns, plus an identity column. 2 of
these int columns are FK's to lookup tables.

In the SQL for the table I used an inner join to the lookup tables so grid
becomes populated with the data I want them to see (i.e. text not numbers).

When I insert the new row, because the row is uncomitted, the text columns
display as null. Once the new rows are comitted they display as expected.

I can understand why this happens, but are there any simple workarounds for
this, so I can display the data I want?

 

[Earl]

Not to be catty about an answer, but there is never a simple solution with a
JOINed query bound to a datagrid. If you are using it solely for display
purposes, I could see it, but anything requiring an insert or an update is
only going to lead to grief. You probably want to google some previous
issues on this.