Convert decimal values

Shyja Abraham

I have a form with 3 textboxes and aslo other tools. in these 3 have decimal values.

in databse ,table have 4 fields (name varchar(),qty decimal(),value decimal(),price decimal()) named item

When we insert the the textbox values into the databse it passes only integer part values not decimal points. i use storedprocedure.

I use the code like

cn.insert( textbox1.text,Convert.ToDecimal(textBox2.Text), Convert.ToDecimal(textBox3.Text), Convert.ToDecimal(textBox4.Text))
but it takes only integer part. how we insert decimal point values ? plz help.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sandeep Shekhawat15y ago
Accepted answer
U define database field is decimal(18,2) here 2 is number of digit after point.

I think you table field will be like decimal(18,0) u simply change this decimal(18,2). then u will get fraction part.if u want more than two digit after point then change decimal(18,4) like any number u want.
0
Vilas Gite15y ago
refer..
http://msdn.microsoft.com/en-us/library/f02979c7.aspx

---------------------

If this reply hepls your post…then "MARK AS ANSWER"!
0
Vilas Gite15y ago
hi Shyja
use TryParse

some like below...

double dItem1Qty;
double.TryParse(Item1Qty.Text, out dItem1Qty);
Item1Qty.Text = dItem1Qty.ToString();

------------

If this reply hepls your post…then "MARK AS ANSWER"!
0