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()