title: SQLite not storing decimals correctly
body: <p>I have a sqlite DB with a table called tbl_invent, on form load it fills the datagridview with what is in the table. The problem is I have field names cost and sell_price which have decimals, and when the form loads it only shows the number not the decimal.</p>
  
  <p>sample: </p>
  
  <p>Table=1.75, DGV=1.00</p>
  
  <pre><code>   Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
      connect()
      Dim da As New SQLiteDataAdapter("select * from tbl_Invent", connection)
      Dim ds As New DataSet
      da.Fill(ds, "tbl_Invent")
      DataGridView1.DataSource = ds
      DataGridView1.DataMember = "tbl_Invent"
      DataGridView1.Columns(6).ValueType = GetType(Single)
      DataGridView1.Columns(6).DefaultCellStyle.Format = "N2"
      DataGridView1.Columns(7).ValueType = GetType(Single)
      DataGridView1.Columns(7).DefaultCellStyle.Format = "N2"
  
      connection.Close()
      da.Dispose()
  End Sub
  </code></pre>
  
  <p>i already check the field type it's correct "Integer", i also tried the "GetType(Single)" and "GetType(Decimal)" but still the same. any one could point me in the right direction? thank you.</p>
  
  <hr>
  
  <p>From comments:</p>
  
  <p>there is no other type in SQLite. there is only "Text", "Integer", "Real" and "Blob" also in SQLite it says integer can have decimals.</p>