Conversion overflows error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Toniyo Jackson
    New Member
    • Jun 2010
    • 4

    Conversion overflows error

    Am getting the 'conversion overflows' error while running the stored procedure. In stored procedure one column is having 30 decimal places. Due to this am getting this error. But, i have only read only access to stored procedure. i cant modify it. So i need to solve this problem in code.

    Please help me......

    Code:
    Dim objCMD As New SqlCommand            
    Dim objDA As New SqlDataAdapter            
    Dim objDS As DataSet            
    With objCMD                
    .Connection = sqlCon                
    .Parameters.AddRange(sqlParam)
    .CommandType = CommandType.StoredProcedure                
    .CommandText = "stored procedure name"
    End With
    objDA.SelectCommand = objCMD            
    objDS = New DataSet            
    objDA.Fill(objDS)
    In data adapter filling am getting this error.
Working...