//Add other fkey columns here or just delete below, and use the snippet over again

//Sets up the main Table for dataGridView binding comment out or delete if using multiple fkey snippets //best declared with a larger scope than this function so it can later be submitted to the tableAdapter for updates

var mainTable = DataSet1.mainTable();

var MainBinding = new BindingSource();

MainBinding.DataSource = mainTable;

dataGridView1.DataSource = MainBinding;

//Must call MainBinding.EndEdit(); after updates, so it will update the MainTable

// then you can pass the mainTable to a dataAdapter to do all the updates.