Deleting record gives me dbconcurrency exception

[Chris Thunell]

I am trying to delete all the records in a table, but I keep getting a
system.data.dbconcurrency exception. Is there an easy was to delete all the
records in a sql table?

Here is my code... i get the error on the dataadapter.update:

MessageBox.Show(Me.DataSet11.tblPreReqWorking.Rows .Count)
'get rid of any records in memory
Me.DataSet11.tblPreReqWorking.Clear()
Me.daPreReqWorking.SelectCommand.CommandText = "Select JobNo, ReqNo, SeqNo
From dbo.tblPreReqWorking"

Me.daPreReqWorking.Fill(Me.DataSet11.tblPreReqWork ing)
MessageBox.Show(Me.DataSet11.tblPreReqWorking.Rows .Count)
Dim myRow As DataRow
For Each myRow In Me.DataSet11.tblPreReqWorking
myRow.Delete()
Next
'this is where i get the dbconcurrency error
Me.daPreReqWorking.Update(Me.DataSet11.tblPreReqWo rking)
'i don't get this far
Me.DataSet11.tblPreReqWorking.Clear()

[One Handed Man]

Check your UpdateCommand parameters, they are probably either wrong or
missing.
Regards OHM
Chris Thunell wrote:

I am trying to delete all the records in a table, but I keep getting a
system.data.dbconcurrency exception. Is there an easy was to delete
all the records in a sql table?

Here is my code... i get the error on the dataadapter.update:

MessageBox.Show(Me.DataSet11.tblPreReqWorking.Rows .Count)
'get rid of any records in memory
Me.DataSet11.tblPreReqWorking.Clear()
Me.daPreReqWorking.SelectCommand.CommandText = "Select JobNo, ReqNo,
SeqNo From dbo.tblPreReqWorking"

Me.daPreReqWorking.Fill(Me.DataSet11.tblPreReqWork ing)
MessageBox.Show(Me.DataSet11.tblPreReqWorking.Rows .Count)
Dim myRow As DataRow
For Each myRow In Me.DataSet11.tblPreReqWorking
myRow.Delete()
Next
'this is where i get the dbconcurrency error
Me.daPreReqWorking.Update(Me.DataSet11.tblPreReqWo rking)
'i don't get this far
Me.DataSet11.tblPreReqWorking.Clear()

[Kevin Yu [MSFT]]

Hi Chris,

I have replied to you post in another thread. Please try to go there and
pick it up.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

--------------------
| From: "Chris Thunell" <ct******@pierceassociates.com>
| Subject: Deleting record gives me dbconcurrency exception
| Date: Wed, 12 Nov 2003 09:28:09 -0500
| Lines: 24
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <uJ**************@TK2MSFTNGP10.phx.gbl>
| Newsgroups:
microsoft.public.dotnet.framework.adonet,microsoft .public.dotnet.languages.v
b
| NNTP-Posting-Host: 24-249-184-208.dsl.lan2wan.com 208.184.249.24
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP10.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.languages.vb:156147
microsoft.public.dotnet.framework.adonet:66121
| X-Tomcat-NG: microsoft.public.dotnet.languages.vb
|
| I am trying to delete all the records in a table, but I keep getting a
| system.data.dbconcurrency exception. Is there an easy was to delete all
the
| records in a sql table?
|
| Here is my code... i get the error on the dataadapter.update:
|
| MessageBox.Show(Me.DataSet11.tblPreReqWorking.Rows .Count)
| 'get rid of any records in memory
| Me.DataSet11.tblPreReqWorking.Clear()
| Me.daPreReqWorking.SelectCommand.CommandText = "Select JobNo, ReqNo, SeqNo
| From dbo.tblPreReqWorking"
|
| Me.daPreReqWorking.Fill(Me.DataSet11.tblPreReqWork ing)
| MessageBox.Show(Me.DataSet11.tblPreReqWorking.Rows .Count)
| Dim myRow As DataRow
| For Each myRow In Me.DataSet11.tblPreReqWorking
| myRow.Delete()
| Next
| 'this is where i get the dbconcurrency error
| Me.daPreReqWorking.Update(Me.DataSet11.tblPreReqWo rking)
| 'i don't get this far
| Me.DataSet11.tblPreReqWorking.Clear()
|
|
|

[Chris Thunell]

It was something to do with the dataadapter not being setup correctly. I
created a new dataadapter with no parameters... and i was then able to
delete all the records in the table. My original datadapter had parameters
like JobNo = xxx which through off the update command i guess.

Thanks everyone for your help!

"Chris Thunell" <ct******@pierceassociates.com> wrote in message
news:uJ**************@TK2MSFTNGP10.phx.gbl...

I am trying to delete all the records in a table, but I keep getting a
system.data.dbconcurrency exception. Is there an easy was to delete all the records in a sql table?

Here is my code... i get the error on the dataadapter.update:

MessageBox.Show(Me.DataSet11.tblPreReqWorking.Rows .Count)
'get rid of any records in memory
Me.DataSet11.tblPreReqWorking.Clear()
Me.daPreReqWorking.SelectCommand.CommandText = "Select JobNo, ReqNo, SeqNo
From dbo.tblPreReqWorking"

Me.daPreReqWorking.Fill(Me.DataSet11.tblPreReqWork ing)
MessageBox.Show(Me.DataSet11.tblPreReqWorking.Rows .Count)
Dim myRow As DataRow
For Each myRow In Me.DataSet11.tblPreReqWorking
myRow.Delete()
Next
'this is where i get the dbconcurrency error
Me.daPreReqWorking.Update(Me.DataSet11.tblPreReqWo rking)
'i don't get this far
Me.DataSet11.tblPreReqWorking.Clear()