数值太大，无法容纳96位小数

问题描述

你好，

我有一个问题，我要通过执行查询从sql绑定表

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

但是我绑定了它，然后它显示错误为
数值太大，无法容纳96位十进制."


表的列的数据类型如下:-

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.....

推荐答案

这篇关于数值太大，无法容纳96位小数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！