Converting string to integer VB.NET

Question

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

possible duplicate of Parse String to Integer (come hell or high water) — Gábor Bakos
– Gábor Bakos, Commented Mar 7, 2015 at 10:01

Peter Mortensen · Accepted Answer · 2015-07-06 14:00:28Z

3

You can convert String to int by doing like this:

For C#: int val = Int32.Parse("12");
For VB.NET: Dim val as Integer = CInt("12")

Here you can find all Type Conversion Functions (Visual Basic).

Here you have How to: Convert a String to a Number (C# Programming Guide).

edited Jul 6, 2015 at 14:00

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Jul 6, 2015 at 13:54

Abder KRIMA

3,6986 gold badges35 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Peter Mortensen · Accepted Answer · 2015-07-06 13:57:21Z

1

You can convert string from a TextBox to an integer using:

Dim myInt as Integer = CInt(Textbox1.Text)

Otherwise, if you are asking how to ensure that an integer is appended into an SQL file or Access file using VB.NET, then that's a different question.

edited Jul 6, 2015 at 13:57

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Mar 8, 2015 at 0:59

user1493382

Comments

Peter Mortensen · Accepted Answer · 2015-07-06 13:58:52Z

1

I solved it:

Dim productID As Integer

If (Integer.TryParse(txtID.Text, productID)) Then

    cmd.Parameters.Add(New OleDbParameter("@ProductID", productID))
Else
    Throw New ArgumentException("Entered ProductID is not a valid integer.")
End If


cmd.Parameters.Add(New OleDbParameter("@Product", txtProd.Text))

Dim price As Double
If (Double.TryParse(txtPrice.Text, price)) Then

    cmd.Parameters.Add(New OleDbParameter("@UnitPrice", txtPrice.Text))
Else
    Throw New ArgumentException("Invalid.")
End If

cmd.Parameters.Add(New OleDbParameter("@CategoryName", txtCategory.Text))

Dim id As Integer
If (Integer.TryParse(txtCatID.Text, id)) Then
    cmd.Parameters.Add(New OleDbParameter("@CategoryID", id))
Else
    Throw New ArgumentException("Entered Category ID is Invalid.")
End If

edited Jul 6, 2015 at 13:58

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Mar 8, 2015 at 10:37

Dani56

3821 gold badge2 silver badges7 bronze badges

Collectives™ on Stack Overflow

Converting string to integer VB.NET

Code

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

Code

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related