<asp:GridView ID="GridView2" runat="server" EnableTheming="False" PageSize="25" Width="900px"
      OnPageIndexChanging="GridView1_PageIndexChanging" OnRowDataBound="GridView1_RowDataBound"
      meta:resourcekey="GridView1Resource1" AutoGenerateColumns="False">
   <Columns>
    <asp:TemplateField HeaderText="Employee Loan Balance Details">
	<ItemTemplate>
	    <table>
		<tr>
		    <td>
			Company</td>
		    <td>
			:</td>
		    <td colspan="4">
			<asp:Label ID="lblCompany" runat="server" Text='<%# Bind("Company") %>'></asp:Label></td>
		</tr>
		<tr>
		    <td>
			Date</td>
		    <td>
			:</td>
		    <td colspan="4">
			<asp:Label ID="lblDate" runat="server"></asp:Label></td>
		</tr>
		<tr>
		    <td colspan="6">
			<asp:GridView ID="GridView1" runat="server" AllowPaging="True" EnableTheming="False"
			    PageSize="20" Width="100%" OnPageIndexChanging="GridView1_PageIndexChanging"
			    OnRowDataBound="GridView1_RowDataBound" meta:resourcekey="GridView1Resource1"
			    AutoGenerateColumns="False">
			    <Columns>                                                        
				<asp:BoundField DataField="User Name" HeaderText="Name">
				    <ItemStyle HorizontalAlign="Left" />
				</asp:BoundField>
				<asp:BoundField DataField="LoanName" HeaderText="Loan">
				    <ItemStyle HorizontalAlign="Left" />
				</asp:BoundField>
				<asp:BoundField DataField="Show Name" HeaderText="Payroll Month">
				    <ItemStyle HorizontalAlign="Left" />
				</asp:BoundField>
				<asp:BoundField DataField="PDate" HeaderText="Paid Date">
				    <ItemStyle HorizontalAlign="Center" />
				</asp:BoundField>
				<asp:BoundField DataField="OpeningBalance" HeaderText="Open Date">
				    <ItemStyle HorizontalAlign="Right" />
				</asp:BoundField>
				<asp:BoundField DataField="PaidAmount" HeaderText="Amt. Paid">
				    <ItemStyle HorizontalAlign="Right" />
				</asp:BoundField>                                                      
			    </Columns>
			    <RowStyle CssClass="reporttext" />
			    <EmptyDataTemplate>
				<strong><span style="font-size: 10pt;">No Records....!</span> </strong>
			    </EmptyDataTemplate>
			    <PagerStyle CssClass="reportheader" />
			    <HeaderStyle CssClass="reportheader" Width="80px" />
			    <AlternatingRowStyle CssClass="reporttext" />
			</asp:GridView>
		    </td>
		</tr>                                       
	    </table>
	</ItemTemplate>
    </asp:TemplateField>
  </Columns>                       
</asp:GridView>



protected void FirstGridBind()
    {
        DataTable dt1DataTable = new DataTable();
        dt1.Columns.Add("CompanyName");
        DataRow drDataRow = dt1DataTable.NewRow();
        if (ddlCompany.SelectedValue != "0")
        {
            drDataRow["CompanyName"] = ddlCompany.SelectedItem.Text;
        }
        else
        {
            drDataRow["CompanyName"] = "All Companies";
        }

        dt1DataTable.Rows.Add(drDataRow);
        GridView2.DataSource = dt1DataTable;
        GridView2.DataBind();
    }

protected void SecondGridBind()
    {
        foreach (GridViewRow row in GridView2.Rows)
        {
            Label lblDate = row.FindControl("lblDate") as Label;
            if (txtFromDate.Text.Trim() != "" && txtToDate.Text.Trim() != "")
            {
                lblDate.Text = txtFromDate.Text.Trim() + " - " + txtToDate.Text.Trim();
            }
            else
            {
                lblDate.Text = "All Dates";
            }
            GridView GridView1 = row.FindControl("GridView1") as GridView;

            string str = @"SELECT     You query;

            if (ddlCompany.SelectedValue != "0")
            {
                str += " AND (hrdEmployeeMaster.CompanyId = " + Convert.ToInt32(ddlCompany.SelectedValue) + ")";
            }            

            DataTable dt = SqlHelper.ExecuteDataset(connString, CommandType.Text, str).Tables[0];
            Session["myDataTable"] = dt;
            GridView1.DataSource = dt;
            GridView1.DataBind();
            if (GridView1.Rows.Count > 0)
            {
                lbExport.Visible = true;                
                
            }
        }
    }

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            if (GridView2.Rows.Count > 0)
            {
                GridView GridView1 = GridView2.Rows[0].FindControl("GridView1") as GridView;

                e.Row.Cells[0].Text = Convert.ToString(GridView1.PageIndex * GridView1.PageSize + SrNo);
                SrNo++;
            }
        }
    }