I'm with Borislav on this. .Net types aren't the same as DB types. To confuse things even more, you have things like

param.Value = DbNull.Value;

Since when does Null have a value?

>Yet another question on setting up values to parameters to be passed to a sql server stored procedure.
>
>Here is an example.
>One of the parameters of the stored procedure is of type number:
>
>

>@nTest numeric(10,2) OUTPUT
>--- set value
>set @nTest = 3333.33
>

>
>Then in the C# code when creating the parameter I do the following
>

>param.DbType = System.Data.DbType.Decimal;
>param.Value = 0;
>param.Direction.InputOutput;
>

>
>But after I call the oCommand.ExecuteNonQuery() I get error
>
>

>Error converting data type numeric to numeric
>

>
>What am I missing?
>
>TIA.
>
>UPDATE: The title of the thread is wrong. It should have said, Using Decimal type parameter.