private void Button3_Click(object sender, EventArgs e)
{
myConnection = new OleDbConnection(connectString);
myConnection.Open();
string isvedimas = "SELECT Pavadinimas, Kiekis, Kaina, CPU, Videocard, Memory FROM Nesio ORDER BY ID;";
OleDbCommand command = new OleDbCommand(isvedimas, myConnection);
int m = 0;
OleDbDataReader reader = command.ExecuteReader();
listBox2.Items.Clear();
while (reader.Read())
{
listBox2.Items.Add(reader[0].ToString() + " " + reader[1].ToString() + " " + reader[2].ToString());
if (n == m)
{
N[m] = new Nesiojami();
N[m].SetPav(reader[0].ToString());
N[m].SetKiek(Convert.ToInt32(reader[1]));
N[m].SetKaina(Convert.ToDouble(reader[2]));
N[m].SetCPU(reader[3].ToString());
N[m].SetGPU(reader[4].ToString());
N[m].SetMem(Convert.ToDouble(reader[5]));
}
m++;
}
n = m;
reader.Close();
myConnection.Close();
}
public Admin()
{
InitializeComponent();
myConnection = new OleDbConnection(connectString2);
myConnection.Open();
string isvedimas = "SELECT Pavadinimas, Kiekis, Kaina, CPU, Videocard, Memory FROM Nesio ORDER BY ID;";
OleDbCommand command = new OleDbCommand(isvedimas, myConnection);
OleDbDataReader reader = command.ExecuteReader();
n = 0;
while (reader.Read())
{
N[n] = new Nesiojami();
N[n].SetPav(reader[0].ToString());
N[n].SetKiek(Convert.ToInt32(reader[1]));
N[n].SetKaina(Convert.ToDouble(reader[2]));
N[n].SetCPU(reader[3].ToString());
N[n].SetGPU(reader[4].ToString());
N[n].SetMem(Convert.ToDouble(reader[5]));
n++;
}
reader.Close();
myConnection.Close();
myConnection2 = new OleDbConnection(connectString);
myConnection2.Open();
string isvedimas2 = "SELECT Pavadinimas, Kiekis, Kaina, CPU, Videocard, Memory FROM Stacio ORDER BY ID;";
OleDbCommand command2 = new OleDbCommand(isvedimas2, myConnection2);
OleDbDataReader reader2 = command2.ExecuteReader();
m = 0;
while (reader2.Read())
{
S[m] = new Stacionarus();
S[m].SetPav(reader2[0].ToString());
S[m].SetKiek(Convert.ToInt32(reader2[1]));
S[m].SetKaina(Convert.ToDouble(reader2[2]));
S[m].SetCPU(reader2[3].ToString());
S[m].SetGPU(reader2[4].ToString());
S[m].SetMem(Convert.ToDouble(reader2[5]));
m++;
}
reader2.Close();
myConnection2.Close();
}
