Delete Empty Rows or Null Rows in Datatable in C#

How to Delete Empty Rows or Null Rows in Datatable

Example:  In this application we can see how to Delete Empty Rows or Null Rows in Datatable.

Mostly this issue comes from while uploading the excel(.xls,.xlsx) file data into your sql table through datatable in windows application or web application. In rare cases,we can see while getting data from excel to datatable it will copies the empty rows also.

Below Code.
C#
public DataTable DeleteEmptyRowsFromDataTable(DataTable dt)
 {
   for (int i = dt.Rows.Count - 1; i >= 0; i--)
   {
     if (dt.Rows[i][1] == DBNull.Value)
     dt.Rows[i].Delete();
   }
     dt.AcceptChanges();
     return dt;           
 }

Comments

Popular posts from this blog

Create Custom Form Control for ng-select in Angular

Angular CLI Commands - Cheat Sheet

Content Negotiation in Web API with example

Send API POST Request in MS SQL Server

Remove duplicate objects/data from an array of objects in Javascript

Use immutable data structures to avoid unnecessary change detection In Angular

Difference of High-Level Design (HLD) and Low-Level Design (LLD)

Restrict Special Characters in Windows Application using c#

CORS (Cross-Origin Resource Sharing) in .NET