public static void OutputInformation(int Id) { NorthwindEntities nwe = new NorthwindEntities(); var customerOrdersDetail = nwe.CustOrdersDetail(myId); foreach (var ordersDetail in customerOrdersDetail) { Console.WriteLine(ordersDetail.ProductName); Console.WriteLine(ordersDetail.UnitPrice); Console.WriteLine(ordersDetail.Quantity); Console.WriteLine(ordersDetail.ExtendedPrice); Console.WriteLine(ordersDetail.Discount); Console.ReadLine(); } }
protected void ddlOrders_SelectedIndexChanged(object sender, EventArgs e) { NorthwindEntities nweNorthwind = new NorthwindEntities(); var strOrderDetails = nweNorthwind.CustOrdersDetail(Convert.ToInt32(ddlOrders.SelectedItem.Value)); this.dtvOrderDetails.DataSource = strOrderDetails.ToList(); this.dtvOrderDetails.DataBind(); if (dtvOrderDetails.Visible == false) { dtvOrderDetails.Visible = true; } if (ddlOrders.SelectedIndex != 0) { lblDetails.Text = "Order " + ddlOrders.SelectedItem.Text + ":"; } else { lblDetails.Text = ""; } }