Cant Insert Decimal From Textbox

Hi guys.





Hopefully someone can help me, im pulling out my hair over this!





Im trying to insert a price into my MSSQL database.





The Column type is decimal.





If i use the following simple script





<%@ Page Language="VB" Debug="true" %>


<%@ Import Namespace="System.Data" %>


<%@ Import Namespace="System.Data.SqlClient" %>


<script language="VB" runat="server">


Sub Submit_Click(Sender As Object, E As EventArgs)


Dim sqlCmd AS SQLCommand


Dim sqlConn as SQLConnection = New SqlConnection("************;")


Dim mySQL as String = "Insert Into Products (Delivery, Price) Values (" & Dvalue.Text & ", " & Pvalue.Text & ")"


sqlCmd = New SQLCommand(mySQL,sqlConn)


sqlConn.Open()


sqlCmd.ExecuteNonQuery()


sqlConn.Close()


End Sub


</script>


<form action="" runat="server">


Delivery - <asp:TextBox ID="Dvalue" runat="server" /><br>


Price - <asp:TextBox ID="Pvalue" runat="server" /><br>


<Asp:Button id="Submit" runat="server" text="Insert" onclick="Submit_Click" />


</form>





And add in the values as


Delivery - 12.9999


Price - 56.777





The resulting numbers on the database are


Delivery - 13


Price - 57





Im using 1and1 to host my sql database and using their own SQL admin tool to configure it.





The price column has the following options





Name - Price


Type - Decimal


size(if char) - 19 ( i cant seem to change this)


default value - <blank> (I cant seem to change this)





No other options are ticked (as in nullable, indexed, unique key, primary key, identity)





Is there some setting or something ive missed/ dont know about? (ive only really used access and mysql in the past)





I would really appreciate any help