Loss of data with Dataadapter.Update(Dataset)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am updating an Acces DB from a dataset created in VStudio.Net by dragging
the tables collection from the server explorer onto the graphical dataset
designer.

The doubles that are correctly stored in the dataset get truncated when
passed to the DB with Dataadapter.Update(Dataset). Only the integral part of
the double is conserved.

so in the dataset 0,1234
passed to the DB becomes 0,00000

any1 know y? I'm getting frustrated and will soon get desperate
 
What values are stored in your update command parameters? I'd verify the
size and type of them first.
 
This is the parameter that's giving me problems...
but I must admit that I have no idea what the InputOutput parameter means,
or what the size should be ... :-\ I just know I want a double :-P

System.Data.OleDb.OleDbParameter("Rate", System.Data.OleDb.OleDbType.Double,
16, System.Data.ParameterDirection.InputOutput, False, CType(16, Byte),
CType(5, Byte), "Rate", System.Data.DataRowVersion.Current, Nothing))
 
Back
Top