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();
}
}
