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();
}
