Dataset problem with numbers

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Søren Reinke

    #1

    Dataset problem with numbers

    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


Working...