SqlDBType

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have a table in sql server with the datatype "numeric". What would be the sqldbtype in the parameter object. I can't finf any numeric. Is there a SqlDbType.Numeric

Thanks
 
Hi Chris,

Try with Decimal.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Chris said:
Hi,
I have a table in sql server with the datatype "numeric". What would be
Click to expand...
the sqldbtype in the parameter object. I can't finf any numeric. Is there a
SqlDbType.Numeric?
 
Decimal or Float should both do it for you.
Chris said:
Hi,
I have a table in sql server with the datatype "numeric". What would be
Click to expand...
the sqldbtype in the parameter object. I can't finf any numeric. Is there a
SqlDbType.Numeric?
 
Hey Chris,

No, there is not a SqlDbType.Numeric, you need to map it to an appropriate
number data type. The SqlDataAdapter generates a SqlDbType.Decimal with
size set to 9 for a Numeric Sql database type.

Hope that helps,

Tom Krueger
Blue Pen Solutions
http://www.BluePenSolutions.com



Judging by what is generated by a SqlDataAdapter
Chris said:
Hi,
I have a table in sql server with the datatype "numeric". What would be
Click to expand...
the sqldbtype in the parameter object. I can't finf any numeric. Is there a
SqlDbType.Numeric?
 
Back
Top