C# (CSharp) DAL_Main.ExecuteQueryDataSet Examples

Example #1

File: BUS_Customer.cs Project: hoangtk0100/QLCH_TGDD

 public DataSet Get()
 {
     return(db.ExecuteQueryDataSet("SELECT * FROM Customer", CommandType.Text));
 }

Example #2

File: BUS_Event.cs Project: hoangtk0100/QLCH_TGDD

 public DataSet Get()
 {
     return(db.ExecuteQueryDataSet(sql0, CommandType.Text));
 }

Example #3

File: BUS_Bill.cs Project: hoangtk0100/QLCH_TGDD

 public DataSet Get_Import_Bill()
 {
     return(db.ExecuteQueryDataSet("usp_GetHoaDonNhap", CommandType.StoredProcedure));
 }

Example #4

File: BUS_Employee.cs Project: hoangtk0100/QLCH_TGDD

 public DataSet Get()
 {
     return(db.ExecuteQueryDataSet("usp_getNhanVien", CommandType.Text));
 }

Example #5

File: BUS_Product.cs Project: hoangtk0100/QLCH_TGDD

 public DataSet Get()
 {
     // return db.ExecuteQueryDataSet("SELECT * FROM Product", CommandType.Text);
     return(db.ExecuteQueryDataSet("usp_GetSanPham", CommandType.StoredProcedure));
 }