Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
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.
Posted 8-Jan-13 21:30pm

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

You can write SQL that renames the columns, or write your own grid view template that labels the headers any way you wish.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 255
1 Sergey Alexandrovich Kryukov 150
2 BotCar 105
3 Richard MacCutchan 100
4 ChauhanAjay 95
0 Sergey Alexandrovich Kryukov 9,056
1 OriginalGriff 8,041
2 CPallini 2,613
3 Richard MacCutchan 2,221
4 Abhinav S 1,928


Advertise | Privacy | Mobile
Web04 | 2.8.140827.1 | Last Updated 9 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100