«

Hi,

I want to delete multiple records/rows from a dataset for eg:
DataSet.tables(0).rows("Some Counter").delete() will delete one row.
what if I have to delete more than one row...

Thanks,
Stephen

Hi Stephan,
You can delete multiple rows by using a loop.
Eg :

DataSet ds=new DataSet();

populate dataset..

for(int i=0;i<ds.Tables[0].Rows.Count;i++)

{

ds.Tables[0].Rows[i].Delete();

}

This will delete all rows from a datatable(first one) in the dataset
..

If you want to delete multiple rows based on some condition,put the if
condition inside the for loop before deletion.

HTH

Regards,

Marshal Antony

..NET Developer

http://www.dotnetmarshal.com







"Stephen Noronha" <> wrote in message
news:%...

> Hi,
>
> I want to delete multiple records/rows from a dataset for eg:
> DataSet.tables(0).rows("Some Counter").delete() will delete one row.
> what if I have to delete more than one row...
>
> Thanks,
> Stephen
>
>