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

See more:

VB

Hello ;

I have a Table whose structure is as follows:-

Name DataType Allow null
Id int Checked
Name nchar(10) Checked
Amount numeric(38, 20) Checked
sales decimal(38,20) checked

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

select * from [96bitIssue]

in this table the data are in this format

ID Name Amount Sales
3 aa 715894125.38461538459812461538 757654312.38461538461538461538
4 xdf 753694125.38461538459812461538 757654312.38461538461538461538
5 Neha 235694125.38461538459812461538 757654312.38461538461538461538
6 sandeep 452694125.38461538459812461538 757654312.38461538461538461538
7 scf 484562125.38461538459812461538 757654312.38461538461538461538

When I am using OleDb Connection I am getting this error
The numerical value is too large to fit into a 96 bit decimal.
using following code..

Dim OLEDB_Con As OleDbConnection = New OleDbConnection("Provider=SQLOLEDB;Data Source=NEHA,1433;Initial Catalog=Test;User Id=sa;Password=sa@1234")
Dim da As New OleDbDataAdapter("select * from [dbo].[96bitIssue]", OLEDB_Con)            
Dim dt As DataTable = New DataTable()
OLEDB_Con.Open()
da.Fill(dt)
GridControl1.DataSource = dt

And when using SQLConnection I get error Conversion overflows

Dim SQlCon As SqlConnection = New SqlConnection("Data Source=NEHA,1433;Initial Catalog=Test;User Id=sa;Password=sa@1234")
Dim da As New SqlDataAdapter("select * from [dbo].[96bitIssue]", SQlCon)
Dim dt As DataTable = New DataTable()
SQlCon.Open()
da.Fill(dt)
GridControl1.DataSource = dt

Kindly Please help me.....
Exactly we are getting wrong and whats the solution for it......