private void LoadData() { string sql = "select * from tb_lop"; DataTable mytable = KN.E_SQL(sql); dgv1.DataSource = mytable; }
private void tb_timkiem_TextChanged(object sender, EventArgs e) { string value = tb_timkiem.Text; if (!string.IsNullOrEmpty(value)) { string sql = "select * from tb_sinhvien where msv='" + tb_timkiem.Text + "'"; DataTable mytable = KN.E_SQL(sql); dgv.DataSource = mytable; } else { LoadData(); } }