Convert.ToDecimal(command.ExecuteScalar()) returns nothing

Question

Hi Does anybody have an idea why Convert.ToDecimal(command5.ExecuteScalar()) returns nothing in my C# code? I have a stored procedure which when tested returns good result but when I call the procedure from my c# application ...... ....... decimal saldo=Convert.ToDecimal(command5.ExecuteScalar()) when debugging I can see that saldo shows no value. I would appreciate any idea

Jignesh Trivedi · Answer

hi nel  I think Problem with datatype change it to numeric(123) try.. ALTER procedure [dbo].[presmetajSaldo] ( @data DateTime @saldo numeric(123) output ) as Declare @priem numeric(123) Declare @isplata numeric(123) set @data='2012.07.12' select @priem = sum(iznosden) from blag where data=@data and vp>=0 and vp select @isplata = sum(iznosden) from blag where vp>10 and data=@data set @saldo = isnull(@saldo0) + (isnull(@priem0)) - (isnull(@isplata0)) update Kasovizvestaj set saldo = @saldo where

Nel · Answer

Thank you very much Jignesh:). Now it works fine

Nel · Answer

Here is my code again for the sp: ALTER procedure [dbo].[presmetajSaldo] ( @data DateTime @saldo decimal output ) as Declare @priem decimal Declare @isplata decimal set @data='2012.07.12' select @priem = sum(iznosden) from blag where data=@data and vp>=0 and vp select @isplata = sum(iznosden) from blag where vp>10 and data=@data update Kasovizvestaj set saldo = isnull(@saldo0.0) + (isnull(@priem0.0)) - (isnull(@isplata0.0)) where data=@data select saldo from Kasovizvestaj return So the bolded line I suppose is the problem which returns only the int part but not the decimal part (399 .400 ). How to change it?

Jignesh Trivedi · Answer

hi Nel Are you go with out in SP? check datatype of your out parameter is might be int or any where in your SP it cast in int. check it and let me know. also share your SP and code. hope this will help you.

Nel · Answer

Thank you Jignesh:)Now I get the result which is ok but not showing the decimal part. For example the real result should be 399.400 and it shows 399.000 instead. Do you have an idea what is my mistake? Can you tell me please? Thanks again a lot.

Jignesh Trivedi · Answer

hi Nel Please refer below link. I think it is solution for your problem http://www.4guysfromrolla.com/articles/062905-1.aspx http://social.msdn.microsoft.com/Forums/zh/sqlexpress/thread/fe2a209a-8f6c-4d0f-b755-a5280cd6712e hope this will help you.

Santhosh Kumar Jayaraman · Answer

when you debugging can you check what is there inside command5.ExecuteScalar() in QUick watch window?