void Load_data()
{
using (var conn = SQL.GetConnection())
{
//conn.Open();
SqlCommand sqlCmd = new SqlCommand("select MaSV,Hoten,NgaySinh,GioiTinh,QueQuan,SDT,Avata,TenLop,TenKhoa from SinhVien,Khoa,Lop where SinhVien.MaLop=Lop.MaLop and SinhVien.MaKhoa=Khoa.MaKhoa", conn);
DataSet dt = new DataSet();
SqlDataAdapter sqlAdap = new SqlDataAdapter(sqlCmd);
sqlAdap.Fill(dt);
DSLop.DataSource = dt;
DSLop.DataBind();
conn.Close();
}
}
protected void btnLoc_Click(object sender, EventArgs e)
{
if (cbLop.SelectedValue != "")
{
using (var conn = SQL.GetConnection())
{
SqlCommand sqlCmd = new SqlCommand("select MaSV,Hoten,NgaySinh,GioiTinh,QueQuan,SDT,Avata,TenLop from SinhVien,Lop where SinhVien.MaLop=Lop.MaLop and SinhVien.MaLop = '" + cbLop.SelectedValue + "'", conn);
DataSet dt = new DataSet();
SqlDataAdapter sqlAdap = new SqlDataAdapter(sqlCmd);
sqlAdap.Fill(dt);
DSLop.DataSource = dt;
DSLop.DataBind();
conn.Close();
}
}
}