Click here to Skip to main content
15,921,179 members
Home / Discussions / Database
   

Database

 
GeneralPrimary Key as a Foreign Key Pin
DotNet_Newbie29-Sep-03 6:44
DotNet_Newbie29-Sep-03 6:44 
GeneralRe: Primary Key as a Foreign Key Pin
STW2-Oct-03 22:40
STW2-Oct-03 22:40 
Generalado.net Pin
Member 23171029-Sep-03 0:37
Member 23171029-Sep-03 0:37 
GeneralRe: ado.net Pin
Roger Wright29-Sep-03 5:17
professionalRoger Wright29-Sep-03 5:17 
GeneralWinforms - Menu Generation from SQL Database at runtime Pin
sunny12328-Sep-03 22:47
sunny12328-Sep-03 22:47 
GeneralRe: Winforms - Menu Generation from SQL Database at runtime Pin
Guillermo Rivero29-Sep-03 8:09
Guillermo Rivero29-Sep-03 8:09 
GeneralRe: Winforms - Menu Generation from SQL Database at runtime Pin
sunny12329-Sep-03 20:47
sunny12329-Sep-03 20:47 
GeneralConcurrency violation: the UpdateCommand affected 0 records. Pin
falbala27-Sep-03 3:32
falbala27-Sep-03 3:32 
Concurrency violation: the UpdateCommand affected 0 records.

I get this error when I try to call Update() on an SqlDataAdapter using a DataSet which has been changed by another class. I've checked that the UpdateCommand.CommandText is properly set, all the parameters have the right SourceColumns, and that the DataSet has actually been changed. So what else could it be?

I'd post some code up here but since all those things are working OK I don't know where the error would be. Has anyone else solved this problem before? It's really baffling me.
GeneralRe: Concurrency violation: the UpdateCommand affected 0 records. Pin
Mike Dimmick27-Sep-03 11:56
Mike Dimmick27-Sep-03 11:56 
GeneralRe: Concurrency violation: the UpdateCommand affected 0 records. Pin
falbala12-Oct-03 0:27
falbala12-Oct-03 0:27 
GeneralRe: Concurrency violation: the UpdateCommand affected 0 records. Pin
Wjousts30-Sep-03 9:05
Wjousts30-Sep-03 9:05 
GeneralRe: Concurrency violation: the UpdateCommand affected 0 records. Pin
falbala12-Oct-03 0:29
falbala12-Oct-03 0:29 
Generalbatch Pin
sardinka26-Sep-03 5:04
sardinka26-Sep-03 5:04 
GeneralRe: batch Pin
Anonymous26-Sep-03 11:34
Anonymous26-Sep-03 11:34 
GeneralSQL Server Yukon Pin
nevhile.net26-Sep-03 1:20
nevhile.net26-Sep-03 1:20 
GeneralRe: SQL Server Yukon Pin
Mike Dimmick26-Sep-03 3:25
Mike Dimmick26-Sep-03 3:25 
GeneralDisplay XSLT transformed XMLDataDocument from FOR XML EXPLICIT query in SQL Server 2000 Pin
drikusr25-Sep-03 20:39
drikusr25-Sep-03 20:39 
GeneralRe: Display XSLT transformed XMLDataDocument from FOR XML EXPLICIT query in SQL Server 2000 Pin
drikusr29-Sep-03 17:11
drikusr29-Sep-03 17:11 
GeneralUpdating DataTable that has an expression column Pin
Dr_Sh0ck25-Sep-03 15:41
Dr_Sh0ck25-Sep-03 15:41 
GeneralRe: Updating DataTable that has an expression column Pin
Guillermo Rivero29-Sep-03 12:12
Guillermo Rivero29-Sep-03 12:12 
GeneralRe: Updating DataTable that has an expression column Pin
Member 79899372-Oct-03 21:51
Member 79899372-Oct-03 21:51 
GeneralUsing CASE..END in OPENXML Pin
mittalpa25-Sep-03 11:54
mittalpa25-Sep-03 11:54 
GeneralSQL Server 2000 Sleeping Processes Pin
bsandell25-Sep-03 8:16
bsandell25-Sep-03 8:16 
GeneralSQL Case Sensitivity Pin
deanoA25-Sep-03 3:29
deanoA25-Sep-03 3:29 
GeneralRe: SQL Case Sensitivity Pin
Anonymous25-Sep-03 11:22
Anonymous25-Sep-03 11:22 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.