/* This function is use to bind all data of GetReferalSource() from database */ private void BindGrid() { StoreFront ObjStoreFront = new StoreFront(); DataSet ds = new DataSet(); DataTable dt = new DataTable(); DataView dv = new DataView(); ds = ObjStoreFront.GetReferalSource(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) { gdvReferalSource.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; } gdvReferalSource.DataSource = dv; gdvReferalSource.DataBind(); CheckAll(); check(); Utility.Setserial(gdvReferalSource, "srno"); divsearch.Visible = true; } else { divsearch.Visible = false; //lblNorec.Visible = true; btnDelete.Visible = false; btnNew.Visible = true; btnStatus.Visible = false; gdvReferalSource.Visible = false; ErrMessage("Sorry, No Referral Source 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; //lblMsg.Visible = true; ErrMessage("Sorry, No Referral Source found."); } } }