PC Review Forums Newsgroups Microsoft DotNet Microsoft ADO .NET Update Dataset oleDB

Reply

Update Dataset oleDB

 
Thread Tools Rate Thread
Old 23-06-2006, 09:08 PM   #1
Mark Sandfox
Guest
 
Posts: n/a
Default Update Dataset oleDB


Here is my code:

Dim wwtID as integer
Dim wwtEmailAddress as string
Dim drEmailListWWT as System.Data.DataRowView
Dim dvEmailListWWT as DataView
Dim cnEmailListWWT as OleDbConnection
Dim daEmailListWWT as OleDbDataAdapter = New OleDbDataAdapter
Dim dsEmailListWWT as DataSet = New DataSet
Dim SelectStatement as String

SelectStatement = "Select * From EmailList"
cnEmailListWWT = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:\Inetpub\wwwroot\WildWestTown\wwtdb\WWTEmailList.mdb")
daEmailListWWT.UpdateCommand = New OleDbCommand(SelectStatement,
cnEmailListWWT)
daEmailListWWT.SelectCommand = New OleDbCommand(SelectStatement,
cnEmailListWWT)
daEmailListWWT.Fill(dsEmailListWWT, "EmailList")
dvEmailListWWT = dsEmailListWWT.Tables("EmailList").DefaultView
iLoop = 0
While dvEmailListWWT.count > iLoop
drEmailListWWT=dvEmailListWWT.Item(iLoop)
drEmailListWWT("wwtEmail") = Replace(drEmailListWWT("wwtEmail"), " ", "")

iLoop += 1
End While

daEmailListWWT.Update(dsEmailListWWT, "EmailList")

Here is my error:

Concurrency violation: the UpdateCommand affected 0 of the expected 1
records

Please help.


  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off