public void deleteemptyrows(DataTable dt) { for (int i = dt.Rows.Count; i >= 1; i--) { DataRow currentRow = dt.Rows[i - 1]; foreach (var col in currentRow.ItemArray) { if (!string.IsNullOrEmpty(col.ToString())) break; dt.Rows[i - 1].Delete(); } } }
select * from Your_table where columnName !=null
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)