public void FillGrid()
        {
            try
            {
                DataTable dt_ = new DataTable();
                dt_ = tbl_mjvManager.GetBRVList();

                GVScrhBrv.DataSource = dt_;
                GVScrhBrv.DataBind();

                ViewState["MBrv"] = dt_;
            }
            catch (Exception ex)
            {
                //throw;
                ScriptManager.RegisterStartupScript(this, this.GetType(), "isActive", "Alert();", true);
                lblalert.Text = ex.Message;
            }
        }
 protected void TBSrhBRV_TextChanged(object sender, EventArgs e)
 {
     try
     {
         FillGrid();
         DataTable _dt = (DataTable)ViewState["MBrv"];
         DataView  dv  = new DataView(_dt, "mjv_sono LIKE '%" + TBSrhBRV.Text.Trim().ToUpper() + "%'", "[mjv_sono] ASC", DataViewRowState.CurrentRows);
         DataTable dt_ = new DataTable();
         dt_ = dv.ToTable();
         GVScrhBrv.DataSource = dt_;
         GVScrhBrv.DataBind();
         ViewState["MBrv"] = dt_;
     }
     catch (Exception ex)
     {
         //   throw;
         ScriptManager.RegisterStartupScript(this, this.GetType(), "isActive", "Alert();", true);
         lblalert.Text = ex.Message;
     }
 }