Consider the following DataTable:

FoodId FoodName FoodType
1 Apple Fruit
2 Pear Fruit
3 Corn Vegetable
4 Bread Starch
5 Cereal Starch
6 Carrot Vegetable
7 Grapes Fruit

I want to delete all records where FoodType = Starch.

If I do the below, however, the rowcount will decrement with every delete
and I end up with a "No row at position... " error.

for (int i=0; i <= FoodDataTable.Rows.Count- 1; i++)
{
if (FoodDataTable.Rows(i)("FoodType").ToString() == "Starch"
FoodDataTable.Rows(i).Delete();
}

Can anyone help me around this?

Thanks for any help,
Ron

for (int i = FoodDataTable.Rows.Count - 1; i >= 0; i--)



--
Pete
=========================================
I use Enterprise Core Objects (Domain driven design)
http://www.capableobjects.com/
=========================================

Ronald S. Cook wrote:
> Consider the following DataTable:
>
> FoodId FoodName FoodType
> 1 Apple Fruit
> 2 Pear Fruit
> 3 Corn Vegetable
> 4 Bread Starch
> 5 Cereal Starch
> 6 Carrot Vegetable
> 7 Grapes Fruit
>
> I want to delete all records where FoodType = Starch.
>
> If I do the below, however, the rowcount will decrement with every
> delete and I end up with a "No row at position... " error.
>
> for (int i=0; i <= FoodDataTable.Rows.Count- 1; i++)
> {
> if (FoodDataTable.Rows(i)("FoodType").ToString() == "Starch"
> FoodDataTable.Rows(i).Delete();
> }
>
foreach (DataRow row in FoodDataTable.Select("FoodType = 'Starch'")) {
row.Delete();
}

--
J.
http://symbolsprose.blogspot.com

Thanks guys!

"Jeroen Mostert" <(E-Mail Removed)> wrote in message
news:485a92b8$0$14358$(E-Mail Removed)...
> Ronald S. Cook wrote:
>> Consider the following DataTable:
>>
>> FoodId FoodName FoodType
>> 1 Apple Fruit
>> 2 Pear Fruit
>> 3 Corn Vegetable
>> 4 Bread Starch
>> 5 Cereal Starch
>> 6 Carrot Vegetable
>> 7 Grapes Fruit
>>
>> I want to delete all records where FoodType = Starch.
>>
>> If I do the below, however, the rowcount will decrement with every delete
>> and I end up with a "No row at position... " error.
>>
>> for (int i=0; i <= FoodDataTable.Rows.Count- 1; i++)
>> {
>> if (FoodDataTable.Rows(i)("FoodType").ToString() == "Starch"
>> FoodDataTable.Rows(i).Delete();
>> }
>>
> foreach (DataRow row in FoodDataTable.Select("FoodType = 'Starch'")) {
> row.Delete();
> }
>
> --
> J.
> http://symbolsprose.blogspot.com