To load data from multiple SQL tables into a C# data grid view you must first create a view in SQL which you will then add to your model. Once created, using entity framework in Visual Studio’s IDE you can call the data-set to load data into your data grid view.
Step 1 : In Microsoft SQL Server Management Studio Object Explorer right click on your view folder and select new view. Add the tables you want to pull data from and save the view in SQL.
Step 2 : In Visual Studio IDE go to your Model.edmx and right click then select update model from database. Select the view from the update wizard and click finish.
Step 3 : From Visual Studio IDE select a datagrid component, add it to your form then on the top right corner click on select datasource. Find the Datasource , select it and it will be loaded on the data grid component on your form.