How can i delete rows that can be empty or not

[chandu4712 (Chandan)]

Remove row will not work if you use inside For Each row.

Check this

Remove Empty Rows From DataTable

Hi @Joshikumarav, Use this code DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable() Refer below link for more information. Regards, Arivu