Hi there
I have a strange problem with storing number from a dataset in a JET
database.
I use this code:
oleDbConnection 1.Open();
dsLogBook1.Dive s.Clear();
dsLogBook1.Samp les.Clear();
SuuntoCSVParser csv=new SuuntoCSVParser ();
csv.Filename=fi leName;
csv.DSLogBook=d sLogBook1;
csv.loadAndPars e();
daDivesAll.Upda te(dsLogBook1.D ives);
daSamplesAll.Up date(dsLogBook1 .Samples);
oleDbConnection 1.Close();
The SuuntoCSVParser , loads a CSV file and stores that data in 2 tables in 1
dataset.
If i debug the dataset before the 'daDivesAll.Upd ate(dsLogBook1. Dives); the
numbers could be '44.2' or '36' or '6.7' but when i look in the database
those numbers have been stored as: 442, 36 and 67
The funny thing is this problem only exists on my computer at work, where i
am running Windows XP english version, set to 'Danish' at home where i have
a german Windows MCE also set to 'Danish' everything works as expected.
Has anyone any ideas ?
Best regards
Søren Reinke
I have a strange problem with storing number from a dataset in a JET
database.
I use this code:
oleDbConnection 1.Open();
dsLogBook1.Dive s.Clear();
dsLogBook1.Samp les.Clear();
SuuntoCSVParser csv=new SuuntoCSVParser ();
csv.Filename=fi leName;
csv.DSLogBook=d sLogBook1;
csv.loadAndPars e();
daDivesAll.Upda te(dsLogBook1.D ives);
daSamplesAll.Up date(dsLogBook1 .Samples);
oleDbConnection 1.Close();
The SuuntoCSVParser , loads a CSV file and stores that data in 2 tables in 1
dataset.
If i debug the dataset before the 'daDivesAll.Upd ate(dsLogBook1. Dives); the
numbers could be '44.2' or '36' or '6.7' but when i look in the database
those numbers have been stored as: 442, 36 and 67
The funny thing is this problem only exists on my computer at work, where i
am running Windows XP english version, set to 'Danish' at home where i have
a german Windows MCE also set to 'Danish' everything works as expected.
Has anyone any ideas ?
Best regards
Søren Reinke