private void cart_Paint(object sender, PaintEventArgs e) { businesslayer bl = new businesslayer(); MySqlDataReader dr = bl.Select("all", "cart", "", ""); DataTable table = new DataTable(); if (dr != null) { table.Load(dr); if (table != null) { CartTable.DataSource = table; } } double Price = 0; foreach (DataGridViewRow row in CartTable.Rows) { if (!row.IsNewRow) { Price += Convert.ToDouble(row.Cells["ModSellPrice"].Value); } } TotalPrice.Text = Price.ToString() + " L.E."; foreach (DataGridViewRow row in CartTable.SelectedRows) { if (!row.IsNewRow) { bl.DeleteRow("cart", "MobileSerial", row.Cells["MobileSerial"].Value + ""); CartTable.Rows.Remove(row); MessageBox.Show("Delete Operation is Completed"); } } }
private void button1_Click(object sender, EventArgs e) { businesslayer bl = new businesslayer(); foreach (DataGridViewRow row in CartTable.SelectedRows) { if (!row.IsNewRow) { bl.DeleteRow("cart", "MobileSerial", row.Cells["MobileSerial"].Value + ""); CartTable.Rows.Remove(row); MessageBox.Show("Delete Operation is Completed"); } } double Price = 0; foreach (DataGridViewRow row in CartTable.Rows) { if (!row.IsNewRow) { Price += Convert.ToDouble(row.Cells["ModSellPrice"].Value); } } TotalPrice.Text = Price.ToString() + " L.E."; }