private void radioButton1_CheckedChanged(object sender, EventArgs e)
{
button1.Enabled = true;
button2.Enabled=false;
textBox1.Enabled=true;
textBox2.Enabled = true;
textBox3.Enabled = true;
textBox5.Enabled = true;
comboBox1.Enabled = true;
List<string> kategorije = new List<string>();
string drl = "Select Naziv From Kategorija ORDER BY Naziv";
OleDbCommand komanda = new OleDbCommand(drl, con);
con.Open();
OleDbDataReader reader = komanda.ExecuteReader();
while (reader.Read())
{
kategorije.Add(reader.GetValue(0).ToString());
}
comboBox1.DataSource = kategorije;
con.Close();
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=B13B14.accdb");
if (textBox1.Text != "")
{
string select = "Select MAX(KnjigaID) From Knjiga";
int br = 0;
OleDbCommand c = new OleDbCommand(select, con);
con.Open();
OleDbDataReader dr = c.ExecuteReader();
while (dr.Read()) br = Convert.ToInt32(dr.GetValue(0));
if (Convert.ToInt32(textBox1.Text) > br)
{
textBox2.Clear();
textBox3.Clear();
textBox5.Clear();
comboBox1.SelectedIndex = 0;
}
string upit = "Select Knjiga.Naziv, BrojStrana, Kategorija.Naziv, Komentar From Knjiga, Kategorija Where Knjiga.KategorijaID=Kategorija.KategorijaID And KnjigaID=@KnjigaID";
OleDbCommand cmd = new OleDbCommand(upit, con);
cmd.Parameters.AddWithValue("KnjigaID", Convert.ToInt32(textBox1.Text));
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
textBox2.Text = reader["Knjiga.Naziv"].ToString();
textBox3.Text = reader["BrojStrana"].ToString();
textBox5.Text = reader["Komentar"].ToString();
comboBox1.SelectedItem = reader["Kategorija.Naziv"].ToString();
}
con.Close();
}
else if (textBox1.Text == "")
{
textBox2.Clear();
textBox3.Clear();
textBox5.Clear();
comboBox1.SelectedIndex = 0;
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text != "" & textBox2.Text != "" & textBox3.Text != "" & textBox5.Text != "")
{
if (Convert.ToInt32(textBox3.Text) > 0)
{
string nadjiKategoriju = "Select KategorijaID From Kategorija Where Naziv=@Naziv";
OleDbCommand kat = new OleDbCommand(nadjiKategoriju, con);
kat.Parameters.AddWithValue("Naziv", comboBox1.SelectedValue.ToString());
con.Open();
OleDbDataReader dr = kat.ExecuteReader();
dr.Read();
int idkat = (int)dr.GetValue(0);
string upit = "Insert Into Knjiga Values(@KnjigaID, @Naziv,@BrojStrana, @KategorijaID, @Komentar)";
OleDbCommand cmd = new OleDbCommand(upit, con);
cmd.Parameters.AddWithValue("KnjigaID", textBox1.Text);
cmd.Parameters.AddWithValue("Naziv", textBox2.Text);
cmd.Parameters.AddWithValue("BrojStrana", textBox3.Text);
cmd.Parameters.AddWithValue("KategorijaID", idkat);
cmd.Parameters.AddWithValue("Komentar", textBox5.Text);
try
{
cmd.ExecuteNonQuery();
MessageBox.Show("Knjiga je uneta u bazu!");
textBox1.Clear();
textBox2.Clear();
textBox3.Clear();
textBox5.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
}
}
}
private void Form2_Load(object sender, EventArgs e)
{
}
private void radioButton2_CheckedChanged(object sender, EventArgs e)
{
button1.Enabled = false;
textBox1.Enabled = true;
textBox2.Enabled = false;
textBox3.Enabled = false;
textBox5.Enabled = false;
comboBox1.Enabled = false;
button2.Enabled = true;
}
private void button2_Click(object sender, EventArgs e)
{
if (textBox1.Text != "")
{
string obrisi = "Delete From Knjiga Where KnjigaID=@KnjigaID";
OleDbCommand brisi = new OleDbCommand(obrisi, con);
brisi.Parameters.AddWithValue("KnjigaID", Convert.ToInt32(textBox1.Text));
try
{
con.Open();
brisi.ExecuteNonQuery();
MessageBox.Show("Knjiga " + textBox2.Text + " je izbrisana!");
textBox1.Clear();
textBox2.Clear();
textBox3.Clear();
textBox5.Clear();
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
}
Query:
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=B13B14.accdb");
private void Form3_Load(object sender, EventArgs e)
{
string drl = "Select Naziv From Kategorija ORDER BY Naziv";
OleDbCommand komanda = new OleDbCommand(drl, con);
con.Open();
OleDbDataReader reader = komanda.ExecuteReader();
while (reader.Read())
{
checkedListBox1.Items.Add(reader.GetString(0));
}
con.Close();
}
private void button2_Click(object sender, EventArgs e)
{
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
OleDbDataAdapter Da = new OleDbDataAdapter();
OleDbCommand cmd1 = new OleDbCommand();
cmd1.Connection = con;
cmd1.CommandText = string.Format("Select Kategorija.Naziv As Ime, Count(Knjiga.KategorijaID) As Broj From Kategorija, Knjiga Where Kategorija.KategorijaID=Knjiga.KategorijaID And Kategorija.Naziv='{0}' Group By Kategorija.Naziv",
checkedListBox1.CheckedItems[0].ToString());
Da.SelectCommand = cmd1;
DataTable dt1 = new DataTable();
Da.Fill(dt1);
OleDbCommand cmd2 = new OleDbCommand();
cmd2.Connection = con;
cmd2.CommandText = string.Format("Select Kategorija.Naziv As Ime, Count(Knjiga.KategorijaID) As Broj From Kategorija, Knjiga Where Kategorija.KategorijaID=Knjiga.KategorijaID And Kategorija.Naziv='{0}' Group By Kategorija.Naziv",
checkedListBox1.CheckedItems[1].ToString());
DataTable dt2 = new DataTable();
Da.SelectCommand = cmd2;
Da.Fill(dt2);
OleDbCommand cmd3 = new OleDbCommand();
cmd3.Connection = con;
cmd3.CommandText = string.Format("Select Kategorija.Naziv As Ime, Count(Knjiga.KategorijaID) As Broj From Kategorija, Knjiga Where Kategorija.KategorijaID=Knjiga.KategorijaID And Kategorija.Naziv='{0}' Group By Kategorija.Naziv",
checkedListBox1.CheckedItems[2].ToString());
DataTable dt3 = new DataTable();
Da.SelectCommand = cmd3;
Da.Fill(dt3);
dt1.Merge(dt2);
dt1.Merge(dt3);
chart1.DataSource = dt1;
chart1.Series["Broj knjiga"].XValueMember = "Ime";
chart1.Series["Broj knjiga"].YValueMembers = "Broj";
chart1.ChartAreas[0].AxisX.LabelStyle.Angle = 90;
chart1.DataBind();
}
Коментари
Постави коментар