>> /// <summary> >> /// Delete menu item click event >> /// </summary> >> private void DeleteMenuItem_Click(object sender, EventArgs e) { >> >> int _rowNumber = this.grdSearch._RowNumber; >> if (this.tcOrders.SelectedIndex == 2 && _rowNumber >= 0) //Search Page >> { >> >> DialogResult dr = MessageBox.Show("Are you sure to delete this order?", "Delete Order", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1); >> if (dr == DialogResult.Yes) >> { >> try >> { >> //delete items >> Guid OrderPk = ((OrdersDataSet.OrdersRow)_dtOrderSearch.Rows[_rowNumber]).OrderPk; >> _itemBiz.DeleteItemsByOrderKey(OrderPk); >> //delete order >> // _OrderBiz.DeleteOrder(OrderPk); >> >> _dtOrderSearch.Rows[_rowNumber].Delete(); >> _dtOrderSearch.AcceptChanges(); >> UpdateOrdersTotals(_dtOrderSearch); >> } >> catch (Exception ex) >> { >> MessageBox.Show(ex.Message); >> } >> } >> } >>>>
/// Delete Order /// </summary> /// <param name="OrderKey"></param> /// <returns></returns> public int DeleteOrder(Guid OrderKey) { OrdersTableAdapter ta = new OrdersTableAdapter(); return ta.Delete(OrderKey); }Also, I would think that probably OrderBiz should take care of deleting Order and Items, but I'm not sure how should I program this now - I would have to add OrderItems DS to the reference in OrderBiz ?