Display multiple qualification for each Employee in nested GridView with RowDataBound event using C# in ASP.Net

Hi Waghmare,

Can you tell what exactly you are trying to do and do tell how is output generating when you are firing query.

I have table structure like

employee table : EmpId,Name,Designation,GroupName.

Qualifiction Table: Id,Qulification

SubjectTable:Id,Subject

QualEmpLinkTable : QualID,EmpId,SubjectID

Where a single employee can have multiple qualifications and there subjects.

If employee 1 have 3 qualified degrees then the qualification columns row for particular employee data sholud split in 3 rows.

according like that the every employee have different qualifications some have 1 or 3 or 2.

so i want to split rows of that particular columns.

Hi Waghmare,

Please refer below articles

1. Gridview inside Gridview in ASP.Net using C# and VB.Net
2. Nested GridView in ASP.Net 3.5 using VB.Net and C# Example
3. Nested GridView Example in ASP.Net using C# and VB.Net
4. ASP.Net Nested GridViews – GridView inside GridView with Expand and Collapse feature

HAve reffered those links 

They have taken nested grid inside the grid .

I want to show that nested grid data in same grid by splitting those cells.

Hi Waghmare,

I have created a sample which full fill your requirement

HTML

<div align="center">
    <asp:GridView ID="gvEmployees" runat="server" AutoGenerateColumns="false" DataKeyNames="EmpId"
        OnRowDataBound="OnRowDataBound">
        <Columns>
            <asp:BoundField DataField="EmpId" HeaderText="Sr.No" />
            <asp:BoundField DataField="Name" HeaderText="Name" />
            <asp:BoundField DataField="Designation" HeaderText="Designation" />
            <asp:BoundField DataField="GroupName" HeaderText="GroupName" />
            <asp:TemplateField HeaderText="Qualification">
                <ItemTemplate>
                    <asp:GridView ID="gvQualification" ShowHeader="false" runat="server" AutoGenerateColumns="false">
                        <Columns>
                            <asp:BoundField DataField="QualifictionDegree" />
                        </Columns>
                    </asp:GridView>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Subject">
                <ItemTemplate>
                    <asp:GridView ID="gvSubject" ShowHeader="false" runat="server" AutoGenerateColumns="false">
                        <Columns>
                            <asp:BoundField DataField="SubjectName" />
                        </Columns>
                    </asp:GridView>
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>
    </asp:GridView>
</div>

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        gvEmployees.DataSource = GetData("SELECT EmpId,Name,Designation,GroupName FROM Employee");
        gvEmployees.DataBind();
    }
}

private static DataTable GetData(string query)
{
    string strConnString = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
    using (SqlConnection con = new SqlConnection(strConnString))
    {
        using (SqlCommand cmd = new SqlCommand())
        {
            cmd.CommandText = query;
            using (SqlDataAdapter sda = new SqlDataAdapter())
            {
                cmd.Connection = con;
                sda.SelectCommand = cmd;
                using (DataSet ds = new DataSet())
                {
                    DataTable dt = new DataTable();
                    sda.Fill(dt);
                    return dt;
                }
            }
        }
    }
}

protected void OnRowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        string EmpId = gvEmployees.DataKeys[e.Row.RowIndex].Value.ToString();
        GridView gvQualification = e.Row.FindControl("gvQualification") as GridView;
        GridView gvSubject = e.Row.FindControl("gvSubject") as GridView;
        gvQualification.DataSource = GetData(string.Format(@"SELECT Qualifiction.QualifictionDegree
	                                                                  
                                                                FROM [QualEmpLinkTable] 
                                                                INNER JOIN Employee
                                                                ON [QualEmpLinkTable].EmpId = Employee.EmpId
                                                                INNER JOIN Qualifiction
                                                                ON Qualifiction.QualId = [QualEmpLinkTable].QualID
                                                                WHERE Employee.EmpId ='{0}'", EmpId));
        gvQualification.DataBind();
        gvSubject.DataSource = GetData(string.Format(@"SELECT [Subject].SubjectName
                                                                FROM [QualEmpLinkTable] 
                                                                INNER JOIN Employee
                                                                ON [QualEmpLinkTable].EmpId = Employee.EmpId
                                                                INNER JOIN [Subject]
                                                                ON [Subject].SubjectId = [QualEmpLinkTable].SubjectID
                                                                WHERE Employee.EmpId ='{0}'", EmpId));
        gvSubject.DataBind();
    }
}

ScreenShot