// order history // this updates the food list gridview to show the food items that are part of the selected row in the order history protected void OnSelectedIndexChanged(Object sender, EventArgs e) { int orderID = Convert.ToInt32(OrderGridView.SelectedRow.Cells[0].Text); DataTable dt = new DataTable(); SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["OrderistaConnectionString"].ConnectionString); try { connection.Open(); SqlCommand cmd = new SqlCommand("SELECT MenuItemName, Quantity, Price, Subtotal FROM Order_Items WHERE OrderID = @orderID"); cmd.Parameters.AddWithValue("@orderID", orderID); cmd.Connection = connection; SqlDataAdapter sqlData = new SqlDataAdapter(cmd); //Populate the grid view sqlData.Fill(dt); if (dt.Rows.Count > 0) { OrderItemDetailsView.DataSource = dt; OrderItemDetailsView.DataBind(); } } catch (SqlException ex) { string msg = "Fetch Error: "; msg += ex.Message; throw new Exception(msg); } finally { connection.Close(); } } // OnSelectedIndexChanged
private void OrdersGridView_DoubleClick(object sender, EventArgs e) { Guid?selectedOrderId = GetGridViewCurrentRowId(); if (!selectedOrderId.HasValue) { return; } OrderItemDetailsView orderItemView = new OrderItemDetailsView(selectedOrderId.Value); DialogResult dialogResult = orderItemView.ShowDialog(); if (dialogResult == DialogResult.OK) { } }