Groups | Blog | Home
all groups > asp.net webcontrols > june 2003 >

asp.net webcontrols : Called a Stored Procedure , decimal parameter


Mona
6/27/2003 2:16:59 PM
I have a stored procedure with a decimal parameter .

how can send the decimal value?
I try this but it gives an error , invalid cast specified.

Dim p1 As SqlParameter = .Parameters.Add("@EstConstructionCost_10",
System.Data.SqlDbType.Decimal, 9).Value = CDbl(txtEstConstructionCost.Text)

' Dim p1 As SqlParameter = .Parameters.Add("@EstConstructionCost_10",
System.Data.SqlDbType.Decimal).Value = 10

p1.Precision = 10

p1.Scale = 0
I appreciate any help




AddThis Social Bookmark Button