text box and SqlDecimal datatypes

[Mark]

Hi all, I have a DAL which takes in a value as shown below ready for my
MSSQL stored procedure.

protected SqlDecimal _annualLeave = SqlDecimal.Null ;
public SqlDecimal AnnualLeave
{

get {return _annualLeave;}

set{ _annualLeave = value;}

}

I have a problem where when I try to pass in information from a textbox on a
ASP.NET page OR Winform the *damn* thing gets rounded to an Integer!

I thought I could just go..

((System.Data.S qlDecimal)Annua lLeave.Text)

Where AnnualLeave.Tex t is the value of my textbox on my form, but I received
"Cannot convert type 'string' to 'System.Data.Sq lTypes.SqlDecim al" error
(Which is fair enough)

So, I tried

((System.Data.S qlDecimal)(Conv ert.ToDecimal(A nnualLeave.Text ))

but for some reason, this rounds the number to an integer!! e.g. 12.2
becomes 12!!!!!

Can someone please tell me what am I doing wrong here, it's been a long day
:P

Thanks
Mark

[Onin Tayson]

Hi Mark,

just use Convert.ToDecim al(AnnualLeave. Text)

HTH,

"Mark" <ma**@Z-Zvolution.nZt> wrote in message
news:OQ******** ******@TK2MSFTN GP12.phx.gbl...

Hi all, I have a DAL which takes in a value as shown below ready for my
MSSQL stored procedure.

protected SqlDecimal _annualLeave = SqlDecimal.Null ;
public SqlDecimal AnnualLeave
{

get {return _annualLeave;}

set{ _annualLeave = value;}

}

I have a problem where when I try to pass in information from a textbox on
a
ASP.NET page OR Winform the *damn* thing gets rounded to an Integer!

I thought I could just go..

((System.Data.S qlDecimal)Annua lLeave.Text)

Where AnnualLeave.Tex t is the value of my textbox on my form, but I
received
"Cannot convert type 'string' to 'System.Data.Sq lTypes.SqlDecim al" error
(Which is fair enough)

So, I tried

((System.Data.S qlDecimal)(Conv ert.ToDecimal(A nnualLeave.Text ))

but for some reason, this rounds the number to an integer!! e.g. 12.2
becomes 12!!!!!

Can someone please tell me what am I doing wrong here, it's been a long
day
:P

Thanks
Mark

[Mark]

Hi Onin, I was actually doing this originally and still get the same
problem.

Thanks for your advice
Cheers
Mark
"Onin Tayson" <Le*********@co mpaid.com> wrote in message
news:O%******** ********@tk2msf tngp13.phx.gbl. ..

Hi Mark,

just use Convert.ToDecim al(AnnualLeave. Text)

HTH,

"Mark" <ma**@Z-Zvolution.nZt> wrote in message
news:OQ******** ******@TK2MSFTN GP12.phx.gbl...

Hi all, I have a DAL which takes in a value as shown below ready for my
MSSQL stored procedure.

protected SqlDecimal _annualLeave = SqlDecimal.Null ;
public SqlDecimal AnnualLeave
{

get {return _annualLeave;}

set{ _annualLeave = value;}

}

I have a problem where when I try to pass in information from a textbox on a
ASP.NET page OR Winform the *damn* thing gets rounded to an Integer!

I thought I could just go..

((System.Data.S qlDecimal)Annua lLeave.Text)

Where AnnualLeave.Tex t is the value of my textbox on my form, but I
received
"Cannot convert type 'string' to 'System.Data.Sq lTypes.SqlDecim al" error
(Which is fair enough)

So, I tried

((System.Data.S qlDecimal)(Conv ert.ToDecimal(A nnualLeave.Text ))

but for some reason, this rounds the number to an integer!! e.g. 12.2
becomes 12!!!!!

Can someone please tell me what am I doing wrong here, it's been a long
day
:P

Thanks
Mark