บันทึกข้อมูลที่เป็นตัวเลขลง sql server + asp.net คือจะให้รับข้อมูลทาง textbox รับข้อมูลเป็น ตัวเลข

    Protected Sub BTAdd_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles BTAdd.Click
        Dim objConn As New SqlConnection
        Dim objCmd As New SqlCommand
        Dim strConnString, strSQL As String

        strConnString = "Server=.;UID=sa;PASSWORD=123;database=ACCMRC_database;" 'Max Pool Size=400;Connect Timeout=600;"

        strSQL = "INSERT INTO BCAR (code,Name1,defcontactcode,billaddress,telephone,Fax,debtlimit1,salecode) " & _
        " VALUES " & _
        " ('" & Me.txtcode.Text & "','" & Me.txtname.Text & "','" & Me.txtcontact.Text & "', " & _
        " '" & Me.txtaddress.Text & "','" & Me.txtTel.Text & "','" & Me.txtFax.Text & "'," & _
        " '" & Me.txtdebt.Text = FormatNumber("1234.5678", 2) & "','" & Me.txtsalecode.Text & "')"

        objConn.ConnectionString = strConnString
        objConn.Open()
        With objCmd
            .Connection = objConn
            .CommandText = strSQL
            .CommandType = CommandType.Text
        End With

        objConn.Close()
        objConn = Nothing

    End Sub