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();
}
}
private void btnPrinter_Click(object sender, EventArgs e)
{
DSLop dSHS = new DSLop();
DataSet ds = new DataSet();
ds.Tables.Clear();
DataTable da = bd.DataSource as DataTable;
if (da != null)
{
ds.Tables.Add(da);
dSHS.DataSource = ds;
dSHS.DataMember = ds.Tables[0].TableName;
dSHS.ShowPreviewDialog();
}
}
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();
}
}
}
