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