>>>When I change to the following:
>>>
>>>param.SqlDbType = System.Data.SqlDbType.Decimal;
>>>param.Value = 0.00;
>>>
>>>
>>>I get compiler error.
>>
>>What?
>
>What I wrote in the other message about "The explicit conversion exists (are you missing a cast?)"
That works for me:
SqlCommand sql = new SqlCommand();
sql.Parameters.Add("asd");
sql.Parameters[0].SqlDbType = SqlDbType.Decimal;
sql.Parameters[0].Size = 10;
sql.Parameters[0].Value = 0.00;
sql.Parameters[0].Direction = ParameterDirection.InputOutput;
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.