public void loadSoldItems() { try { dataGridView1.Rows.Clear(); int i = 0; double totalSold = 0; using (MySqlDataReader reader = pos.loadSoldItems(dateTimePicker4.Value.ToString("yyyy-MM-dd"), dateTimePicker3.Value.ToString("yyyy-MM-dd"))) { while (reader.Read()) { i++; totalSold += Convert.ToDouble(reader["total"].ToString()); dataGridView1.Rows.Add(i, reader["products_id"].ToString(), reader["description"].ToString(), Double.Parse(reader["price"].ToString()).ToString("#,##0.00"), reader["qty"].ToString(), reader["disc"].ToString(), Double.Parse(reader["total"].ToString()).ToString("#,##0.00")); } } total.Text = totalSold.ToString("#,##0.00"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }