예제 #1
0
        public static Product GetDataProductToExcel(OleDbDataReader reader)
        {
            Product pro = new Product();

            pro.ProductID       = MyConvert.ToInt32(reader["ProductID"]);
            pro.ProductName     = MyConvert.ToString(reader["ProductName"]);
            pro.SupplierID      = MyConvert.ToInt32(reader["SupplierID"]);
            pro.QuantityPerUnit = MyConvert.ToString(reader["ProductName"]);
            pro.UnitPrice       = MyConvert.ToDouble(reader["UnitPrice"]);
            pro.UnitsInStock    = MyConvert.ToInt16(reader["UnitsInStock"]);
            pro.UnitsOnOrder    = MyConvert.ToInt16(reader["UnitsOnOrder"]);
            pro.Discontinued    = MyConvert.ToBool(reader["Discontinued"]);
            return(pro);
        }