[Mono-bugs] [Bug 595918] Decimal parameter stored incorrectly from sql stored procedure

[bugzilla_noreply at novell.com]

http://bugzilla.novell.com/show_bug.cgi?id=595918

http://bugzilla.novell.com/show_bug.cgi?id=595918#c2


jeevan kodali <kjeevan_kumar at yahoo.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |kjeevan_kumar at yahoo.com
           Platform|Other                       |32bit
         OS/Version|Other                       |Linux

--- Comment #2 from jeevan kodali <kjeevan_kumar at yahoo.com> 2010-04-12 22:17:43 UTC ---
Sorry, probably you need exact code to replicate this bug, here it is, I am
using .Net 2.0 and running it on Linux machine connecting to Sql Server 2005:

SqlCommand cmd = new SqlCommand("dbo.addXXX_Test", con.Connection);
cmd.CommandType = CommandType.StoredProcedure; 
cmd.Parameters.Add(new SqlParameter("@p_Name", SqlDbType.VarChar));
cmd.Parameters["@p_Name"].Size = 40;
cmd.Parameters["@p_Name"].Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
cmd.Parameters.Add(new SqlParameter("@p_DecimalCheck", SqlDbType.Decimal));
cmd.Parameters["@p_DecimalCheck"].Precision = 19;
cmd.Parameters["@p_DecimalCheck"].Scale = 5;
cmd.Parameters["@p_DecimalCheck"].Value = 5.123;
cmd.ExecuteNonQuery();

con.ConnectionString is just a connection string to the database.

The table structure in sql server is:
create table dbo.XXX_Test
(
   Name VARCHAR(40),
   DecimalCheck DECIMAL(19,5) null
) ON Test_Data
GO

When I execute above code and do select * from XXX_Test, it shows .05123 for
DecimalCheck instead of 5.123.

Hope this helps.

Thanks

-- 
Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.
You are the assignee for the bug.