Cannot insert explict value for identity column in table 'Employees' when IDENTITY_INSERT is set to OFF."

[Christopher Lusardi]

How can I fix this? When I do the below I get the error message:

"Cannot insert explict value for identity column in table
'Employees' when IDENTITY_INSERT is set to OFF."

To get this message, I click the Add button to add a new row to the
database, and then I click the Update button to save the new database
to the external memory.

The methods I used are below.

Thanks,
Chris Lusardi

Private Sub btnAdd_Click(By Val sender As System.Object, ByVal e As
System.EventArg s) Handles btnAdd.Click
Dim drNew As DataRow

drNew = dsAdoSbs.Employ ees.NewRow()
drNew.Item("Fir stName") = "New First"
drNew.Item("Las tName") = "New Last"
dsAdoSbs.Employ ees.Rows.Add(dr New)
End Sub

Private Sub btnUpdate_Click (ByVal sender As System.Object, ByVal e
As System.EventArg s) Handles btnUpdate.Click
daEmployees.Upd ate(dsAdoSbs.Em ployees)
UpdateDisplay()
End Sub

[Christopher Lusardi]

When I look at the properties of the data adapter for daEmployees
nothing jumps out at me?

Chris Lusardi

[Cor Ligthert [MVP]]

Christopher,

I would look in the database for the description of the key column

Just my thought,

Cor

"Christophe r Lusardi" <cl********@aol .com> schreef in bericht
news:11******** **************@ i39g2000cwa.goo glegroups.com.. .

How can I fix this? When I do the below I get the error message:

"Cannot insert explict value for identity column in table
'Employees' when IDENTITY_INSERT is set to OFF."

To get this message, I click the Add button to add a new row to the
database, and then I click the Update button to save the new database
to the external memory.

The methods I used are below.

Thanks,
Chris Lusardi

Private Sub btnAdd_Click(By Val sender As System.Object, ByVal e As
System.EventArg s) Handles btnAdd.Click
Dim drNew As DataRow

drNew = dsAdoSbs.Employ ees.NewRow()
drNew.Item("Fir stName") = "New First"
drNew.Item("Las tName") = "New Last"
dsAdoSbs.Employ ees.Rows.Add(dr New)
End Sub

Private Sub btnUpdate_Click (ByVal sender As System.Object, ByVal e
As System.EventArg s) Handles btnUpdate.Click
daEmployees.Upd ate(dsAdoSbs.Em ployees)
UpdateDisplay()
End Sub

[Christopher Lusardi]

Cor Ligthert [MVP] wrote:

I would look in the database for the description of the key column

How do I do this? When I start vb and view "Server Explorer", I see:

- Data Connections
- chrislusardi\sq lexpress.AdoSte pByStep.dbo
+ Database Diagrams
- Tables
- Employees
LastName
FirstName
...

I can't find "sqlexpress.Ado StepByStep" on my PC with a search on the C
drive.

Chris Lusardi

[Christopher Lusardi]

Christopher Lusardi wrote:

Cor Ligthert [MVP] wrote:

I would look in the database for the description of the key column

How do I do this? When I start vb and view "Server Explorer", I see:

- Data Connections
- chrislusardi\sq lexpress.AdoSte pByStep.dbo
+ Database Diagrams
- Tables
- Employees
LastName
FirstName
...

With a I double click on Employees, I see a yellow light bulb next to a
column indicating it's the primary key column. When I click on that
yellow bulb, nothing in the properties jump out and say here's the
error.

Chris Lusardi

[Cor Ligthert [MVP]]

Christopher,

Can you download the SQLServer Express beta management tool. I have no
expirience with that but it is for sure better than the server explorer.

Cor

"Christophe r Lusardi" <cl********@aol .com> schreef in bericht
news:11******** **************@ y43g2000cwc.goo glegroups.com.. .

Christopher Lusardi wrote:

Cor Ligthert [MVP] wrote:

> I would look in the database for the description of the key column

How do I do this? When I start vb and view "Server Explorer", I see:

- Data Connections
- chrislusardi\sq lexpress.AdoSte pByStep.dbo
+ Database Diagrams
- Tables
- Employees
LastName
FirstName
...

With a I double click on Employees, I see a yellow light bulb next to a
column indicating it's the primary key column. When I click on that
yellow bulb, nothing in the properties jump out and say here's the
error.

Chris Lusardi

[ewok66]

I would modify your data adapter to ensure the identity column is not part of
your insert statement.

The button click event is adding a row to your dataset, not the database.
So calling the 'Update' method is actually doing an insert (not an update) on
the row you added.
--
--ewok
MCSA+M,MCSE, MCSD, MCDBA,MCITP
"Christophe r Lusardi" wrote:

How can I fix this? When I do the below I get the error message:

"Cannot insert explict value for identity column in table
'Employees' when IDENTITY_INSERT is set to OFF."

To get this message, I click the Add button to add a new row to the
database, and then I click the Update button to save the new database
to the external memory.

The methods I used are below.

Thanks,
Chris Lusardi

Private Sub btnAdd_Click(By Val sender As System.Object, ByVal e As
System.EventArg s) Handles btnAdd.Click
Dim drNew As DataRow

drNew = dsAdoSbs.Employ ees.NewRow()
drNew.Item("Fir stName") = "New First"
drNew.Item("Las tName") = "New Last"
dsAdoSbs.Employ ees.Rows.Add(dr New)
End Sub

Private Sub btnUpdate_Click (ByVal sender As System.Object, ByVal e
As System.EventArg s) Handles btnUpdate.Click
daEmployees.Upd ate(dsAdoSbs.Em ployees)
UpdateDisplay()
End Sub