Hi Don,

I would recommend rebinding your DataGrid to reflect the changes to your DataSet.

>I have a Windows form with 2 pages. One page a has a grid of orders, the next page has the text fields for data entry. The orders table uses an SQL server identity field for the Primary Key field, which is OrderID.
>
>I use rows.add to add a new record, then I save it to SQL server successfully, and the new autoincrement OrderID value is inserted. The grid does not show the new PK value unless I click on it - then it show up immediately. How do I update the grid and text fields programmatically? Obviously the values are being returned and are there - but I have to physically click on the grid to get it to update and show the value. I am not using CurrencyManager in this form.
>
>Any ideas?
>
>
>Don Meuse
>Spectrum Software