>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

You're welcome, Gerard ... glad I could help! =0)

~~Bonnie


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