Object Reference Not Set To An Instance Object in Gridview

protected void bindLeaveApplication3()

{

string from = cboCutOffSelect.SelectedValue.Split('-')[0];

string to = cboCutOffSelect.SelectedValue.Split('-')[1];

using (SqlConnection con = new SqlConnection(DAO.ConnectionString))

{

con.Open();

using (SqlCommand cmd = new SqlCommand("dbo.DisplayAdminTimeKeeping_OTLeaveView", con))

{

cmd.Parameters.AddWithValue("@Status", 55);

cmd.Parameters.AddWithValue("@DateFrom", from);

cmd.Parameters.AddWithValue("@DateTo", to);

//sql = "Select empApproved.LeaveTranId, empApproved.EmployeeNo, empApproved.eName, empApproved.LeaveType,empApproved.ApplicationDate ,MIN(empDate.LeaveDate) as LeaveDateFrom, MAX(empDate.LeaveDate) as LeaveDateTo, empApproved.WholeOrPartial, empApproved.Status, empApproved.DateApproved, empApproved.Remarks,(Select (empInfo.LastName + ', ' + empInfo.FirstName) as ApprovedBy from dbo.EmpPersonalInfo empInfo where empInfo.UserName = empApproved.ApprovedBy) as ApprovedBy from ISMPayroll.dbo.EmpLeaveDates empDate inner join ISMPayroll.dbo.viewEmployeeLeaveDatesForApproved empApproved on empDate.LeaveTranId = empApproved.LeaveTranId where empDate.LeaveDate BETWEEN (Select ISMPayroll.dbo.CutOff_Period.CutOff_From from ISMPayroll.dbo.CutOff_Period where CutOffID='" + cutoffid + "') AND (Select ISMPayroll.dbo.CutOff_Period.CutOff_to from ISMPayroll.dbo.CutOff_Period where CutOffID='" + cutoffid + "') and empApproved.Status ='Approved' and empApproved.EmployeeNo='" + empNo + "' group by empApproved.LeaveTranId,empApproved.EmployeeNo, empApproved.eName, empApproved.LeaveType , empApproved.WholeOrPartial, empApproved.Status, empApproved.DateApproved, empApproved.Remarks, empApproved.ApprovedBy,empApproved.ApplicationDate";

cmd.CommandType = CommandType.StoredProcedure;

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();

da.Fill(dt);

dt.DefaultView.Sort = "EmpName Asc";

EmpLeaveAppGV2.DataSource = dt;

EmpLeaveAppGV2.DataBind();

}

}

{

int cutoffid = getCutOffID(cboCutOffSelect.SelectedValue);

if (e.Row.RowType == DataControlRowType.DataRow)

{

string empNo = EmpLeaveAppGV2.DataKeys[e.Row.RowIndex].Value.ToString(); //get datakey based on datakeyname of Main Grid (EmpLeaveAppGV2)

GridView gv2LeaveDetails = e.Row.FindControl("gv2LeaveDetails") as GridView; //find the grid view within Main grid which is to be populated

using (SqlConnection con = new SqlConnection(DAO.ConnectionString))

{

con.Open();

string sql;

sql = "Select empApproved.LeaveTranId, empApproved.EmployeeNo, empApproved.EmpName, empApproved.LeaveType,empApproved.ApplicationDate ,MIN(empDate.LeaveDate) as LeaveDateFrom, MAX(empDate.LeaveDate) as LeaveDateTo, empApproved.WholeOrPartial, empApproved.Status, empApproved.DateApproved, empApproved.Remarks,(Select (empInfo.LastName + ', ' + empInfo.FirstName) as ApprovedBy from dbo.EmpPersonalInfo empInfo where empInfo.UserName = empApproved.ApprovedBy) as ApprovedBy from ISMPayroll.dbo.EmpLeaveDates empDate inner join ISMPayroll.dbo.viewEmployeeLeaveDatesForApproved empApproved on empDate.LeaveTranId = empApproved.LeaveTranId where empDate.LeaveDate BETWEEN (Select ISMPayroll.dbo.CutOff_Period.CutOff_From from ISMPayroll.dbo.CutOff_Period where CutOffID='" + cutoffid + "') AND (Select ISMPayroll.dbo.CutOff_Period.CutOff_to from ISMPayroll.dbo.CutOff_Period where CutOffID='" + cutoffid + "') and empApproved.Status ='Approved' and empApproved.EmployeeNo='" + empNo + "' group by empApproved.LeaveTranId,empApproved.EmployeeNo, empApproved.EmpName, empApproved.LeaveType , empApproved.WholeOrPartial, empApproved.Status, empApproved.DateApproved, empApproved.Remarks, empApproved.ApprovedBy,empApproved.ApplicationDate";

SqlDataAdapter da = new SqlDataAdapter(sql, con);

DataTable dt = new DataTable();

da.Fill(dt);

gv2LeaveDetails.DataSource = dt;

gv2LeaveDetails.DataBind();

}

}

protected void gv2RowBound_GetAddLeaveDetails(object sender, GridViewRowEventArgs e)

{

int cutoffid = getCutOffID(cboCutOffSelect.SelectedValue);

if (e.Row.RowType == DataControlRowType.DataRow)

{

GridView gv2LeaveDetails = EmpLeaveAppGV2.FindControl("gv2LeaveDetails") as GridView; //find gv2LeaveDetails

string LeaveTranId = gv2LeaveDetails.DataKeys[e.Row.RowIndex].Value.ToString(); //getEmpNo DataKey based on DataKeyName from the found control (gvLeaveDetails)  -----------------IM Getting the error here

GridView gv2LeaveDetails2 = e.Row.FindControl("gv2LeaveDetails2") as GridView; //find gvLeaveDetails2 (for remarks and approved by)

using (SqlConnection con = new SqlConnection(DAO.ConnectionString))

{

con.Open();

string sql;

sql = "Select empApproved.LeaveTranId, empApproved.EmployeeNo, empApproved.eName, empApproved.LeaveType,empApproved.ApplicationDate ,MIN(empDate.LeaveDate) as LeaveDateFrom, MAX(empDate.LeaveDate) as LeaveDateTo, empApproved.WholeOrPartial, empApproved.Status, empApproved.DateApproved, empApproved.Remarks,(Select (empInfo.LastName + ', ' + empInfo.FirstName) from dbo.EmpPersonalInfo empInfo where empInfo.UserName = empApproved.ApprovedBy) as ApprovedBy from ISMPayroll.dbo.EmpLeaveDates empDate inner join ISMPayroll.dbo.viewEmployeeLeaveDatesForApproved empApproved on empDate.LeaveTranId = empApproved.LeaveTranId where empDate.LeaveDate BETWEEN (Select ISMPayroll.dbo.CutOff_Period.CutOff_From from ISMPayroll.dbo.CutOff_Period where CutOffID='" + cutoffid + "') AND (Select ISMPayroll.dbo.CutOff_Period.CutOff_to from ISMPayroll.dbo.CutOff_Period where CutOffID='" + cutoffid + "') and empApproved.Status ='Approved' and empApproved.LeaveTranId='" + LeaveTranId + "' group by empApproved.LeaveTranId,empApproved.EmployeeNo, empApproved.eName, empApproved.LeaveType , empApproved.WholeOrPartial, empApproved.Status, empApproved.DateApproved, empApproved.Remarks, empApproved.ApprovedBy,empApproved.ApplicationDate";

//sql = "Select LeaveTranId, Remarks, (Select (empInfo.LastName + ', ' + empInfo.FirstName) from dbo.EmpPersonalInfo empInfo where empInfo.UserName = empApproved.ApprovedBy) as ApprovedBy from ISMPayroll.dbo.viewEmployeeLeaveDatesForApproved empApproved where empApproved.LeaveTranId = '" + LeaveTranId + "'";

SqlDataAdapter da = new SqlDataAdapter(sql, con);

DataTable dt = new DataTable();

da.Fill(dt);

gv2LeaveDetails2.DataSource = dt;

gv2LeaveDetails2.DataBind();

}

}