CODEWITHSUNDEEP
.netvb.netms-access
Mokmeuh
Mokmeuh

Reputation: 885

OleDbException entering decimal into decimal not working

So I'm trying to save my data set into my database

what is not working : The decimal in column 1

What I've tried :

    Using con = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source = Mokmeuh.accdb")


    con.Open()

    Dim cmb As New OleDbCommandBuilder(dAdapter)


    Try
        dAdapter.Update(dSet.Tables("Articles_table"))
    Catch ex As OleDbException
        Console.WriteLine(ex.InnerException)
    End Try
End Using

The error itself would be : OleDbException -2147217913 ¸ wich is a criteria mismatch but the things is I put A DAMN DECIMAL INTO THE CELLL .... i'm really piss I can't see why is not working

the column property would be Field size : Decimal Format : Currency/General (Neither work) Precision : 15 Scale : 2

I really need some help I need someone ....

Upvotes: 0

Views: 124

Answers (1)

DRapp
DRapp

Reputation: 48169

The only thing I'm not specifically seeing is your command builder not having a call go "GetUpdateCommand()" which generates the necessary SQL-Update command to apply any changes to the dataset

Upvotes: 0

Related Questions