Hi,

I want to programmatically add a row to a datatable in my dataset.  I have a primary key that is an IDENTITY column in my database.  How do I do this?  If I set the column value to DBNull.Value I get an error about it not accepting nulls.  If I set it to 'nothing' it tells me to use dbnull.  If I use "" I get a cast problem from string to integer.

Sample Code:
            Dim AddRow As DataRow
            AddRow = MyDS.Tables("tools").NewRow
            AddRow(0) = DBNull.Value '***problem line***
            AddRow(1) = "Desc"
            MyDS.Tables("tools").Rows.Add(AddRow)

I'm using VS .Net 2003.  Thanks in advance.

What I ended up doing was inserting a negative value and decrementing it as values where added.  The reason I had to do that was because I had a child table that would need to be updated as well with the same ID values as the parent.  That way I could insert a -1 for both ID's in the parent and child tables and when the queries were sent to the SQL server SCOPE_IDENTITY() would return the proper values for parent and then children.  I basically did what this said to: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnadonet/html/manidcrisis.asp

Dont set it at all

What I ended up doing was inserting a negative value and decrementing it as values where added.  The reason I had to do that was because I had a child table that would need to be updated as well with the same ID values as the parent.  That way I could insert a -1 for both ID's in the parent and child tables and when the queries were sent to the SQL server SCOPE_IDENTITY() would return the proper values for parent and then children.  I basically did what this said to: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnadonet/html/manidcrisis.asp