public Product PopulateFromDataReader(SqlDataReader dr) { Product product = new Product(); product.ProductID = (int)dr["ProductID"]; product.ProductName = dr["ProductName"].ToString(); product.CategoryName = dr["CategoryName"].ToString(); product.Description = dr["Description"].ToString(); product.UnitPrice = (decimal)dr["UnitPrice"]; product.UnitsInStock = (short)dr["UnitsInStock"]; return product; }
public Product GetProductByProductID(int productID) { Product product = new Product(); using (SqlConnection cn = new SqlConnection(Settings.Settings.ConnectionString)) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "Select Products.ProductID, Products.productName, Categories.CategoryName, Categories.[Description], Products.UnitPrice, Products.UnitsInStock from Products inner join Categories on Products.CategoryID = Categories.CategoryID where @ProductID = Products.ProductID"; cmd.Connection = cn; cmd.Parameters.AddWithValue("@ProductID", productID); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { product = PopulateFromDataReader(dr); } } } return product; }