Delete Row Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Erica - 09 Jun 2004 23:13 GMT

Hello,

When I delete a row in my dataset, the row state for other rows in the
dataset (other datatables) rowstate is deleted. Why is that? Here is the
code I use to delete the row:

I have tried both methods below and get same result:
dataSet.Table1[0].Delete();
dataSet.Tables.Rows.Remove(dataRow);

Thanks

Reply to this Message

William Ryan eMVP - 10 Jun 2004 00:29 GMT

Hi Erica:

in your first statement, you aren't specificing a row. You need to use
DataSet.Tables[TableIndex].Rows[RowIndex].Delete();
or you can use a specific row instead of RowINdex
DataSet.Tables[TableIndex].Rows[dataRow].Delete();

Remember .Remove() != .Delete(); Remove takes it out of the collection so
the adapter will never see it when it does and update b/c it's gone
http://www.knowdotnet.com/articles/efficient_pt4.html
.Delete on the other hand doesn't affect the Rows.Count until you call
Update or AcceptChanges is called (Update calls AcceptChanges)

HTH,

Bill

Signature

W.G. Ryan MVP Windows - Embedded

http://forums.devbuzz.com
http://www.knowdotnet.com/dataaccess.html
http://www.msmvps.com/williamryan/

> Hello,
>
[quoted text clipped - 7 lines]
>
> Thanks

Reply to this Message

Delete Row Problem

Free Magazines