private void BindGVCustomer() { string SelQuery = "SELECT * FROM View_CustomerDetails"; DataSet DSRecord = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.Text, SelQuery); if (DSRecord.Tables[0].Rows.Count > 0) { GVCustomer.DataSource = DSRecord.Tables[0]; GVCustomer.DataBind(); } else { GVCustomer.EmptyDataText = "No Record Found !"; GVCustomer.DataBind(); } foreach (GridViewRow Row in GVCustomer.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_CustomerDetails WHERE View_CustomerDetails.CustomerName LIKE '" + TBSearchText.Text.Trim() + "%'"; DataSet DSRecord = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.Text, SearchQuery); if (DSRecord.Tables[0].Rows.Count > 0) { GVCustomer.DataSource = DSRecord.Tables[0]; GVCustomer.DataBind(); } else { GVCustomer.EmptyDataText = "No Record Found !"; GVCustomer.DataBind(); } foreach (GridViewRow Row in GVCustomer.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 RebindGrid(object sender, EventArgs e) { try { DataSet ds = new DataSet(); ds = GetPrdLst(GVCustomer.CurrentPageIndex, hdnFilterText.Value); GVCustomer.DataSource = ds; GVCustomer.DataBind(); } catch (System.Exception ex) { Login.Profile.ErrorHandling(ex, this, "SearchrateCardAcc.aspx.cs", "RebindGrid"); } }
protected void GVCustomer_PageIndexChanging(object sender, GridViewPageEventArgs e) { GVCustomer.PageIndex = e.NewPageIndex; BindGVCustomer(); GVCustomer.DataBind(); }