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

Recommended Answers

All 2 Replies

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

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.