Thursday, May 9, 2013

Linq to select all rows with data in datable

_data.Tables[tempStr].Rows.Cast<DataRow>().Where(row => !row.ItemArray.All(field => field is System.DBNull || string.Compare((field as string).Trim(), string.Empty) == 0)).CopyToDataTable();

No comments:

Post a Comment