Asked • 04/23/19

Why does "Conversion from string "ID" to type integer is not valid" show on my program?

I'm trying to display my database on textboxes, with the help of the combobox for the ID. However, whenever I run my program, the error **"Conversion from string "ID" to type integer is not valid"** keeps on appearing. What should I do? Private Sub FormAdd_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load cnn = New OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Database.accdb") Dim reader As OleDb.OleDbDataReader Try cnn.Open() Dim str As String = "select * from TableName" command = New OleDb.OleDbCommand(str, cnn) reader = command.ExecuteReader While reader.Read Dim sId = reader.GetName("ID") ComboBox1.Items.Add(sId) End While cnn.Close() Catch ex As OleDb.OleDbException MessageBox.Show(ex.Message) Finally cnn.Dispose() End Try End Sub Visual Basic says that the error is located here: Dim sId = reader.GetName("ID") Thank you so much!

1 Expert Answer


Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.


Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.