DBConcurrency Exception Handling

[Guest]

hi,
I am creating a dbconcurrencyexception in my program. Update fails with 0
rows affected message. Because I changed the data in DB from SQL server
front-end after my grid fills with data. i followed the example in msdn. in
the handler, after prompting the user, i read the record from the DB and
merge it with the current dataset. And try to update db again. The result is
the same exception. Because merge does not override the original version of
the record in the grid. So what should i do to handle this exception?

Salim

 

[Miha Markic [MVP C#]]

Hi Salim,

Do you have a primary key in DataTable being affected?

 

[Guest]

hi,
The primary key is not affected. I think, i solved the problem by changing
the dataadapter.updatecommand. Before that the updatecommand was looking for
the exact row it readed during fill, which is not available anymore.

Thanks,
Salim

Hi Salim,

Do you have a primary key in DataTable being affected?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info

hi,
I am creating a dbconcurrencyexception in my program. Update fails with 0
rows affected message. Because I changed the data in DB from SQL server
front-end after my grid fills with data. i followed the example in msdn.
in
the handler, after prompting the user, i read the record from the DB and
merge it with the current dataset. And try to update db again. The result
is
the same exception. Because merge does not override the original version
of
the record in the grid. So what should i do to handle this exception?

Salim