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 <null>

i'll be grateful

Re: concurrency problems 80 80

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.,,,

Re: concurrency problems 80 80

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

good luck :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.