Merge two rows in datagridview

See more:

C#

WinForms

DataGridView

Hi friends,



I am working on a attendance project, and I have three columns

1.Employee Name

2.Session(Morning / evening)

3. Jan 1 to Jan 31

example:



Empname Session Jan1 Jan2 Jan 3............... Jan 31

Rajesh Morning P A P

Evening P P P

Mohan Morning A P A

Evening A A P

Karthick Morning P P P

Evening P P P



I want to achieve this. I am pretty new to programming. I already bind days in a month. Now I wanna bind the empname by using row span. and want to bind Morning & Evening in a for until the end of the record.

code:

private void BtnClick_Click_1(object sender, EventArgs e)
        {

 dgAttendance.Columns.Clear();
            GetData("select empname from employee");
            DataGridViewColumn cb = new DataGridViewColumn();
            DataGridViewCell cell = new DataGridViewTextBoxCell();
            cb.HeaderText = "Session";
            cb.Name = "Session";
            cb.Visible = true;
            cb.Width = 70;
            cb.CellTemplate = cell;
            dgAttendance.Columns.Add(cb);
            int days = DateTime.DaysInMonth(Convert.ToInt32(cmbYear.SelectedItem), Convert.ToInt32(cboMonths.SelectedIndex + 1));
            for (int i = 1; i <= days; i++)
            {

                DataGridViewColumn cb1 = new DataGridViewColumn();
                DataGridViewCell cell1 = new DataGridViewTextBoxCell();
                cb1.HeaderText = Convert.ToString(cboMonths.Text) + i;
                cb1.Name = Convert.ToString(cboMonths.SelectedIndex) + i;
                cb1.Visible = true;
                cb1.Width = 70;
                cb1.CellTemplate = cell1;
                dgAttendance.Columns.Add(cb1);

            } }