Converting string to integer VB.NET

I’m having trouble finding the right format for converting my txtID and txtCatID into integers since it’s in numbers in the database access.

Code

Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) _
    Handles btnSave.Click

    Dim sqlinsert As String

    sqlinsert = _
        "INSERT INTO Products (ProductID, Product, UnitPrice, CategoryName, CategoryID)" & _
        " VALUES (@ProductID, @Product, @UnitPrice, @CategoryName, @CategoryID)"
    Dim cmd As New OleDb.OleDbCommand(sqlinsert, con1)

    cmd.Parameters.Add(New OleDbParameter("@ProductID", (txtID.Text)))
    cmd.Parameters.Add(New OleDbParameter("@Product", txtProd.Text))
    cmd.Parameters.Add(New OleDbParameter("@UnitPrice", txtPrice.Text))
    cmd.Parameters.Add(New OleDbParameter("@CategoryName",txtCategory.Text))
    cmd.Parameters.Add(New OleDbParameter("@CategoryID", (txtCatID.Text)))

    con1.Open()
    cmd.ExecuteNonQuery()
    con1.Close()

    ClearTextBox(Me)
    RefreshDGV()
    Me.Close()

Leave a Comment