ASP & Decimal in SQL-server

[Fredde]

I have recently switched from Access to SQL-Server.

I'm trying to insert a value of SQL-type DECIMAL into my database from an input Texbox. My question is: how do I do it? Do I have to use CONVERT in my SQL-expression or can I cast the TextBox.value-string to a proper type?


sqlInsertCommand_Material.Parameters["@Price"].Value = TextBox_MaterialPrice.Text;

Where this parameter should be of SQL_Decimal type


/Fredrik

 

[Ecreations]

Try something like this

sqlInsertCommand_Material.Parameters["@Price"].Value = TextBox_MaterialPrice.Text.ToDecimal();

Good luck

http://ecreationscanada.com

What would you attempt to accomplish if you knew you would not fail?

Prayers are like junk mail, hardly looked at.

 

[dragonwell]

or

sqlInsertCommand_Material.Parameters["@Price"].Value = Decimal.Parse(TextBox_MaterialPrice.Text);