Table design is
CREATE TABLE [dbo].[mst_LeaveType](
[Id] [varchar](50) NOT NULL primary key,
[LeaveDesc] [varchar](50) NOT NULL,
[Paid_UnPaid] [varchar](5) NOT NULL,
[TraineeAppl] [varchar](5) NOT NULL,
)
In the above table leave desc contains Casual leave,Maternal leave,Sick leave,Paternal leave.
Paid_unpaid is whether that leave is with paid salary or unpaid salary.
Traineeappl is whether that leave is applicable for trainees.
in the gridview i need all the leave type as column name with textbox and under casual leave header i need two textbox in gridview one textbox is to load from previous year balance and another is to enter current year balance.
under the maternal leave header the textbox should be in enabled state only for female employees and under paternal leave header the textbox should be enabled only for male emplyees.
It will be helpfull if i get only gridview design for this dynamically when a new leave type is added in table
Thanks in advance