public DataTable GetAllProductsDal() { string qry = "SELECT * FROM Product"; DbCon db = new DbCon(); DataTable dt; db.OpenCon(); dt = db.Search(qry); db.CloseCon(); return(dt); }
public DataTable GetProgram(Program p) { string qry = "SELECT * FROM Program"; DbCon db = new DbCon(); DataTable dt; db.OpenCon(); dt = db.Search(qry); db.CloseCon(); return(dt); }
public DataTable SearchProductDAL(Product product) { string qry = "SELECT * FROM Product WHERE Id='" + product.Id + "'"; DbCon db = new DbCon(); DataTable dt; db.OpenCon(); dt = db.Search(qry); db.CloseCon(); return(dt); }