Remove Blank rows in datatable

Hey @Girid ,

You can use filter datatable and remove all the blank rows by giving a condition

Or u can use linq

DT.AsEnumerable().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value OrElse field. Equals(“”))

hope it helps you out!

1 Like