[es] - ponavljajuci unosi u combo boxu iz baze, zasto?

tomislav91

Član broj: 206601
Poruke: 316
*.dynamic.isp.telekom.rs.

+1 Profil

ponavljajuci unosi u combo boxu iz baze, zasto?

^{03.10.2014. u 19:36 - pre 116 meseci}

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();
        }

life is the one,take care of them!

http://hardware-software.serbianforum.info/

Odgovor na temu

AMD guy
Miroslav
.NET developer

Član broj: 128930
Poruke: 1007

Sajt: www.its.edu.rs

+38 Profil

Re: ponavljajuci unosi u combo boxu iz baze, zasto?

^{03.10.2014. u 19:44 - pre 116 meseci}

Pitao si i ovde, sta nije u redu?

http://i.imgur.com/V3feW.jpg
http://on.wsj.com/H9yjz6 -- India Graduates Millions, but Too Few Are Fit to Hire

Odgovor na temu

tomislav91

Član broj: 206601
Poruke: 316
*.dynamic.isp.telekom.rs.

+1 Profil

Re: ponavljajuci unosi u combo boxu iz baze, zasto?

^{03.10.2014. u 19:48 - pre 116 meseci}

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.

life is the one,take care of them!

http://hardware-software.serbianforum.info/

Odgovor na temu

AMD guy
Miroslav
.NET developer

Član broj: 128930
Poruke: 1007

Sajt: www.its.edu.rs

+38 Profil

Re: ponavljajuci unosi u combo boxu iz baze, zasto?

^{03.10.2014. u 20:54 - pre 116 meseci}

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

http://i.imgur.com/V3feW.jpg
http://on.wsj.com/H9yjz6 -- India Graduates Millions, but Too Few Are Fit to Hire

Odgovor na temu

tomislav91

Član broj: 206601
Poruke: 316
*.dynamic.isp.telekom.rs.

+1 Profil

Re: ponavljajuci unosi u combo boxu iz baze, zasto?

^{03.10.2014. u 21:10 - pre 116 meseci}

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

life is the one,take care of them!

http://hardware-software.serbianforum.info/

Odgovor na temu

tomislav91

Član broj: 206601
Poruke: 316
*.dynamic.isp.telekom.rs.

+1 Profil

Re: ponavljajuci unosi u combo boxu iz baze, zasto?

^{03.10.2014. u 21:42 - pre 116 meseci}

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();
        }

life is the one,take care of them!

http://hardware-software.serbianforum.info/

Odgovor na temu