Getting Faculty name form the data base and bind it DGV

Data base as follow;

sno                       int
faculty code         varchar
Faculty name         varchar
Mobileno             varchar
Active               char(1)

in that data base records are saved.

 Designing Screen as follows using Data Grid View;

 Date       Session      RV MS TS CNN UNNI VB Gs

 8/1/2013     1
 8/1/2013     2
 8/1/2013     3

 the column as  RV MS TS CNN UNNI VB Gs has to be  retrieved from the data base.
 RV MS TS CNN UNNI VB Gs the above are the faculty name. that faculty name  is retrieved from the data base and bind in to the data grid view.

i want to get the Faculty name    from the data base and put in to the data grid view column.

for that how to write the code.