title: How To Change DataType of a DataColumn in a DataTable?
body: <p>I have:</p>
  
  <pre><code>DataTable Table = new DataTable;
  SqlConnection = new System.Data.SqlClient.SqlConnection("Data Source=" + ServerName + ";Initial Catalog=" + DatabaseName + ";Integrated Security=SSPI; Connect Timeout=120");
  
  SqlDataAdapter adapter = new SqlDataAdapter("Select * from " + TableName, Connection);
  adapter.FillSchema(Table, SchemaType.Source);
  adapter.Fill(Table);
  
  DataColumn column = DataTable.Columns[0];
  </code></pre>
  
  <p>What I want to do is:</p>
  
  <p><strong>Assume currently <em>column.DataType.Name</em> is <em>"Double"</em>. I want it to become <em>"Int32"</em>.</strong></p>
  
  <p>How do I achieve this?</p>