[This followup was posted to microsoft.public.dotnet.framework.adonet and a copy was sent to the cited author.]
Hello everybody.
I have a problem with an exception when I try to modify a row in a mssql
db. The exception that I found is Concurrency violation.
I read some other posts but I didn't find a solution.
In effect with my code I want to replace all the strings inside a
"info" attribute with the word "Hello" (This is a test, I know that this
is a stupid thing, but I wanna make that). My code update 212 row but
give me a concurrency violation in 7 roes. All these 219 rows are
selected at the same time e stored inside the same table.
The rows that I can't update are like the following:
"IST. DI CLIN. CHIR. GEN. E TERAPIA CHIR. PROF.BATTEZZATI"
But if I use SQL to replace this string with another one shorter
(Like
"IST. DI CLIN. CHIR. GEN. E TERAPIA PROF.BATTEZZATI"
or
"IST DI CLIN CHIR GEN E TERAPIA CHIR PROF BATTEZZATI"
)
and then I run my code, it works fine and this line is replaced by the
"Hello" word.
In the db the info attribute is a nvarchar(90), I don't understand where
is the problem. Is there some limit in the dimension of string that can
be inserted in a datarow or datatable object?
Thanks to everybody