public ProductMainPage_data MobileforShow(string select) { ProductMainPage_data ds = new ProductMainPage_data(); try { SqlConnection con = new SqlConnection(dataaccess.configsql.strcon); SqlDataAdapter da = new SqlDataAdapter(select, con); da.Fill(ds, ProductMainPage_data._table); con.Close(); } catch (Exception ex) { Console.Write(ex.ToString()); } return ds; }
//Product BestSell: public ProductMainPage_data ProductBestSellAll() { ProductMainPage_data ds = new ProductMainPage_data(); try { SqlConnection con = new SqlConnection(dataaccess.configsql.strcon); con.Open(); SqlCommand command = new SqlCommand("w_product_bestsell", con); command.CommandType = CommandType.StoredProcedure; sqlda.SelectCommand = command; sqlda.Fill(ds, ProductMainPage_data._table); con.Close(); } catch (Exception ex) { Console.Write(ex.ToString()); } return ds; }