how to change the column name and update in to the data grid view using csharp

See more:

C#

Database as follows using data grid view ;

S no int
Staff code varchar
staff name varchar
mobile varchar
Active char(1)

in this table 100 of records are there.table name schedule.

Design as follows;

Day Period staff name staff name staff name staff name staff name.

instead of staff name i get the staff name from the data base table and display in to the data grid view.

i want the output as

Day Period VRV RK Ck Mk PL GS CMK

The above name VRV RK Ck Mk PL GS CMK should be retrieve from the data base, table name is schedule.

from the schedule table i want to get the staff name and display in to the data grid view column.

please send the code.