private void Button5_Click(object sender, EventArgs e) { double sum = 0; listBox3.Items.Clear(); myConnection = new OleDbConnection(connectString); myConnection.Open(); string isvedimas = "SELECT Pavadinimas, Kaina, Apmokejimo_busena FROM Krepselis ORDER BY ID;"; OleDbCommand command = new OleDbCommand(isvedimas, myConnection); int m = 0; OleDbDataReader reader = command.ExecuteReader(); listBox3.Items.Clear(); while (reader.Read()) { listBox3.Items.Add(reader[0].ToString() + " " + reader[1].ToString() + " " + reader[2].ToString()); if (n == m) { K[m] = new Krep(); K[m].SetPav(reader[0].ToString()); K[m].SetKaina(Convert.ToDouble(reader[1])); K[m].SetBus(reader[2].ToString()); } sum = sum + K[m].GetKaina(); m++; } n = m; label1.Text = "Bendra suma: " + sum.ToString(); reader.Close(); myConnection.Close(); }
public Krepselis() { InitializeComponent(); myConnection = new OleDbConnection(connectString); myConnection.Open(); string isvedimas = "SELECT Pavadinimas, Kaina, Apmokejimo_busena FROM Krepselis ORDER BY ID;"; OleDbCommand command = new OleDbCommand(isvedimas, myConnection); OleDbDataReader reader = command.ExecuteReader(); n = 0; while (reader.Read()) { K[n] = new Krep(); K[n].SetPav(reader[0].ToString()); K[n].SetKaina(Convert.ToDouble(reader[1])); K[n].SetBus(reader[2].ToString()); sum = sum + K[n].GetKaina(); n++; } reader.Close(); myConnection.Close(); label1.Text = "Bendra suma: " + sum.ToString(); }