ponavljajuci unosi u combo boxu iz baze, zasto?

[ tomislav91 @ 03.10.2014. 19:36 ] @

Evo koda, zasto ponavlja unose?

Code:

private void Form1_Load(object sender, EventArgs e)
        {
            try
            {

                connection.Open();
                OleDbCommand command=new OleDbCommand();
                command.Connection=connection;
                string query="select * from korisnici,dogadjaji";
                command.CommandText=query;

                OleDbDataReader reader=command.ExecuteReader();
                while(reader.Read())
                {
                    comboBox1.Items.Add(reader["korisnik"].ToString());
                    comboBox2.Items.Add(reader["dogadjaj"].ToString());

            }

            }
            catch(Exception ex)
            {
                MessageBox.Show("error" + ex);
            }

            connection.Close();
        }

[ AMD guy @ 03.10.2014. 19:44 ] @

Pitao si i ovde, sta nije u redu?

[ tomislav91 @ 03.10.2014. 19:48 ] @

pa svugde po malo, ne mogu da nadjem odgovor.
Ne razumem zasto ponavlja iz baze, probao sam i

Code:

SELECT korisnici.korisnik, dogadjaji.dogadjaj
FROM dogadjaji INNER JOIN korisnici ON dogadjaji.[dogadjaj] = korisnici.[korisnik];

tako bi trebalo da oznaci korisnik i dogadjaj iz te dve tabele, ali svejedno opet ne funkcionise, ovako mi ne izbaci nista.

[ AMD guy @ 03.10.2014. 20:54 ] @

Probaj prvo taj upit u bazi a onda u programu. Da vidis jel ti problem upit ili nesto drugo.

[ tomislav91 @ 03.10.2014. 21:10 ] @

duplira, probao sam u bazi..Ali ne razumem kako i zasto to radi

[ tomislav91 @ 03.10.2014. 21:42 ] @

reseno

Code:

private void Form1_Load(object sender, EventArgs e)
        {


                connection.Open();

                string query="SELECT korisnik from korisnici";
                string query2 = "select dogadjaj from dogadjaji";
                OleDbCommand command = new OleDbCommand(query, connection);
                command.Connection = connection;
                OleDbDataReader reader = command.ExecuteReader();




                while(reader.Read())
                {

                    comboBox1.Items.Add(reader["korisnik"].ToString());


            }
                command = new OleDbCommand(query2, connection);
                reader = command.ExecuteReader();
                while (reader.Read())
                {
                    comboBox2.Items.Add(reader["dogadjaj"].ToString());
                }



            connection.Close();
        }