public DataTable LayMaMH(string tenmh) { DBConnect provider = new DBConnect(); try { string strSql = "select MaMonHoc from MONHOC where TenMonHoc = N'" + tenmh + "'"; provider.Connect();; DataTable dt = provider.Select(CommandType.Text, strSql); return(dt); } catch (SqlException ex) { throw ex; } finally { provider.DisConnect(); } }
public DataTable ThemHSVaoLop(string TenLop) { DBConnect provider = new DBConnect(); try { string strSql = "EXEC dbo.ThemHSVaoLop '" + TenLop + "'"; provider.Connect(); DataTable dt = provider.Select(CommandType.Text, strSql); return(dt); } catch (SqlException ex) { throw ex; } finally { provider.DisConnect(); } }
public DataTable LayDSMonHoc() { DBConnect provider = new DBConnect(); try { string strSql = "select TenMonHoc from MONHOC"; provider.Connect();; DataTable dt = provider.Select(CommandType.Text, strSql); return(dt); } catch (SqlException ex) { throw ex; } finally { provider.DisConnect(); } }
public DataTable TIMHSBANGMA(string MaHocSinh) { DBConnect provider = new DBConnect(); try { string strSql = "EXEC dbo.TIMHSBANGMA '" + MaHocSinh + "'"; provider.Connect(); DataTable dt = provider.Select(CommandType.Text, strSql); return(dt); } catch (SqlException ex) { throw ex; } finally { provider.DisConnect(); } }
public DataTable LayTatCaBangDiem() { DBConnect provider = new DBConnect(); try { string strSql = "SELECT * FROM BANGDIEM"; provider.Connect();; DataTable dt = provider.Select(CommandType.Text, strSql); return(dt); } catch (SqlException ex) { throw ex; } finally { provider.DisConnect(); } }
public DataTable TIMKIEMTHEOHOTEN(string hoten) { DBConnect provider = new DBConnect(); try { string strSql = "SELECT HS.MaHocSinh, HS.HoTen, DSL.TenLop, HS.GioiTinh, HS.NgaySinh, HS.Email, HS.DiaChi FROM HOCSINH HS, KHOILOP KL, CHITIETDSLOP CTDSL, DANHSACHLOP DSL WHERE HS.MaHocSinh = CTDSL.MaHocSinh AND CTDSL.MaLop = DSL.MaLop AND DSL.MaKhoiLop = KL.MaKhoiLop and HS.HoTen like N'%" + hoten + "%'"; provider.Connect();; DataTable dt = provider.Select(CommandType.Text, strSql); return(dt); } catch (SqlException ex) { throw ex; } finally { provider.DisConnect(); } }
public DataTable ThamSo() { DBConnect provider = new DBConnect(); try { string strSql = "select * from THAMSO"; provider.Connect();; DataTable dt = provider.Select(CommandType.Text, strSql); return(dt); } catch (SqlException ex) { throw ex; } finally { provider.DisConnect(); } }
public DataTable TIMKIEMDSHS() { DBConnect provider = new DBConnect(); try { string strSql = "EXEC dbo.TIMKIEMDSHS"; provider.Connect();; DataTable dt = provider.Select(CommandType.Text, strSql); return(dt); } catch (SqlException ex) { throw ex; } finally { provider.DisConnect(); } }
public DataTable LayKhoiLop() { DBConnect provider = new DBConnect(); try { string strSql = "SELECT MaKhoiLop FROM KHOILOP"; provider.Connect();; DataTable dt = provider.Select(CommandType.Text, strSql); return(dt); } catch (SqlException ex) { throw ex; } finally { provider.DisConnect(); } }
public DataTable LayLopHoc(string makhoilop) { DBConnect provider = new DBConnect(); try { string strSql = "SELECT TenLop FROM DANHSACHLOP where MaKhoiLop = '" + makhoilop + "'"; provider.Connect();; DataTable dt = provider.Select(CommandType.Text, strSql); return(dt); } catch (SqlException ex) { throw ex; } finally { provider.DisConnect(); } }