private void BindGVZone() { SqlParameter[] arrParam = new SqlParameter[1]; arrParam[0] = new SqlParameter("@Action", "ZONE_SELECT_BY_VIEW"); DataSet ds = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.StoredProcedure, "SP_Bin_ZoneMaster_CRUD", arrParam); GVZone.DataSource = ds.Tables[0]; GVZone.DataBind(); foreach (GridViewRow Row in GVZone.Rows) { Label lblStatus = (Label)Row.FindControl("lblStatus"); LinkButton LBView = (LinkButton)Row.FindControl("LBView"); LinkButton LBEdit = (LinkButton)Row.FindControl("LBEdit"); LinkButton LBDelete = (LinkButton)Row.FindControl("LBDelete"); if (lblStatus.Text == "Active") { lblStatus.CssClass = "label label-success"; LBView.Enabled = true; LBEdit.Enabled = true; LBDelete.Enabled = true; } else { lblStatus.CssClass = "label label-danger"; LBView.Enabled = false; LBEdit.Enabled = false; LBDelete.Enabled = false; } } }
// Method for Paging in GridView Warehouse protected void GVZone_PageIndexChanging(object sender, GridViewPageEventArgs e) { GVZone.PageIndex = e.NewPageIndex; BindGVZone(); GVZone.DataBind(); }