Yes you will need to set up you connection to the Database then create your data set with the two tables and fill them from the Database. You could also use two datasets to store the data.
If you set up the relations to the tables in the one dataset then you can bind it to a datagrid on the win form and display both within there relation