private void SnackGrd_SelectionChanged(object sender, SelectionChangedEventArgs e) { TBikeDAL MyDAL = new TBikeDAL(); int index = SnackGrd.Items.IndexOf(SnackGrd.CurrentItem); DataTable SnackTable = MyDAL.ShowAllSnackTable(); if (index == -1) { index = 0; } else { string SnackID = Convert.ToString(SnackTable.Rows[index]["SnackID"]).Trim(); DataTable ResultTable = MyDAL.SelectSnackSalesBySnackID(SnackID); TBSnackID.Text = "Sales Details for: " + Convert.ToString(SnackTable.Rows[index]["SnackName"]).Trim(); SColumn1.Header = "Sales ID"; SColumn1.Binding = new Binding("SalesID"); SColumn2.Header = "Booking ID"; SColumn2.Binding = new Binding("BookingID"); SColumn3.Header = "Snack ID"; SColumn3.Binding = new Binding("SnackID"); SColumn4.Header = "Quantity"; SColumn4.Binding = new Binding("Quantity"); SColumn5.Header = "Customer"; SColumn5.Binding = new Binding("Customer"); SColumn6.Header = "Total Price"; SColumn6.Binding = new Binding("TotalPrice"); SColumn7.Header = "Created By"; SColumn7.Binding = new Binding("CreatedBy"); SColumn8.Header = "Created At"; SColumn8.Binding = new Binding("CreatedAt"); detailSnackGrd.ItemsSource = ResultTable.DefaultView; detailSnackGrd.AutoGenerateColumns = false; } }