protected void btnShow_Click(object sender, EventArgs e) { long sl = 0; DataTable dtEmp = objEmp.GetSearchEmployee(txtSearchValue.Text.Trim(), ddlProject.SelectedValue.ToString(), ddlCompany.SelectedValue.ToString(), ddlDept.SelectedValue.ToString(), ddlGrade.SelectedValue.ToString(), ddlDesig.SelectedValue.ToString(), txtSearchValue.Text.Trim(), txtSearchValue.Text.Trim(), txtSearchValue.Text.Trim(), ddlSearchBy.SelectedValue.ToString(), Session["USERID"].ToString(), ddlEmploymentType.SelectedValue.ToString(), ddlEmpStatus.SelectedValue.ToString().Trim()); grEmployee.DataSource = dtEmp; grEmployee.DataBind(); dtEmp.Rows.Clear(); dtEmp.Dispose(); lblRecordCount.Text = grEmployee.Rows.Count.ToString(); foreach (GridViewRow gRow in grEmployee.Rows) { sl = sl + 1; gRow.Cells[0].Text = sl.ToString(); gRow.Cells[8].Text = Common.DisplayDate(gRow.Cells[8].Text); for (int i = 0; i < grEmployee.Columns.Count; i++) { if (Common.CheckNullString(gRow.Cells[i].Text) == "") { gRow.Cells[i].BackColor = System.Drawing.Color.LightGreen; } } } }