How to implement a selection from several database tables in a DataGridView

Question

SQL

Guys, hello everyone!
How to display data from database in DataGridView? And how it is desirable to edit it after, etc.?
I have a table, in it the columns in which there are id to other tables. Moreover, in these tables there may be IT specialists for other tables.
Table example

TABLE Формат
ID INT
NameID INT
ColorID INT
SortID INT

And if you can links where you can deepen your knowledge.
Thank you!

Answer 1

Use multiple DataGridViews to link data together.
Here is an example article from the manual:
msdn.microsoft.com/ru-ru/library/vstudio/y8c0cxey(...
This is about the editing modes in the DataGirdView:
msdn.microsoft.com/ru-ru/library/yztkd864(v= vs.110...
PS: Google rules...