Datatype declaration for Add New in Datagrid

[JonnyFrag]

I have a datagrid that is and edit,update and add etc... and everything works in it fine except for add new. It craps out on the add new of my ContactID Field. This is a integer field and is also an Identity field in the database (SQL2000)
If I declare the ContactID field as text it fails (obviously) but when I delcare it as Integer it tells bombs and tells me it is expecting a int32 instead of what I have. Here is the declaration

Dim ContactID As Integer = CType(e.Item.Cells(2).Controls(0), TextBox).Tex

Anyway I guess the question is how do I declare field that is an Identity field in SQL to work on my add new link from datagrid?

btw I am a newb to this so sorry if this is a basic question I cant seem to find the answer in my books or in the help files

[William Ryan eMVP]

Set the Autoincrement propety of the datacolumn to true. Then set the
Autoincrement seed as 0 and the Autoincrement value to -1. This way,
when -1 hits the db, SQL Server will asssign the next legit value and
guarantee that you and some other user don't step on each other.

Also, are you using a Binding Context?
http://www.knowdotnet.com/articles/adopartiii.html

"JonnyFrag" <an*******@discussions.microsoft.com> wrote in message
news:91**********************************@microsof t.com...

I have a datagrid that is and edit,update and add etc... and everything works in it fine except for add new. It craps out on the add new of my
ContactID Field. This is a integer field and is also an Identity field in
the database (SQL2000) If I declare the ContactID field as text it fails (obviously) but when I delcare it as Integer it tells bombs and tells me it is expecting a int32
instead of what I have. Here is the declaration:
Dim ContactID As Integer = CType(e.Item.Cells(2).Controls(0), TextBox).Text
Anyway I guess the question is how do I declare field that is an Identity field in SQL to work on my add new link from datagrid?
btw I am a newb to this so sorry if this is a basic question I cant seem

to find the answer in my books or in the help files

[William Ryan eMVP]

Set the Autoincrement propety of the datacolumn to true. Then set the
Autoincrement seed as 0 and the Autoincrement value to -1. This way,
when -1 hits the db, SQL Server will asssign the next legit value and
guarantee that you and some other user don't step on each other.

Also, are you using a Binding Context?
http://www.knowdotnet.com/articles/adopartiii.html

"JonnyFrag" <an*******@discussions.microsoft.com> wrote in message
news:91**********************************@microsof t.com...

I have a datagrid that is and edit,update and add etc... and everything works in it fine except for add new. It craps out on the add new of my
ContactID Field. This is a integer field and is also an Identity field in
the database (SQL2000) If I declare the ContactID field as text it fails (obviously) but when I delcare it as Integer it tells bombs and tells me it is expecting a int32
instead of what I have. Here is the declaration:
Dim ContactID As Integer = CType(e.Item.Cells(2).Controls(0), TextBox).Text
Anyway I guess the question is how do I declare field that is an Identity field in SQL to work on my add new link from datagrid?
btw I am a newb to this so sorry if this is a basic question I cant seem

to find the answer in my books or in the help files