Convert decimal values

Question

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.

Sandeep Shekhawat · Answer

U define database field is decimal(182) here 2 is number of digit after point. I think you table field will be like decimal(180) u simply change this decimal(182). 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.

Vilas Gite · Answer

refer.. http://msdn.microsoft.com/en-us/library/f02979c7.aspx --------------------- If this reply hepls your post…then  MARK AS ANSWER !

Vilas Gite · Answer

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 !