title: How to remove empty rows from DataTable
body: <p>I am working on importing data from an Excel sheet to database. The Excel sheet contains few empty rows and I want to remove those empty rows, then insert cleared data into database.<br>
  I have written a code by referring other code, this is the code for inserting values:</p>
  
  <pre><code>OleDbConnection cnn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + txtExcelFile.Text + "';Extended Properties= 'Excel 8.0;HDR=Yes;IMEX=1'");
  //DataTable dt = new DataTable();
  
  try
  {
      cnn.Open();
      OleDbDataAdapter data = new OleDbDataAdapter("select * from [Customers$]", cnn);
      data.Fill(dsExcel);
      dgvCustomers.ColumnHeadersVisible = false;
  
      SqlConnection connection = new SqlConnection("Data Source=COMPUTER-8EB749;Initial Catalog=KITS;Integrated Security=true");
      connection.Open();
      for (int i = 0; i &lt; dsExcel.Tables[0].Rows.Count; i++)
      {
          string ID = ds.Tables[0].Rows[i][0].ToString();
          Int16 CustID = Convert.ToInt16(ID);
          string CustName = dsExcel.Tables[0].Rows[i][1].ToString();
          string CardScheme = dsExcel.Tables[0].Rows[i][2].ToString();
          string Outlet = dsExcel.Tables[0].Rows[i][3].ToString();
          string TerminalNum = dsExcel.Tables[0].Rows[i][4].ToString();
          Int32 Terminal = Convert.ToInt32(TerminalNum);
          string Date1 = dsExcel.Tables[0].Rows[i][5].ToString();
          DateTime Date = Convert.ToDateTime(Date1);
          string Time = dsExcel.Tables[0].Rows[i][6].ToString();
          DateTime DateTime = Convert.ToDateTime(Time);
          string Amount1 = ds.Tables[0].Rows[i][7].ToString();
          double Amount = Convert.ToDouble(Amount1);
  
          SqlCommand com = new SqlCommand("insert into Customer(CustID,CustName,CardScheme,Outlet,TerminalNum,TranDate,TranDateTime,Amount) values ('" + CustID + "','" + CustName + "','" + CardScheme + "','" + Outlet + "','" + Terminal + "','" + Date + "','" + DateTime + "','" + Amount + "')", connection);
          com.ExecuteNonQuery();
      }
      connection.Close();
  }
  catch (Exception ex)
  {
      MessageBox.Show(ex.Message);
  }
  finally
  {
      MessageBox.Show("Data Inserted Successfully.");
  }
  </code></pre>
  
  <p>Can anyone say me how can I  remove empty rows so that i can insert only data?!  </p>
  
  <p><img src="https://i.stack.imgur.com/KJ4ce.jpg" alt="Excel Sheet"></p>