The code is now:
Code:
Dim connection As New OleDbConnection
("Provider=Microsoft.Jet.OLEDB.4.0;Source=C:\MSDS\MSDS DATABASE DATA\MSDS.mdb;")
Dim [command] As New OleDbCommand("SELECT * FROM Students WHERE FirstName LIKE ?", connection)
[command].Parameters.AddWithValue("@FirstName", Me.TextBox1.Text & "%")
connection.Open()
Dim rdr As OleDbDataReader = command.ExecuteReader()
Dim tbl As New DataTable()
tbl.Load(rdr)
Me.StudentsDataGridView.DataSource = tbl
rdr.Close()
connection.Close()
And there is a crash due to
connection.Open() stating: Could not find installable ISAM.
I tried to fix the problem through this:
http://support.microsoft.com/kb/209805
But all registry references were correct and files were found.
EDIT: Probably has something to do with the fact that I don't have Microsoft Access installed. Tho that hasn't stopped me up to this point.