ADO.NET explanation of deleting rows from DB please?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sherifffruitfly - 31 Oct 2006 19:58 GMT

Hi,

I want to delete rows from my database. So I download them to a
dataset, and then discover the following.

This does not work:

dataset["tablename"].Rows.Clear();
dataadapter.Update(dataset, "tablename");

This does work:

foreach (DataRow dr in dataset["tablename"].Rows)
{
dr.delete();
}
dataadapter.Update(dataset, "tablename");

I don't know enough about what's going on "underneath the hood" - why
doesn't the first one work?

Thanks for any info,

cdj

Reply to this Message

Peter Bromberg [C# MVP] - 31 Oct 2006 20:06 GMT

The DataAdapter's Update Method relies on the RowState of each row in the
datatable to tell whether to perform an update, insert, or delete. Since in
the first case you've cleared out all the DataRows, it therefore has nothing
to do.
Peter

Signature

Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com

> Hi,
>
[quoted text clipped - 20 lines]
>
> cdj

Reply to this Message

sherifffruitfly - 31 Oct 2006 20:17 GMT

Peter Bromberg [ C# MVP ] wrote:

> The DataAdapter's Update Method relies on the RowState of each row in the
> datatable to tell whether to perform an update, insert, or delete. Since in
> the first case you've cleared out all the DataRows, it therefore has nothing
> to do.
> Peter

Oooh. So is this right, in other words: the word "delete" in
DataRow.Delete *means* delete only from the DB's perspective. If I
followed up with a DataTable.rows.rowcount(), this would be unaffected
by DataRow.delete?

Whereas on the other hand, DataTable.Rows.Clear() means delete the rows
from the application's perspective. In this case,
DataTable.rows.rowcount() would be affected?

Is that kinda the idea?

Thanks for the info!

cdj

Reply to this Message

ADO.NET explanation of deleting rows from DB please?

Free Magazines