Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
identity column not populating when inserting from a form.

Answered identity column not populating when inserting from a form.

  • Wednesday, June 25, 2008 10:18 PM
     
     
    Sign In to Vote
    0
    When inserting into a table that has an identity column, using a data adapter on a form with a data grid view, no insert into the identity column, the insert fails because the identity column is null. What am I missing? Here is the statement:

        accountTableAdapter.Update(this.operationsDataSet.Account);

    swirling in .NET
     

All Replies

  • Wednesday, June 25, 2008 10:44 PM
     
     Answered
    Sign In to Vote
    0
    OK, here is the answer to my own question, if anyone alse has this problem. The identity property was addes after the data set was created. The fix was to drop and re-create the data set.
    swirling in .NET