private void cmbOrderID_SelectedIndexChanged(object sender, EventArgs e)//select ORDERID and dispaly all of info related to it { order1 = new Order(); List <OrderDetail> orderDetails = new List <OrderDetail>(); order1 = OrdersDB.GetOrder(Convert.ToInt32(cmbOrderID.Text));//get specific ORDER recorder and return it to order1 //need display method OrderDisplay(); //display order info orderDetails = OrderDetailsDB.GetRelativeDetails(order1.OrderID); //get related orderdetails info from TABLE order details dgvOrderDetail.DataSource = orderDetails; //set gridviewer datasource equals to orderdetails and display it if (orderDetails.Count > 0) //there are relative details { //call summary of total charges from order details in TABLE ORDER DETAILS txtTotalCharge.Text = OrderDetailsDB.GetTotalCharge(order1.OrderID).ToString("c"); } else { txtTotalCharge.Text = null; } }