>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