Well, I have figured out a way to do this:
I wrote a get method of the adapter to return a datatable with the new row
based on the PK. Then I datatable.merge(<new datatable>).
I'm not sure if this is the best way to acomplish this, so if anyone has a
better method please let me know.
Rick
"Rick" <Rick@LakeValleySeed.comwrote in message
news:u1skvJFjHHA.4768@TK2MSFTNGP05.phx.gbl...
Quote:
VS 2005 & Firebird DB 1.5
>
I have a query for Customer orders that has several inner joins to show
things like Terms name (from termsnum) and Sales Rep name (from repnum)
etc.
>
I have written the custom SQL insert statement and this works with no
problem, but I want to get the updated values back from the DB for the
inner joins. When I add a new row, it appears in a datagridview, but all
the inner join fields are missing. I know I could refresh the entire
query, but this can be several hunded rows so I would rather just refresh
the newly added row and show it. How?
>
TIA
>
Rick
>
