objApprisals.MonthName = ddlMonths.SelectedValue;
DataTable dtAppraisal = objApprisals.getApprsailDetailsMonthWise();
DataTable dtAppraisal2;
dtAppraisal.Columns.Add("OnHoldRemarks");
string empid = "";
DataRow[] dRow1 = dtAppraisal.Select("EMPID'0'");
for (int i = 0; i {
empid = "'" + dRow1[i]["empid"].ToString() + "'";
dtAppraisal2 = objSqlHelper.SelectQuery(" SELECT * FROM AppraisalFeedBack WHERE empid=" + empid + "");
DataRow[] dRow2 = dtAppraisal2.Select("OnHoldRemarks'0'");
if (dtAppraisal2.Rows.Count > 0)
{
for (int i1 = 0; i1 {
if (dtAppraisal.Rows[i]["empid"].ToString().Equals(dtAppraisal2.Rows[i1]["empid"].ToString()))
{
dtAppraisal.Rows[i]["OnHoldRemarks"] = dtAppraisal2.Rows[0]["OnHoldRemarks"];
break;
}
else
{
if (dtAppraisal.Rows[i]["OnHoldRemarks"].ToString() == " ")
{
dtAppraisal.Rows[i]["OnHoldRemarks"] = " ";
}
}
}
}
}
ObjMy.FillGridview1(dtAppraisal, ref GridViewApprisal);
if (dtAppraisal.Rows.Count == 0)
{
GridViewApprisal.DataSource = null;
GridViewApprisal.DataBind();
}
DataTable dtAppraisal = objApprisals.getApprsailDetailsMonthWise();
DataTable dtAppraisal2;
dtAppraisal.Columns.Add("OnHoldRemarks");
string empid = "";
DataRow[] dRow1 = dtAppraisal.Select("EMPID'0'");
for (int i = 0; i {
empid = "'" + dRow1[i]["empid"].ToString() + "'";
dtAppraisal2 = objSqlHelper.SelectQuery(" SELECT * FROM AppraisalFeedBack WHERE empid=" + empid + "");
DataRow[] dRow2 = dtAppraisal2.Select("OnHoldRemarks'0'");
if (dtAppraisal2.Rows.Count > 0)
{
for (int i1 = 0; i1 {
if (dtAppraisal.Rows[i]["empid"].ToString().Equals(dtAppraisal2.Rows[i1]["empid"].ToString()))
{
dtAppraisal.Rows[i]["OnHoldRemarks"] = dtAppraisal2.Rows[0]["OnHoldRemarks"];
break;
}
else
{
if (dtAppraisal.Rows[i]["OnHoldRemarks"].ToString() == " ")
{
dtAppraisal.Rows[i]["OnHoldRemarks"] = " ";
}
}
}
}
}
ObjMy.FillGridview1(dtAppraisal, ref GridViewApprisal);
if (dtAppraisal.Rows.Count == 0)
{
GridViewApprisal.DataSource = null;
GridViewApprisal.DataBind();
}