Professional Web Applications Themes

Called a Stored Procedure , decimal parameter - ASP.NET General

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...

  1. #1

    Default Called a Stored Procedure , decimal parameter

    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





    Mona Guest

  2. #2

    Default Called a Stored Procedure , decimal parameter

    You might want to use CDec instead of CDbl.

    Tu-Thach
    >-----Original Message-----
    >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
    >
    >
    >
    >
    >
    >.
    >
    Tu-Thach Guest

Similar Threads

  1. Replies: 0
    Last Post: January 16th, 12:54 PM
  2. #40143 [NEW]: how to get parameter values of stored procedure.?
    By hd4_all at yahoo dot co dot in in forum PHP Bugs
    Replies: 0
    Last Post: January 16th, 12:02 PM
  3. populate datagrid with stored procedure w/parameter
    By Machelle Chandler in forum ASP.NET Data Grid Control
    Replies: 4
    Last Post: October 17th, 03:33 PM
  4. Stored Procedure/Parameter problem
    By ElmoWatson in forum ASP.NET General
    Replies: 1
    Last Post: August 6th, 01:19 AM
  5. Call a stored procedure with decimal parameter
    By Mona in forum ASP.NET General
    Replies: 2
    Last Post: June 27th, 01:31 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139