OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=B1B2.accdb");
private void Form2_Load(object sender, EventArgs e)
{
List<string> pas = new List<string>();
string upit1 = "Select PasID, Ime From PAS";
OleDbCommand cmd1 = new OleDbCommand(upit1, con);
con.Open();
OleDbDataReader da1 = cmd1.ExecuteReader();
while (da1.Read())
pas.Add(da1.GetValue(0).ToString() + " - " + da1.GetString(1));
comboBox1.DataSource = pas;
List<string> izlozba = new List<string>();
string upit2 = "Select IzlozbaID, Mesto From IZLOZBA";
OleDbCommand cmd2 = new OleDbCommand(upit2, con);
OleDbDataReader dr2 = cmd2.ExecuteReader();
while (dr2.Read())
izlozba.Add(dr2.GetValue(0).ToString() + " - " + dr2.GetString(1));
comboBox2.DataSource = izlozba;
List<string> kategorija = new List<string>();
string upit3 = "Select KategorijaID, Naziv From KATEGORIJA";
OleDbCommand cmd3 = new OleDbCommand(upit3, con);
OleDbDataReader dr3 = cmd3.ExecuteReader();
while (dr3.Read())
kategorija.Add(dr3.GetValue(0).ToString() + " - " + dr3.GetString(1));
comboBox3.DataSource = kategorija;
con.Close();
}
private void radioButton1_CheckedChanged(object sender, EventArgs e)
{
button1.Enabled = true;
button2.Enabled = false;
comboBox1.Enabled = true;
comboBox2.Enabled = true;
comboBox3.Enabled = true;
}
private void button3_Click(object sender, EventArgs e)
{
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
int poz1 = comboBox1.SelectedItem.ToString().IndexOf(' ');
int pasid = Convert.ToInt32(comboBox1.SelectedItem.ToString().Substring(0, poz1));
int poz2 = comboBox2.SelectedItem.ToString().IndexOf(' ');
int izlozbaid = Convert.ToInt32(comboBox2.SelectedItem.ToString().Substring(0, poz2));
int poz3 = comboBox3.SelectedItem.ToString().IndexOf(' ');
int kategorijaid = Convert.ToInt32(comboBox3.SelectedItem.ToString().Substring(0, poz3));
string upisi = "Insert Into Rezultat (IzlozbaID, KategorijaID, PasID) Values(@IzlozbaID, @KategorijaID, @PasID)";
OleDbCommand cmd = new OleDbCommand(upisi, con);
cmd.Parameters.AddWithValue("IzlozbaID", izlozbaid);
cmd.Parameters.AddWithValue("KategorijaID", kategorijaid);
cmd.Parameters.AddWithValue("PasID", pasid);
try
{
con.Open();
if (Convert.ToInt32(cmd.ExecuteNonQuery()) == 1)
{
MessageBox.Show("Uspešno ste uneli novu prijavu psa!");
comboBox1.SelectedIndex = 0;
comboBox2.SelectedIndex = 0;
comboBox3.SelectedIndex = 0;
}
}
catch( Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
}
private void radioButton2_CheckedChanged(object sender, EventArgs e)
{
button2.Enabled = true;
button1.Enabled = false;
comboBox1.Enabled = true;
comboBox2.Enabled = false;
comboBox3.Enabled = false;
}
private void button2_Click(object sender, EventArgs e)
{
int poz1 = comboBox1.SelectedItem.ToString().IndexOf(' ');
int pasid = Convert.ToInt32(comboBox1.SelectedItem.ToString().Substring(0, poz1));
string delete = "Delete From Rezultat Where PasID=@PasID";
OleDbCommand cmd = new OleDbCommand(delete, con);
cmd.Parameters.AddWithValue("PasID", pasid);
try
{
con.Open();
if (Convert.ToInt32(cmd.ExecuteNonQuery()) > 0)
{
MessageBox.Show("Uspešno su izbrisane sve prijave i rezultati izabranog psa");
comboBox1.SelectedIndex = 0;
}
else MessageBox.Show("Izabrani pas do sada nije bio prijavljivan!");
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
}
Query:
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=B1B2.accdb");
private void Form3_Load(object sender, EventArgs e)
{
List<string> izlozba = new List<string>();
string select = "Select IzlozbaID, Mesto From IZLOZBA";
OleDbCommand cmd = new OleDbCommand(select, con);
con.Open();
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
izlozba.Add(reader.GetValue(0).ToString() + " - " + reader.GetString(1));
con.Close();
comboBox1.DataSource = izlozba;
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
label4.Visible = true;
label5.Visible = true;
int poz = comboBox1.SelectedItem.ToString().IndexOf(' ');
int id = Convert.ToInt32(comboBox1.SelectedItem.ToString().Substring(0, poz));
string ukupno = "Select Count(PasID) From REZULTAT Where IzlozbaID=@IzlozbaID";
int ukupni_br = 0;
OleDbCommand cmd1 = new OleDbCommand(ukupno, con);
cmd1.Parameters.AddWithValue("IzlozbaID", id);
con.Open();
OleDbDataReader dr1 = cmd1.ExecuteReader();
while (dr1.Read())
ukupni_br = (int)dr1.GetValue(0);
label4.Text = ukupni_br.ToString();
string ucestvovali = "Select Count(PasID) From REZULTAT Where IzlozbaID=@IzlozbaID And Rezultat Is Not Null";
int takmicilo_se = 0;
OleDbCommand cmd2 = new OleDbCommand(ucestvovali, con);
cmd2.Parameters.AddWithValue("IzlozbaID", id);
OleDbDataReader reader = cmd2.ExecuteReader();
while (reader.Read())
takmicilo_se = Convert.ToInt32(reader.GetValue(0));
label5.Text = takmicilo_se.ToString();
con.Close();
}
private void button1_Click(object sender, EventArgs e)
{
int poz = comboBox1.SelectedItem.ToString().IndexOf(' ');
int id = Convert.ToInt32(comboBox1.SelectedItem.ToString().Substring(0, poz));
string select = "Select KATEGORIJA.KategorijaID, KATEGORIJA.Naziv, Count(REZULTAT.PasID) AS [Broj pasa] From KATEGORIJA, REZULTAT Where REZULTAT.IzlozbaID=@REZULTAT.IzlozbaID And KATEGORIJA.KategorijaID=REZULTAT.KategorijaID And REZULTAT.Rezultat Is Not Null Group by KATEGORIJA.Naziv, KATEGORIJA.KategorijaID, REZULTAT.IzlozbaID";
OleDbCommand cmd = new OleDbCommand(select, con);
cmd.Parameters.AddWithValue("REZULTAT.IzlozbaID", id);
OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = cmd;
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
}
Коментари
Постави коментар