Datatype error

[al]

hi, I have a table that contain a field "amount" its
datatype is numeric(18,4) in sql server 2000

I have created a Datagrid, when I edit a record, I get an
error like this one
BC30456: 'Numeric' is not a member of 'System.Data.DbType'.
Line 213: dbParam_amount.ParameterName = "@amount"
Line 214: dbParam_amount.Value = amount.text
Line 215: dbParam_amount.DbType =
System.Data.DbType.Numeric
Line 216: dbCommand.Parameters.Add(dbParam_amount)

You can find the complete code at
http://aalhussein.webhostme.com/Q/dg_parameter_dt.htm

I am not sure if vb.net contain numerice datatype. Do I
have to use other datatype or what.
thanks
Al

 

[Pooran Prasad]

Hi Al,
Try System.Data.DbType.VarNumeric .. refer
[http://msdn.microsoft.com/library/d...pref/html/frlrfsystemdatadbtypeclasstopic.asp]

Hope that helps
R. Pooran Prasad
Itreya Technologies Pvt Ltd.,
Mail: pooran.prasad_at_itreya.com
Phone(Off) : +91(80)5200179 Extn: 51
Mobile: +91 98860 29578