protected void LBSearch_Click(object sender, EventArgs e) { try { SqlParameter[] arrParam = new SqlParameter[2]; arrParam[0] = new SqlParameter("@Action", "SEARCH"); arrParam[1] = new SqlParameter("@SearchText", TBSearch.Text); DataSet DSUser = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.StoredProcedure, "SP_KitMaterial_CRUD", arrParam); if (DSUser.Tables[0].Rows.Count > 0) { GVKitMaterial.DataSource = DSUser.Tables[0]; GVKitMaterial.DataBind(); } else { GVKitMaterial.EmptyDataText = "No Record Found !"; GVKitMaterial.DataBind(); } foreach (GridViewRow Row in GVKitMaterial.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; } } } catch (Exception ex) { ShowMessage(ex.Message, MessageType.Error); } }
protected void GVKitMaterial_PageIndexChanging(object sender, GridViewPageEventArgs e) { GVKitMaterial.PageIndex = e.NewPageIndex; BindGVKitMaterial(); GVKitMaterial.DataBind(); }