neha prasad

neha prasad

  • NA
  • 60
  • 0

The numerical value is too large to fit into a 96 bit decimal.

Sep 26 2011 5:04 AM
Hello,

       I have an issue in which I am binding a table from sql by executing query

"select * from test"

in this table the data are in this format :

Id            Name                        Details
1            dinesh                 987654312.00000000000000000000
2            sandeep              987654312.00000000000000000000
3             neha                  987654312.00000000000000000000
4             sunil                  987654312.00000000000000000000

but wen i am binding it then its displaying error as
"The numerical value is too large to fit into a 96 bit decimal."


The Datatype of columns of Table is as follows:-
Name       DataType               Allow null
Id             nchar(10)                Checked
Name       nchar(10)                Checked
Amount    numeric(38, 20)       Checked

 Code which I have written is as follows:-

Dim da As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter(
tmpquery, ConnectionString)
Dim dt As New DataSet
da.Fill(dt)

Please help me.....

Attachment: sample_int96issue.rar

Answers (6)