DataGrid

[David Powell]

I'm am new to DB Programming so i need beginners like help.

I have a Database with two tables. The database is named "netcallerid". The tables are named "Callers" and "CallList" Below is what each table contains

[Callers]
ID
FirstName
LastName
PhoneNumber

[Calls]
CallID
ID
Date
Time
New(1 if new, 0 if old)

I have the database setup and have sucessfully created a connection by doing the following

Dim SqlCONN as New MySqlConnection
SqlCONN.SetConnectionString = "server=localhost; user=root; password=pass; database=myDatabase;"
sqlCONN.Open()

There is alot more code to catch errors but the above shows you the method that i am using to open the database connection. Now what i want to learn how to do is Run a query that Joins the two tables by "ID" and displays the results in a DataGrid.

What are the steps i need to take to get the information from my Database to the datagrid?