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.dbc oncurrency 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.upd ate:

MessageBox.Show (Me.DataSet11.t blPreReqWorking .Rows.Count)
'get rid of any records in memory
Me.DataSet11.tb lPreReqWorking. Clear()
Me.daPreReqWork ing.SelectComma nd.CommandText = "Select JobNo, ReqNo, SeqNo
From dbo.tblPreReqWo rking"

Me.daPreReqWork ing.Fill(Me.Dat aSet11.tblPreRe qWorking)
MessageBox.Show (Me.DataSet11.t blPreReqWorking .Rows.Count)
Dim myRow As DataRow
For Each myRow In Me.DataSet11.tb lPreReqWorking
myRow.Delete()
Next
'this is where i get the dbconcurrency error
Me.daPreReqWork ing.Update(Me.D ataSet11.tblPre ReqWorking)
'i don't get this far
Me.DataSet11.tb lPreReqWorking. 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.dbc oncurrency 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.upd ate:

MessageBox.Show (Me.DataSet11.t blPreReqWorking .Rows.Count)
'get rid of any records in memory
Me.DataSet11.tb lPreReqWorking. Clear()
Me.daPreReqWork ing.SelectComma nd.CommandText = "Select JobNo, ReqNo,
SeqNo From dbo.tblPreReqWo rking"

Me.daPreReqWork ing.Fill(Me.Dat aSet11.tblPreRe qWorking)
MessageBox.Show (Me.DataSet11.t blPreReqWorking .Rows.Count)
Dim myRow As DataRow
For Each myRow In Me.DataSet11.tb lPreReqWorking
myRow.Delete()
Next
'this is where i get the dbconcurrency error
Me.daPreReqWork ing.Update(Me.D ataSet11.tblPre ReqWorking)
'i don't get this far
Me.DataSet11.tb lPreReqWorking. 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******@pierc eassociates.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.publi c.dotnet.framew ork.adonet,micr osoft.public.do tnet.languages. v
b
| NNTP-Posting-Host: 24-249-184-208.dsl.lan2wan .com 208.184.249.24
| Path: cpmsftngxa06.ph x.gbl!TK2MSFTNG P08.phx.gbl!TK2 MSFTNGP10.phx.g bl
| Xref: cpmsftngxa06.ph x.gbl microsoft.publi c.dotnet.langua ges.vb:156147
microsoft.publi c.dotnet.framew ork.adonet:6612 1
| X-Tomcat-NG: microsoft.publi c.dotnet.langua ges.vb
|
| I am trying to delete all the records in a table, but I keep getting a
| system.data.dbc oncurrency 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.upd ate:
|
| MessageBox.Show (Me.DataSet11.t blPreReqWorking .Rows.Count)
| 'get rid of any records in memory
| Me.DataSet11.tb lPreReqWorking. Clear()
| Me.daPreReqWork ing.SelectComma nd.CommandText = "Select JobNo, ReqNo, SeqNo
| From dbo.tblPreReqWo rking"
|
| Me.daPreReqWork ing.Fill(Me.Dat aSet11.tblPreRe qWorking)
| MessageBox.Show (Me.DataSet11.t blPreReqWorking .Rows.Count)
| Dim myRow As DataRow
| For Each myRow In Me.DataSet11.tb lPreReqWorking
| myRow.Delete()
| Next
| 'this is where i get the dbconcurrency error
| Me.daPreReqWork ing.Update(Me.D ataSet11.tblPre ReqWorking)
| 'i don't get this far
| Me.DataSet11.tb lPreReqWorking. 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******@pierc eassociates.com > wrote in message
news:uJ******** ******@TK2MSFTN GP10.phx.gbl...

I am trying to delete all the records in a table, but I keep getting a
system.data.dbc oncurrency 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.upd ate:

MessageBox.Show (Me.DataSet11.t blPreReqWorking .Rows.Count)
'get rid of any records in memory
Me.DataSet11.tb lPreReqWorking. Clear()
Me.daPreReqWork ing.SelectComma nd.CommandText = "Select JobNo, ReqNo, SeqNo
From dbo.tblPreReqWo rking"

Me.daPreReqWork ing.Fill(Me.Dat aSet11.tblPreRe qWorking)
MessageBox.Show (Me.DataSet11.t blPreReqWorking .Rows.Count)
Dim myRow As DataRow
For Each myRow In Me.DataSet11.tb lPreReqWorking
myRow.Delete()
Next
'this is where i get the dbconcurrency error
Me.daPreReqWork ing.Update(Me.D ataSet11.tblPre ReqWorking)
'i don't get this far
Me.DataSet11.tb lPreReqWorking. Clear()