Hi Bonnie.
I changed around ny Linq statement and it seemed to work... I had the RowState selected out initially 'AS' a different field , but have changed this now and its working fine.
Many thanks for your assistance
regards,
Gerard



>>I am getting a DeltedRowInaccessible exception when I iterate through the output from a linq statement, where one of the rows has been deleted.
>>
>>How do I remove deleted rows from the table (Have used DataRowState.deleted but does not seem to work
>
>Hi Gerard,
>
>Checking for DataRowState.Deleted works ... perhaps you didn't code it correctly. Here's some sample syntax (tested and working fine):
>
>

>DataRow[] rows = dsTemp.Personnel
>    .Where(row => row.RowState != DataRowState.Deleted && 
>                  row.IslastnameNull() == false && 
>                  row.lastname == "Berent")
>	.Select(row => row).ToArray();
>

>
>~~Bonnie