public static DataTable select_TaiKhoan() { OleDbCommand cmd = new OleDbCommand("select_TaiKhoan"); cmd.CommandType = CommandType.StoredProcedure; return(SQlDatabase.GetData(cmd)); }
public static DataTable Thongtin_Quangcao() { OleDbCommand cmd = new OleDbCommand("selectall_quancao"); cmd.CommandType = CommandType.StoredProcedure; return(SQlDatabase.GetData(cmd)); }
public static DataTable Thongtin_Menu() { OleDbCommand cmd = new OleDbCommand("thongtin_menu"); cmd.CommandType = CommandType.StoredProcedure; return(SQlDatabase.GetData(cmd)); }
public static DataTable selectall_TheLoai() { OleDbCommand cmd = new OleDbCommand("selectall_theloai"); cmd.CommandType = CommandType.StoredProcedure; return(SQlDatabase.GetData(cmd)); }
public static DataTable selectall_tknguoidung() { OleDbCommand cmd = new OleDbCommand("selectall_tknguoidung"); cmd.CommandType = CommandType.StoredProcedure; return(SQlDatabase.GetData(cmd)); }
public static DataTable select_Tin_Home() { OleDbCommand cmd = new OleDbCommand("selecthome_chitiet"); cmd.CommandType = CommandType.StoredProcedure; return(SQlDatabase.GetData(cmd)); }
public static DataTable select_Tin_ID(String IDTin) { OleDbCommand cmd = new OleDbCommand("select_Tin_ID"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@IDTin", IDTin); return(SQlDatabase.GetData(cmd)); }
public static DataTable Thongtin_Tin_by_tukhoa(string tukhoa) { OleDbCommand cmd = new OleDbCommand("thongtin_tintuc_by_tukhoa"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@TuKhoa", tukhoa); return(SQlDatabase.GetData(cmd)); }
public static DataTable select_Tin_IDTL_ngaunhien() { OleDbCommand cmd = new OleDbCommand("selectngaunhien_tintuc"); cmd.CommandType = CommandType.StoredProcedure; return(SQlDatabase.GetData(cmd)); }
public static DataTable select_TaiKhoan_ID(String TenDangNhap) { OleDbCommand cmd = new OleDbCommand("select_TaiKhoan_ID"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@TenDangNhap", TenDangNhap); return(SQlDatabase.GetData(cmd)); }
public static DataTable ThongTinTL_ID(String IDTL) { OleDbCommand cmd = new OleDbCommand("selectid_TheLoai"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@IDTL", IDTL); return(SQlDatabase.GetData(cmd)); }
public static DataTable Thongtin_NguoiDung_by_MaTK(string MaTK) { OleDbCommand cmd = new OleDbCommand("Thongtin_NguoiDung_by_MaTK"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MaTK", MaTK); return(SQlDatabase.GetData(cmd)); }
public static DataTable Thongtin_Menu_by_MaMenuCha(String MaMenuCha) { OleDbCommand cmd = new OleDbCommand("thongtin_menu_by_mamenucha"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MaMenuCha", MaMenuCha); return(SQlDatabase.GetData(cmd)); }
public static DataTable ThongTinTL_MaTLCha(String MaTLCha) { OleDbCommand cmd = new OleDbCommand("select_MaTLCha_TheLoai"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@MaTLCha", MaTLCha); return(SQlDatabase.GetData(cmd)); }
public static DataTable Thongtin_Quangcao_by_nhomquangcaoid(string Ma) { OleDbCommand cmd = new OleDbCommand("select_quancao_manhomqc"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ManhomQC", Ma); return(SQlDatabase.GetData(cmd)); }
public static DataTable Thongtin_Nhomquangcao_by_vitriqc(string ViTriQC) { OleDbCommand cmd = new OleDbCommand("select_nhomqc_vitri"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ViTriQC", ViTriQC); return(SQlDatabase.GetData(cmd)); }
public static DataTable Thongtin_NguoiDung_by_email_matkhau(string Email, string MatKhau) { OleDbCommand cmd = new OleDbCommand("Thongtin_NguoiDung_by_email_matkhau"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Email", Email); cmd.Parameters.AddWithValue("@MatKhau", MatKhau); return(SQlDatabase.GetData(cmd)); }