コード例 #1
0
        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);
        }
コード例 #2
0
        //Product prepare out:
        public ProductMainPage_data ProductPrepareoutlAll()
        {
            ProductMainPage_data ds = new ProductMainPage_data();

            try
            {
                SqlConnection con = new SqlConnection(dataaccess.configsql.strcon);
                con.Open();
                SqlCommand command = new SqlCommand("w_product_prepareout", 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);
        }