/* Use to bind all styles from database */ private void BindGrid() { StoreFront ObjStoreFront = new StoreFront(); DataSet ds = new DataSet(); DataTable dt = new DataTable(); DataView dv = new DataView(); ds = ObjStoreFront.GetStyle(Request.QueryString["SearchFor"].ToString(), Request.QueryString["SearchText"].ToString()); ddlSearch.SelectedValue = Request.QueryString["SearchFor"].ToString(); txtSearch.Text = Request.QueryString["SearchText"].ToString(); if (ds.Tables[0].Rows.Count > 0) { gdvStyle.Visible = true; btnDelete.Visible = true; btnStatus.Visible = true; //lblNorec.Visible = false; dt = ds.Tables[0]; dv = dt.DefaultView; if ((SortExpression != string.Empty) && (SortDirection != string.Empty)) { dv.Sort = SortExpression + " " + SortDirection; } gdvStyle.DataSource = dv; gdvStyle.DataBind(); CheckAll(); check(); Utility.Setserial(gdvStyle, "srno"); btnExport.Visible = true; btnImport.Visible = true; divsearch.Visible = true; } else { // lblNorec.Visible = true; divsearch.Visible = false; btnDelete.Visible = false; btnNew.Visible = true; btnStatus.Visible = false; gdvStyle.Visible = false; ErrMessage("Sorry no records found."); if ((Convert.ToInt32(ddlSearch.SelectedIndex) > 0) && (txtSearch.Text != "")) { txtSearch.Text = ""; ddlSearch.SelectedIndex = 0; lnkNorec.Visible = true; btnNew.Visible = false; // btnAdd.Visible = false; btnExport.Visible = false; btnImport.Visible = false; //divSelectPet.Visible = false; //lblMsg.Visible = true; ErrMessage("Sorry no records found."); } } }