Salim
Thu Jun 09 01:52:05 CDT 2005
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
"Miha Markic [MVP C#]" wrote:
> 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
>
> "Salim" <Salim@discussions.microsoft.com> wrote in message
> news:2E29F8FF-4EBB-4F0C-8DFF-02FFB28DC908@microsoft.com...
> > 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
> >
>
>
>