protected void TxtSearch_TextChanged(object sender, EventArgs e) { try { if (TxtSearch.Text != string.Empty) { DataView Dv = new DataView(DtSearch); Dv.RowFilter = "BNAME like '%" + TxtSearch.Text.Trim() + "%' OR PHONE_O like '%" + TxtSearch.Text.Trim() + "%' OR PHONE_M like '%" + TxtSearch.Text.Trim() + "%' OR CompanyName like '%" + TxtSearch.Text.Trim() + "%'"; GvPersonMaster.DataSource = Dv.ToTable(); GvPersonMaster.DataBind(); } else { GvPersonMaster.DataSource = DtSearch; GvPersonMaster.DataBind(); } } catch (Exception) { throw; } }
public void FillGrid(string CompCode) { try { // HfCompCode.Value = Session["COMP_CODE"].ToString(); DataTable Dt = new DataTable(); Dt = BROKER_MASLogicLayer.GetAllBROKERDetials(Convert.ToInt32(Session["USERCODE"].ToString()), Convert.ToInt32(Session["COMP_CODE"].ToString())); DataView Dv = new DataView(Dt); if (CompCode != string.Empty) { Dv.RowFilter = "COMP_CODE=" + Session["COMP_CODE"].ToString(); } GvPersonMaster.DataSource = Dv.ToTable(); GvPersonMaster.DataBind(); DtSearch = Dv.ToTable(); } catch (Exception) { throw; } }