title: vb.net - How can I change the type of values that the DataTable can store?
body: <p>I want to add characters (like <code>%</code> and <code>pp</code>) in values stored in a <code>DataTable</code>, but I'm getting an error message:</p>
  
  <blockquote>
    <p>Input string was not in a correct format.Couldn't store &lt;97.0%> in Actual Column. Expected type is Decimal.</p>
  </blockquote>
  
  <p>How can I change the type of values that the <code>DataTable</code> can store?</p>
  
  <pre><code>Dim dv As New System.Data.DataView
  Dim dt As New System.Data.DataTable
  dv = SQL_Customer.Select(DataSourceSelectArguments.Empty)
  dt = dv.ToTable()
  
  dt.Rows(1)(1) = CStr(dt.Rows(1)(1)) &amp; "%"
  dt.Rows(1)(2) = CStr(dt.Rows(1)(2)) &amp; "%"
  dt.Rows(1)(3) = CStr(dt.Rows(1)(3)) &amp; "%"
  dt.Rows(1)(4) = CStr(dt.Rows(1)(4)) &amp; "pp"
  </code></pre>