Delete DataTable Empty Rows

Question

2.78/5 (3 votes)

See more:

Hi everybody,

I have a doubt in handling the DataTable. I have a DataTable, in my datatable i have 100 rows. But out 100 , only 5 rows having data remaining all rows are empty.

Now my question is i want to remove all remaining 95 rows. which row doesn't have a data.

How to do can anybody help me regarding this issue...

Posted 15-Feb-13 1:16am

Naveen.Sanagasetti

Updated 15-Jan-20 17:05pm

Add a Solution

Comments

Simon_Whale 28-Jan-15 6:07am

Can I ask why are there so many blank rows in your datatable?

5 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

vyas_pratik20 · Answer 1 · 2013-02-15T02:04:00

Hi, in flowing example your actual data is stored in dt.

C#

 DataTable dt1=dt.Clone();
        var rows =from row in dt.AsEnumerable()
            where row.Field<string>("columnname") != null
            select row;
        foreach (DataRow dr in rows)
        {
            dt1.Rows.Add(dr);
        }
</string>

you can create copy of dt to dt1 and using link you can find row which dose not have null value

PranavSingh · Answer 2 · 2014-10-16T20:00:00

It is corrected version of answer from fjdiewornncalwe. I removed logical & syntax errors i faced while using that code.

C#

private void RemoveEmptyRows(DataTable source)
{
   for (int i = source.Rows.Count; i >= 1; i--)
                {
                    DataRow currentRow = source.Rows[i - 1];
                    foreach (var colValue in currentRow.ItemArray)
                    {
                        if (!string.IsNullOrEmpty(colValue.ToString()))
                            break;

                        // If we get here, all the columns are empty
                        source.Rows[i - 1].Delete();
                    }
                }
}

fjdiewornncalwe · Answer 3 · 2013-02-15T04:38:00

If you need to do it without linq, you can try this.
NOTE: I did just hammer this out here, I haven't thoroughly checked the syntax.

C#

private void RemoveEmptyRows(DataTable source)
   for( int i = source.Rows.Count; i >= 0; i-- )
   {
      DataRow currentRow = source.Rows[i];   
      foreach( var colValue in currentRow.ItemArray)
      {
         if( !string.IsNullOrEmpty(colValue) )
            break;

         // If we get here, all the columns are empty
         source.Rows[i].Delete();
      }
   }
}

alsolingam · Answer 4 · 2014-10-23T04:32:00

Solution 5

Try this:

C#

dataTable = dataTable.Rows.Cast<datarow>().Where(row => !row.ItemArray.All(field => 
field is System.DBNull || string.Compare((field as string).Trim(),  
string.Empty) == 0)).CopyToDataTable();

Posted 23-Oct-14 4:32am

alsolingam

Updated 27-Jan-15 23:53pm

v2

Comments

CHill60 23-Oct-14 10:34am

The question is nearly 1.5 years old!

sore_ron · Answer 5 · 2015-01-27T23:43:00

Try this modification of code from above (fjdiewornncalwe)...

C#

private static DataTable RemoveEmptyRows(DataTable source
{
  DataTable dt1 = source.Clone(); //copy the structure 
  for (int i = 0; i <= source.Rows.Count-1; i++) //iterate through the rows of the source
    {
      DataRow currentRow = source.Rows[i];  //copy the current row 
      foreach( var colValue in currentRow.ItemArray)//move along the columns 
       {
         if (!string.IsNullOrEmpty(colValue.ToString())  ) // if there is a value in a column, copy the row and finish
             {                      
                  dt1.ImportRow(currentRow);
                  break; //break and get a new row                        
              }                   
         }
              }
    return dt1;
 }

Delete DataTable Empty Rows

5 solutions

Solution 1

Solution 3

Solution 2

Solution 5

Solution 6

Add your solution here

Preview 0

Delete DataTable Empty Rows

5 solutions

Solution 1

Solution 3

Solution 2

Solution 5

Solution 6

Add your solution here

Preview 0

Existing Members

...or Join us