Generating Record ID Key

[Justin]

I am trying to insert data from a dataset into the source database. I get an
error when calling update on the data adapter. Here is the error:

Cannot insert the value NULL into column 'KeyID', table 'dbo.Reservations';
column does not allow nulls. INSERT fails.

KeyID is an autogenerated number in SQL Server.

Thanks, Justin.

[weichung]

May be you could list out the insert statement, if you don't mind, and also
your table structure, so that anybody else could help,
t
"Justin" wrote:

I am trying to insert data from a dataset into the source database. I get an
error when calling update on the data adapter. Here is the error:

Cannot insert the value NULL into column 'KeyID', table 'dbo.Reservations';
column does not allow nulls. INSERT fails.

KeyID is an autogenerated number in SQL Server.

Thanks, Justin.

[Eliyahu Goldin]

Justin,

You must not specify autogenerated number columns in insert statements.

Eliyahu

"Justin" <Ju****@discussions.microsoft.com> wrote in message
news:C2**********************************@microsof t.com...

I am trying to insert data from a dataset into the source database. I get an error when calling update on the data adapter. Here is the error:

Cannot insert the value NULL into column 'KeyID', table 'dbo.Reservations'; column does not allow nulls. INSERT fails.

KeyID is an autogenerated number in SQL Server.

Thanks, Justin.

[Justin]

Here is the Insert statement I am using:

this.sqlInsertCommand1.CommandText = @"SET IDENTITY_INSERT Reservations ON
INSERT INTO Reservations(KeyID, EventID, Email, qntyChild, qntyAdult,
qntySenior, GroupID, Status) VALUES (@Identity, @EventID, @Email, @qntyChild,
@qntyAdult, @qntySenior, @GroupID, @Status); SELECT KeyID, EventID, Email,
qntyChild, qntyAdult, qntySenior, GroupID, Status FROM Reservations WHERE
(KeyID = @IDENTITY)";
"Justin" wrote:

I am trying to insert data from a dataset into the source database. I get an
error when calling update on the data adapter. Here is the error:

Cannot insert the value NULL into column 'KeyID', table 'dbo.Reservations';
column does not allow nulls. INSERT fails.

KeyID is an autogenerated number in SQL Server.

Thanks, Justin.

[weichung [MCSD, MCDBA]]

Let me make a wild guess here, your @Identity is no associate to an
appropriate value.

wei chung

"Justin" wrote:

Here is the Insert statement I am using:

this.sqlInsertCommand1.CommandText = @"SET IDENTITY_INSERT Reservations ON
INSERT INTO Reservations(KeyID, EventID, Email, qntyChild, qntyAdult,
qntySenior, GroupID, Status) VALUES (@Identity, @EventID, @Email, @qntyChild,
@qntyAdult, @qntySenior, @GroupID, @Status); SELECT KeyID, EventID, Email,
qntyChild, qntyAdult, qntySenior, GroupID, Status FROM Reservations WHERE
(KeyID = @IDENTITY)";
"Justin" wrote:

I am trying to insert data from a dataset into the source database. I get an
error when calling update on the data adapter. Here is the error:

Cannot insert the value NULL into column 'KeyID', table 'dbo.Reservations';
column does not allow nulls. INSERT fails.

KeyID is an autogenerated number in SQL Server.

Thanks, Justin.