Help... last deleted row not updated

Hi group,

in a checklistbox I have some item that can occur(when checked) in a
datatable.
when I uncheck 3 items and press the update button a problem occurs.
In the Buttonevent I make a loop where I search for still excisting
unchecked(s) searching the id with dataviewtable.find().
If found the datatable.rows[found].delete() is called.
I see this happen tree times in debug mode.... so far, so good....
But when I call the adapter.update(ds[table]) only the first two rows are
really updated and the last one still is in the sql-server.

Do I have todo something extra before calling update or has any one a
solution to my problem?

Thanks in advance,
Rens

Rens
Fri May 14 10:48:25 CDT 2004

Deleting a row in the table updates the dataview with less rows.... the
rownumbers of the dataview then do NOT correspondent anymore with the
rownumbers in the table.... Deleting the rows in the dataview is the
solution..... it updates the table correctly
Maybe it can help someone else :)

Rens

"Rens Renooij" <renren_MyPants@zonnet.nl> wrote in message
news:40a24de9$0$575$e4fe514c@news.xs4all.nl...
> Hi group,
>
> in a checklistbox I have some item that can occur(when checked) in a
> datatable.
> when I uncheck 3 items and press the update button a problem occurs.
> In the Buttonevent I make a loop where I search for still excisting
> unchecked(s) searching the id with dataviewtable.find().
> If found the datatable.rows[found].delete() is called.
> I see this happen tree times in debug mode.... so far, so good....
> But when I call the adapter.update(ds[table]) only the first two rows are
> really updated and the last one still is in the sql-server.
>
> Do I have todo something extra before calling update or has any one a
> solution to my problem?
>
> Thanks in advance,
> Rens
>
>