Decimal rounds when inserted to SQL2k

[Mikael Engdahl]

Hello

I am calling a stored procedure in a SQL Server 2000 like this:

<code>
SqlCommand cmd = new SqlCommand("Sproc", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Param", SqlDbType.Decimal).Value = amount;
SqlDataReader reader = cmd.ExecuteReader();
</code>

/amount/ is decimal with the value 0.1, but when I check the
database it contains 0.

Why?

(The field and the sproc both use DECIMAL).
--
Mikael Engdahl

[Lee Alexander]

Try using the Money type on the SQL Server side.

Regards
Lee

"Mikael Engdahl" <mi******@engdahl.no.spam.com> wrote in message
news:eU**************@TK2MSFTNGP12.phx.gbl...

Hello

I am calling a stored procedure in a SQL Server 2000 like this:

<code>
SqlCommand cmd = new SqlCommand("Sproc", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Param", SqlDbType.Decimal).Value = amount;
SqlDataReader reader = cmd.ExecuteReader();
</code>

/amount/ is decimal with the value 0.1, but when I check the
database it contains 0.

Why?

(The field and the sproc both use DECIMAL).
--
Mikael Engdahl