How to Remove Empty rows in datatable

[sudhaMurugesan]

Hi all,
I am importing data from excel sheet. i get the data in a datatable. when there are empty rows in excel i am getting empty rows in datatable also. how to remove empty rows? help me please.

Thanks & Regards

[kenobewan]

How are you writing the rows? Probably easier to not write them. HTH.

[sudhaMurugesan]

How are you writing the rows? Probably easier to not write them. HTH.

I am getting data from excel sheet rows into a data table and then binding this dt to gridview.But empty rows making my gridview filled unnecessarily and running to pages. dt.rows.removea t option is there to remove rows but how i find the rowindex of the beginning of empty rows? this is my problem.

[dip_developer]

I am getting data from excel sheet rows into a data table and then binding this dt to gridview.But empty rows making my gridview filled unnecessarily and running to pages. dt.rows.removea t option is there to remove rows but how i find the rowindex of the beginning of empty rows? this is my problem.

probably you can make a dataview from your dataTable and filter out those empty rows before binding the table to gridview.....

 
Dim dv As DataView
   dv = New DataView
   With dv
      .Table = myDatatable
      .AllowDelete = True
      .AllowEdit = True
      .AllowNew = True
      .RowFilter = "myField = ' '"
 End With
 

[sudhaMurugesan]

probably you can make a dataview from your dataTable and filter out those empty rows before binding the table to gridview.....

 
Dim dv As DataView
   dv = New DataView
   With dv
      .Table = myDatatable
      .AllowDelete = True
      .AllowEdit = True
      .AllowNew = True
      .RowFilter = "myField = ' '"
 End With
 

 //dtExcel is datatable with empty rows
       bool result = false;
       int counter = 0;
       int length = dtExcel.Rows.Count;
       for (int j = 0; j < length;j++)
       {
 
           DataRow dr = dtExcel.Rows[j];
           if(result == false)
           {
            counter = 0;
               for (int i = 0; i < dtExcel.Columns.Count; i++)
               {
                   result = dr.IsNull(dtExcel.Columns[i]);
                   if (result == true)
                   {
                       counter = counter + 1;
                       if (counter != 16)  //  i hav only 16 columns
                       {
                           result = false;
                       }
                   }
               }
           }
           if (result == true && counter == 16)
           {
               //int index = dtExcel.Rows.IndexOf(j);
               do
               {
                   dtExcel.Rows.RemoveAt(j);
               } while ((dtExcel.Rows.Count - j) != 0);
               break;   
           }         
   }
        gvEmployeeImport.DataSource = dtExcel;
        gvEmployeeImport.DataBind();

Thanks dip. i've used the above code to finish that task since i have to loop thro' each dr to import it to sql for which i need to remove blank rows. In your code i can only bind data to gridview without blank rows.Any way i knew code optimization is not achieved in mine. I try to use ur code in future.Thank you