title: eRROR With : Input string was not in a correct format
body: <p>I having some error here and i have no issue how to solve it .
  it unable to call the list of the table</p>
  
  <p>I try to call debug and when it reach the statement below </p>
  
  <pre><code>List&lt;Int32&gt; ListintNo = DT_ExcludeNo.AsEnumerable().Select(x
    =&gt;Convert.ToInt32(x[0].ToString())).ToList();
  </code></pre>
  
  <p>Kindly assist .</p>
  
  <pre><code> DataTable DT_ExcludeNo = new DataTable();
           dataAdapter.Fill(DT_ExcludeNo);
  
           InsertLogFile("AMB SP15: Validate Insert Data");
  
           //InsertLogFile("AMB SP15: Execute Query: " + sSqlCommandRetrieveExcludeNO);
  
           List&lt;Int32&gt; ListintNo = DT_ExcludeNo.AsEnumerable().Select(x =&gt; Convert.ToInt32(x[0].ToString())).ToList();
          for (Int32 i = 1; i &lt;= TotalCount; i++)
          {
              foreach (Int32 intNo in ListintNo)
              {
                  if (i == intNo)
                  {
                  string sSqlCommandRetrieveData = "SELECT Name, [I.C], [D.O.B], NO, [EFF DATE], Sum_Insured from AMB_Temp WHERE NO = " + i;
  
                  SqlCommand obj_SQLCommand = new SqlCommand(sSqlCommandRetrieveData, myconn);
                  dataAdapter = new SqlDataAdapter(obj_SQLCommand);
  
                  DataSet DS_RetrieveData = new DataSet();
                  dataAdapter.Fill(DS_RetrieveData);
  
                  //InsertLogFile("AMB SP15: Execute Query: " + sSqlCommandRetrieveData);
  
                  DataValidation(DS_RetrieveData);
                  }
  </code></pre>