private void BindGVEmployee(string QueryText) { DataSet DSRecord = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.Text, QueryText); if (DSRecord.Tables[0].Rows.Count > 0) { GVEmployee.DataSource = DSRecord.Tables[0]; GVEmployee.DataBind(); } else { GVEmployee.EmptyDataText = "No Record Found !"; GVEmployee.DataBind(); } foreach (GridViewRow Row in GVEmployee.Rows) { Label lblStatus = (Label)Row.FindControl("lblStatus"); LinkButton LBEdit = (LinkButton)Row.FindControl("LBEdit"); LinkButton LBDelete = (LinkButton)Row.FindControl("LBDelete"); if (lblStatus.Text == "Active") { lblStatus.CssClass = "label label-success"; LBEdit.Enabled = true; LBDelete.Enabled = true; } else { lblStatus.CssClass = "label label-danger"; LBEdit.Enabled = false; LBDelete.Enabled = false; } } }
protected void SearchEvent(object sender, EventArgs e) { string SearchQuery = "SELECT * FROM View_EmployeeDetails WHERE View_EmployeeDetails.EmployeeName LIKE '" + TBSearch.Text.Trim() + "%'"; DataSet DSRecord = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.Text, SearchQuery); if (DSRecord.Tables[0].Rows.Count > 0) { GVEmployee.DataSource = DSRecord.Tables[0]; GVEmployee.DataBind(); } else { GVEmployee.EmptyDataText = "No Record Found !"; GVEmployee.DataBind(); } foreach (GridViewRow Row in GVEmployee.Rows) { Label lblStatus = (Label)Row.FindControl("lblStatus"); LinkButton LBEdit = (LinkButton)Row.FindControl("LBEdit"); LinkButton LBDelete = (LinkButton)Row.FindControl("LBDelete"); if (lblStatus.Text == "Active") { lblStatus.CssClass = "label label-success"; LBEdit.Enabled = true; LBDelete.Enabled = true; } else { lblStatus.CssClass = "label label-danger"; LBEdit.Enabled = false; LBDelete.Enabled = false; } } }
// this method requests all employees from the getEmployees() method in the HWW.cs and displays them in a grdiview protected void fillEmployees() { // populates a gridview with all orders numbers Employees allEmployees = new Employees(); GVEmployee.DataSource = allEmployees.getEmployees(); GVEmployee.DataBind(); }// closes the fillorders
public void bindEmpData() { List <ParaList> para = new List <ParaList>() { new ParaList { Key = "@i_CompanyID", Value = CurrentUser.CompId } }; dsitem = crmclient.list(para, "Employee"); GVEmployee.DataSource = dsitem.Tables[0]; GVEmployee.DataBind(); }
void FillGridViewWithNativeSql() { List <Employee> lst_emp = new List <Employee>(); DataTable dtbl = new DataTable(); using (SqlConnection sqlCon = new SqlConnection(connectionString)) { sqlCon.Open(); SqlCommand sqlcmd = new SqlCommand("Select * from Employees", sqlCon); using (SqlDataReader reader = sqlcmd.ExecuteReader()) { while (reader.Read()) { lst_emp.Add(new Employee { id_emp = Convert.ToInt32(reader["id_emp"].ToString()), nom_emp = reader["nom_emp"].ToString(), prenom_emp = reader["prenom_emp"].ToString(), date_recrute_emp = Convert.ToDateTime(reader["date_recrute_emp"].ToString()), id_dep = Convert.ToInt32(reader["id_dep"].ToString()), Salaire_emp = Convert.ToDouble(reader["Salaire_emp "].ToString()) }); } } SqlDataAdapter sqlDa = new SqlDataAdapter("Select * from Employees", sqlCon); sqlDa.Fill(dtbl); } if (dtbl.Rows.Count > 0) { DropDownList dd = (DropDownList)GVEmployee.FooterRow.FindControl("dddeprt_footer"); BindDeprt(dd, PopulateDeprt()); GVEmployee.DataSource = dtbl; GVEmployee.DataBind(); } else { dtbl.Rows.Add(dtbl.NewRow()); GVEmployee.DataSource = dtbl; GVEmployee.DataBind(); GVEmployee.Rows[0].Cells.Clear(); GVEmployee.Rows[0].Cells.Add(new TableCell()); GVEmployee.Rows[0].Cells[0].ColumnSpan = dtbl.Columns.Count; GVEmployee.Rows[0].Cells[0].Text = "No data Found...!"; GVEmployee.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center; } }
void BindGrid() { using (MMR_CP22Entities1 context = new MMR_CP22Entities1()) { if (context.Users.Count() > 0) { GVEmployee.DataSource = (from em in context.Users.OrderBy(u => u.uID) select new { em.uID, em.uName, em.uPassword, em.uStatus, em.rID, em.CMP_CODE, em.uFULL_NAME, em.GRID_CODE } ).ToList(); GVEmployee.DataBind(); } else { GVEmployee.DataSource = null; GVEmployee.DataBind(); } } }
void FillGridViewWithEntityFramework() { var listDtoEmp = new List <DtoEmployee>(); var list_emp = contxt.Employees.OrderBy(x => x.id_emp).ToList(); foreach (var emp in list_emp) { listDtoEmp.Add(new DtoEmployee { id_emp = emp.id_emp, nom_emp = emp.nom_emp, prenom_emp = emp.prenom_emp, Salaire_emp = emp.Salaire_emp, id_dep = emp.id_dep, nom_dep = emp.Departement.nom_dep, date_recrute_emp = emp.date_recrute_emp, tele_emp = emp.tele_emp }); } DataTable dtbl = ToDataTable(listDtoEmp); if (dtbl.Rows.Count > 0) { GVEmployee.DataSource = dtbl; GVEmployee.DataBind(); DropDownList dd = GVEmployee.FooterRow.FindControl("dddeprt_footer") as DropDownList; BindDeprt(dd, PopulateDeprt()); } else { dtbl.Rows.Add(dtbl.NewRow()); GVEmployee.DataSource = dtbl; GVEmployee.DataBind(); GVEmployee.Rows[0].Cells.Clear(); GVEmployee.Rows[0].Cells.Add(new TableCell()); GVEmployee.Rows[0].Cells[0].ColumnSpan = dtbl.Columns.Count; GVEmployee.Rows[0].Cells[0].Text = "No data Found...!"; GVEmployee.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center; } }
protected void GVEmployee_PageIndexChanging(object sender, GridViewPageEventArgs e) { GVEmployee.PageIndex = e.NewPageIndex; BindGVEmployees(); GVEmployee.DataBind(); }