Yes, this can be done. If you know SQL then the format is all you will need to get used to.
To get started you must connect to the database, and utilize a DataAdapter and DataSet. I have worked with this through Access via SQL and the three used are shown in red. You might need to use the two in green for your's. You will need the DataSet regardless.
The first thing you will need to do is connect to your database. In the properties for data...select "new connection" from the dropdown list...and then browse to your database,,,don't forget to test your connection or it will crash.
Second, configure your DataAdapter. When you click on it, the bottom of your properties box will contain a link that says "Configure Data Adapter..." Click on that.
Finally, the DataSet. This is what you will load the results of your query's into and pull from.
Now lets take a look at some of the code you will need to use. (keep in mind that this is only for syntax -- real names and values will be yours)
code said:
OleDbConnection1.Open()
sql = "select students.studentID, students.name, students.password "
TestDataAdapter.SelectCommand.CommandText = sql
DataSet.Clear()
TestDataAdapter.Fill(DataSet, "students")
avtests = DataSet.Tables("tests")
Catch exception As System.Data.OleDb.OleDbException
MessageBox.Show("Invalid Query")
TestDataAdapter.UpdateCommand.CommandText = squpd
TestDataAdapter.UpdateCommand.ExecuteNonQuery()
Now avtests is global and declared as type "DataTable" So you can get to it from other locations.
You may notice that I used the error correction of type exception...I use this so if there is an error, regardless of what it is, I can exit w/o the crash (saves time in debug)
There is much to this type of setup, and I know I just scratched the surface for you. I do not know if this is enough for completion, but it should get you in that direction. Good luck

[tsg=welcome]Toonworld! To the best tech-support site on the net![/tsg]