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/de...lasstopic.asp]

Hope that helps
R. Pooran Prasad
Itreya Technologies Pvt Ltd.,
Mail: pooran.prasad_at_itreya.com
Phone(Off) : [phone] Extn: 51
Mobile: [phone]

-----Original Message-----
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

.