Show data in a datagrid from Multiple tables

I have three tables named Names ,Departments and Students.The Names table contains columns named NameId and Name.NameId is the primary key.Here the input data for NameId is 1,2,3 and data for the Name are Ronok,Marsh and Priom accordingly. Then the table Departments contains the Column Names NameId,DepartmentId and the DepartmentName.Here DepartmentId is the primary key and NameId is the foreign key.Here the input data are 1,1,CSE ,2,2,EEE and soforth.The third table is the Students table.Here the column names are NameId and the DepartmentId.These two column are foreign key of Names and Departments table.