Thank you. The record is inserted in dataset with add(row).But when the dataadapter.update method is executed the record in database is ok , but in dataset the atonumber field is 0. Yes , is possible to fill again the dataset but the application is running on network and if i fill dataset everytime i add new record slow down the app. i know there is a method Select identity but i don't know how to do it.

thank you i try but the problem is the same. ( i'm using DataAdapter update method) The problem is only when i add new record and after i try to modify or delete the new record. if i close the form after adding new record and open again and try to modify or delete the record everything is ok. only my program is accessing the database , and there is no virus on my computer. -- modified at 10:12 Friday 10th August, 2007

In Visual Studio Open the solution explorer pane under your project name you will see "My Project" Double click in the main pane select the settings tab identify the conection string setting and check the scope - this should be user and NOT application.