How to convert String to Long or Int??

Hi,
Can't really convert string to long.. or int.. Pls enlighten me?
thanks...

'Serial Number is number value in access database
Dim StockVerification As New OleDbCommand("SELECT serial_number from stock where serial_number = '" + txbRentalSerial.Text + "'", cnnRental)

'will prompt 'data mismatch' when executing the program
Tried using below and cant also...

Dim mylong As Long
Dim s As String
'mylongl = CLng(txbRentalSerial.Text)
'mylong = System.Convert.ToInt64(txbRentalSerial.Text())

Dim mylong As Long
mylong = CLng(txtRentalSerial.Text)
MsgBox(mylong.ToString())

That works.... you had some typos in the code you posted. I don't know if that was copied and pasted from your project, if so, that could be your problem. This worked fine for numeric values I entered into the textbox txtRentalSerial.

Chris

Although valid, your code will produce an error balmerch if the user has typed a non-numeric character in the text box.

You will need to either wrap the code in a TryCatch, or use th Val function on the contents of the text box.

Thanks Chris...
What is the difference between msgbox() and messagebox.show()
i used messagebox.show() will encounter this error...
"Option string On disallow implicit conversion from long to string"

Now tat i can conver to mylong... how do i pass it into the txbrentalserial.text..?

Dim StockVerification As New OleDbCommand("SELECT serial_number from stock where serial_number = '" + txbRentalSerial.Text + "'", cnnRental)

Use either :
1-The static method [ Convert.ToXXX )

or

2-Long.Parse (xxxx)