title: Check if any rows in column in datatable cannot convert from integer to string
body: <p>I have a DataTable which holds scores in one column. The problem is that the score can be an integer or a string, for example, 15 (integer score), or "Advanced" (string score). I don't know what type of scores the column is going to contain, but I want to make a decision after I check whether <strong>any</strong> score in the rows of the column contains a string that cannot convert to an integer. I am using two datatables, one that has the unknown scores (<code>dt</code>) and one that will be filled with all the data and scores after I do certain operations (<code>dtCloned</code>). I want to convert the datatype of the score column in <code>dtCloned</code> before I copy in all the scores by doing these checks: What I want to do is if I have this column with these scores:</p>
  
  <pre><code>ScoreValue Column
  Advanced
  Basic
  Proficient
  Below Basic
  </code></pre>
  
  <p>If any scores in this column <strong>cannot</strong> convert to an integer (in this case none can) then I do not want to convert the column to an integer datatype, otherwise I do. More examples:</p>
  
  <pre><code>Scorevalue column
  1
  2
  3
  4
  </code></pre>
  
  <p>This would pass the test because all the values can convert to an integer. It would proceed and convert the column to integer datatype.</p>
  
  <pre><code>ScoreValue column
  0
  Advanced
  Proficient
  </code></pre>
  
  <p>This would not pass because there are string values that cannot convert to an integer.
  This is what I have so far that just checks if the score in row 10 column 13 (no reason for row 10 just don't know a better way to do this, and column 13 is the score column) can convert to an integer.</p>
  
  <pre><code>int number;
  bool tryConvert = Int32.TryParse(Convert.ToString(dt.Rows[10][13]), out number);
  if (tryConvert)
      dtCloned.Columns[13].DataType = typeof(Int32);
  
  foreach (DataRow row in dt.Rows)
  {
      dtCloned.ImportRow(row);
  }
  </code></pre>
  
  <p>So, is there any way for me to not have to hard code a specific row number for a check. Ideally <strong>if any row in the column has a string value that cannot convert to an integer do not convert the column data type to integer.</strong> I know that LINQ has a method "Any". Would that work in this situation?</p>