Deleting Multiple Rows

[Stephen Noronha]

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

 

[Marshal Antony]

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.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