Start New Discussion within our Software Development Community

Hello guys
Please help me about this error. When i hit the save button it gives me error
"failed to convert parameter value from a string to decimal".
Here is my code

Dim cnSQL As New SqlConnection(con)
        cnSQL.Open()
        Dim cmd As SqlCommand = cnSQL.CreateCommand()
        cmd.CommandType = CommandType.StoredProcedure
        cmd.CommandText = "sp_InsertPNB"

        Dim param() As SqlParameter = New SqlParameter(6) {}
        param(0) = New SqlParameter("emp_code", SqlDbType.NChar)
        param(0).Value = txtempno.Text
        cmd.Parameters.Add(param(0))

        param(1) = New SqlParameter("polnum", SqlDbType.VarChar)
        param(1).Value = txtPolicyNo.Text
        cmd.Parameters.Add(param(1))

        param(2) = New SqlParameter("strt_date", SqlDbType.SmallDateTime)
        param(2).Value = dtpStrtPNB.Value.Date
        cmd.Parameters.Add(param(2))

        param(3) = New SqlParameter("req", SqlDbType.SmallMoney)
        param(3).Value = txtPNBReq.Text
        cmd.Parameters.Add(param(3))

        Dim num As Integer
        Integer.TryParse(cmbPNBins.Text.Split("-")(0), num)
        param(4) = New SqlParameter("inst", SqlDbType.SmallInt)
        param(4).Value = num
        cmd.Parameters.Add(param(4))

        param(5) = New SqlParameter("balance", SqlDbType.SmallMoney)
        param(5).Value = txtPNBBal.Text
        cmd.Parameters.Add(param(5))

        Try
            cmd.ExecuteNonQuery()
            cnSQL.Close()
            cnSQL.Dispose()
            cmd.Dispose()
            MessageBox.Show("Employee NYLife successfully save/update", "Prompt")
        Catch ex As Exception
            MessageBox.Show(ex.Message.ToString(), "Data Error")
            Exit Sub
        End Try

Any comments are appreciated.
Thanks in advance

This article has been dead for over six months. Start a new discussion instead.