private void txtSearch_TextChanged(object sender, EventArgs e) { if (sByTenSach == true) { string Tensach = txtSearch.Text; var query = db.SEARCH_TENSACH(Tensach); dgvInfo.DataSource = query.ToList(); //using (var db = new Model1()) //{ // var query = from d in db.SACHes // where d.TENSACH.Contains(txtSearch.Text) // select d; // dgvInfo.DataSource = query.ToList(); //} } else if (sByViTri == true) { string Vitri = txtSearch.Text; var query = db.SEARCH_VITRI(Vitri); //var query = from d in db.Book_Info // where d.VITRI.Contains(txtSearch.Text) // select d; dgvInfo.DataSource = query.ToList(); //using (var db = new Model1()) //{ // var query = from d in db.SACHes // where d.VITRI.Contains(txtSearch.Text) // select d; // dgvInfo.DataSource = query.ToList(); //} } //else if (sByMuon == true) //{ // try // { // using (var db = new Model1()) // { // int tmp = int.Parse(txtSearch.Text); // var query = from d in db.SACHes // where d.DANGDUOCMUON == tmp // select d; // dgvInfo.DataSource = query.ToList(); // } // } // catch // { } //} }