private void txtTimkiem_TextChanged(object sender, EventArgs e) { string sql = string.Format("SELECT * FROM tblNhanVien WHERE HoTen LIKE N'%{0}%'", txtTimkiem.Text); mydatabase db = new mydatabase(); gridViewHSNV.DataSource = db.getData(sql); }
private void txtTimkiem_TextChanged(object sender, EventArgs e) { string sql = string.Format("SELECT * FROM tblNhanVien WHERE HoTen LIKE N'%{0}%'", txtTimkiem.Text); mydatabase db = new mydatabase(); gridViewHSNV.DataSource = db.getData(sql); }