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