public void FillEmployeeData() { try { int ServiceTypeID = Convert.ToInt32(drpServiceTypeFilter.SelectedValue); String EmployeeName = txtEmployeeFilter.Text.ToString(); Resident res = new Resident(); DataSet ds = res.GetEmployee(muser.currentResident.SocietyID, ServiceTypeID, EmployeeName); if (ds.Tables.Count > 0) { EmployeeGrid.DataSource = ds; EmployeeGrid.DataBind(); // btnEmpShwall.Visible = false; //String EmpTotalCountQuery = " select count(UserID) from dbo.ViewEmployee where SocietyID = " + muser.currentResident.SocietyID.ToString(); //lblTotalEmployees.Text = daAccess.GetSingleValue(EmpTotalCountQuery).ToString(); // lblTotalEmployees.Text = ds.Tables[0].Rows.Count.ToString(); if (ds.Tables[0].Rows.Count == 0) { // txtEmpNamesrch.Visible = false; // drpEmpServtFilter.Visible = false; } else { // txtEmpNamesrch.Visible = true; drpServiceTypeFilter.Visible = true; } } else { } //ClientScript.RegisterStartupScript(this.GetType(), "alert('')", "ShowEmployePopup();", true); } catch (Exception ex) { } }