954,551 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

concurrency problems

hello
someone there could have met a similar problem. please help me out
Am using this commant to save data to an sql server database.
me.validate()
me.bindingsource.endedit()
me.tableadapter.update(me.dataset.datatable)

but when i click the save button on my winform it brings an error "System.Data.DBConcurrencyException: ConcurrencyViolation: The UpdateCommand affected 0 of the expected 1 records"

and in the database table all fields are recorded as

i'll be grateful

dnabukalu
Newbie Poster
1 post since Aug 2007
Reputation Points: 10
Solved Threads: 0
 

hai,
First check -whether all the fields are being specified& used in the query.And then check out whether datatype used for the fields are same as datatype used while in the update query.,,,

preetham.saroja
Junior Poster in Training
82 posts since Jun 2007
Reputation Points: 5
Solved Threads: 1
 

maybe two users try to change the same database at same time , read this link and this too

good luck :)

manal
Junior Poster
122 posts since Mar 2006
Reputation Points: 37
Solved Threads: 17
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You