PC Review


Reply
Thread Tools Rate Thread

Concurrency violation: The UpdateCommand affected?

 
 
Dzemo
Guest
Posts: n/a
 
      9th Aug 2004
i use this code to get data into dataset

cmd.CommandType = CommandType.Text

cmdUpdate.CommandType = CommandType.Text

cmdUpdate.CommandText = "Update BigOne Set Rezultat=? where ID=?"

cmdUpdate.Parameters.Add("Rezultat", OleDb.OleDbType.Char, 30, "Rezultat")

cmdUpdate.Parameters.Add("ID", OleDb.OleDbType.Integer, 6, "ID")

cmdUpdate.Parameters("ID").SourceVersion = DataRowVersion.Original

'todo: vidi ovu komandu

da.SelectCommand = cmd

da.UpdateCommand = cmdUpdate

cmd.CommandText = "SELECT sections.ID, Analize.Name as Analiza,
BigOne.Rezultat FROM BigOne INNER JOIN Analize ON BigOne.IDAnalize =
Analize.ID INNER JOIN Sections ON Analize.IDSekcije = Sections.ID WHERE
BigOne.BrojProtokola Like '" & txtBroPro.Tekst.Trim & "'"

da.Fill(ds, "Sekcije")

and then use dataview object to filter data and fill various datagrids on my
form. Datagrids aro on diferent TabPages. When i click on btnOK whit this
code

da.Update(ds.Tables(0))

I get mentioned error in subject:

Concurrency violation: The UpdateCommand affected?

What is problem



 
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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Concurrency violation: the UpdateCommand affected 0 of the expecte =?Utf-8?B?bWtvbWFzaQ==?= Microsoft Dot NET Framework 2 17th May 2007 08:23 PM
Concurrency violation: the UpdateCommand affected 0 records =?Utf-8?B?TWlyaWFt?= Microsoft Dot NET 1 26th Jul 2006 10:55 AM
Concurrency violation: UpdateCommand affected 0 register Silviall Microsoft Dot NET 0 26th Oct 2005 04:41 PM
Concurrency violation the updatecommand affected 0 records =?Utf-8?B?R2VyYWxkaW5lIEhvYmxleQ==?= Microsoft VB .NET 1 2nd Feb 2005 11:11 AM
Concurrency violation: the UpdateCommand affected 0 records. JRH Microsoft ADO .NET 1 12th Nov 2004 10:34 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:26 AM.