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