Hello,

The Edit Command Column is for editing, though, not for new records. It's possible you could add a dummy row of data to the data source and then edit that... I found another solution at: http://www.dotnetjohn.com/articles/articleid27.aspx. However, whenever I add a row of data, and add it back to the data table, the ID field in the data table (which is defined as an Identity in SQL Server) is not incremented (it is zero in command window). This is before I call an Update statement for the data adapter. Now, I think what may be happening, is because I haven't called the update statement, it isn't updating the ID number. I just wanted to confirm that what I'm stating is the fact. Is this true?

Thanks.

Thanks.

This is correct. Unless you run an INSERT to SQL you won't get a new identity value. Because you are working with a disconnected dataset, you can add rows to the datatable but you'll need to provide every bit of information for the columns.

I think your best approach is to follow the advice in the article and create a separate input form for new entries.

Peter
------------------------------------------------------
Work smarter, not harder.

I had decided to separate the Add functionality.

Thanks for your assistance.