private void textBox1_TextChanged(object sender, EventArgs e)
{
try
{
if (textBox1.Text != "")
{
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=B13B14.accdb");
int br = 0;
string uzmi = "Select Max(AutorID) From Autor";
OleDbCommand cmd1 = new OleDbCommand(uzmi, con);
con.Open();
OleDbDataReader dr = cmd1.ExecuteReader();
while (dr.Read())
{
br = Convert.ToInt32( dr[0]);
}
if (Convert.ToInt32(textBox1.Text) > br)
{
textBox2.Clear();
textBox3.Clear();
dateTimePicker1.Value = DateTime.Now;
}
string select = "Select Ime, Prezime, DatumRodjenja From Autor Where AutorID=@AutorID";
OleDbCommand cmd = new OleDbCommand(select, con);
cmd.Parameters.AddWithValue("AutorID", Convert.ToInt32(textBox1.Text));
OleDbDataReader da = cmd.ExecuteReader();
while (da.Read())
{
textBox2.Text = da["Ime"].ToString();
textBox3.Text = da["Prezime"].ToString();
dateTimePicker1.Value = Convert.ToDateTime(da["DatumRodjenja"]);
}
con.Close();
}
else if (textBox1.Text == "")
{
textBox1.Clear();
textBox2.Clear();
textBox3.Clear();
dateTimePicker1.Value = DateTime.Now;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void radioButton1_CheckedChanged(object sender, EventArgs e)
{
textBox1.Enabled = true;
textBox2.Enabled = true;
textBox3.Enabled = true;
dateTimePicker1.Enabled = true;
button1.Enabled = true;
button2.Enabled = false;
button3.Enabled = true;
}
private void radioButton2_CheckedChanged(object sender, EventArgs e)
{
textBox1.Enabled = true;
textBox2.Enabled = false;
textBox3.Enabled = false;
dateTimePicker1.Enabled = false;
button1.Enabled = false;
button2.Enabled = true;
button3.Enabled = true;
}
private void button1_Click(object sender, EventArgs e)
{
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=B13B14.accdb");
string unos = "Insert Into Autor Values(@AutorID, @Ime, @Prezime, @GodinaRodjenja)";
OleDbCommand cmd = new OleDbCommand(unos, con);
cmd.Parameters.AddWithValue("AutorID", Convert.ToInt32(textBox1.Text));
cmd.Parameters.AddWithValue("Ime", textBox2.Text);
cmd.Parameters.AddWithValue("Prezime", textBox3.Text);
cmd.Parameters.AddWithValue("GodinaRodjenja", dateTimePicker1.Value);
try
{
con.Open();
if (Convert.ToInt32(cmd.ExecuteNonQuery()) == 1)
{
MessageBox.Show("Uspešno je unet novi autor!");
textBox1.Clear();
textBox2.Clear();
textBox3.Clear();
dateTimePicker1.Value = DateTime.Now;
}
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
}
private void button2_Click(object sender, EventArgs e)
{
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=B13B14.accdb");
string brisi = "Delete From Autor Where AutorID=@AutorID";
OleDbCommand cmd = new OleDbCommand(brisi, con);
cmd.Parameters.AddWithValue("AutorID", Convert.ToInt32(textBox1.Text));
try
{
con.Open();
if (Convert.ToInt32(cmd.ExecuteNonQuery()) == 1)
{
MessageBox.Show("Uspešno izbrisan autor!");
textBox1.Clear();
textBox2.Clear();
textBox3.Clear();
dateTimePicker1.Value = DateTime.Now;
}
}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 upit = "Select Ime, Prezime From Autor Order BY Ime, Prezime";
OleDbCommand cmd = new OleDbCommand(upit, con);
con.Open();
OleDbDataReader da = cmd.ExecuteReader();
while (da.Read())
{
string ime = da["Ime"].ToString() + " " + da["Prezime"].ToString();
checkedListBox1.Items.Add(ime);
}
con.Close();
}
private void button1_Click_1(object sender, EventArgs e)
{
OleDbDataAdapter Da = new OleDbDataAdapter();
OleDbCommand cmd1 = new OleDbCommand();
cmd1.Connection = con;
int poz1 = checkedListBox1.CheckedItems[0].ToString().IndexOf(' ');
string ime1 = checkedListBox1.CheckedItems[0].ToString().Substring(0, poz1);
string prezime1 = checkedListBox1.CheckedItems[0].ToString().Substring(poz1 + 1);
cmd1.CommandText = string.Format("Select Autor.Ime, Autor.Prezime, Count(Autor_Izdanje.AutorID) As Broj From Autor, Autor_Izdanje Where Autor.AutorID=Autor_Izdanje.AutorID And Autor.Ime='{0}' And Autor.Prezime='{1}' Group By Autor.Ime, Autor.Prezime",
ime1,
prezime1);
Da.SelectCommand = cmd1;
DataTable dt1 = new DataTable();
Da.Fill(dt1);
OleDbCommand cmd2 = new OleDbCommand();
cmd2.Connection = con;
int poz2 = checkedListBox1.CheckedItems[1].ToString().IndexOf(' ');
string ime2 = checkedListBox1.CheckedItems[1].ToString().Substring(0, poz2);
string prezime2 = checkedListBox1.CheckedItems[1].ToString().Substring(poz2 + 1);
cmd2.CommandText = string.Format("Select Autor.Ime, Autor.Prezime, Count(Autor_Izdanje.AutorID) As Broj From Autor, Autor_Izdanje Where Autor.AutorID=Autor_Izdanje.AutorID And Autor.Ime='{0}' And Autor.Prezime='{1}' Group By Autor.Ime, Autor.Prezime",
ime2,
prezime2);
DataTable dt2 = new DataTable();
Da.SelectCommand = cmd2;
Da.Fill(dt2);
OleDbCommand cmd3 = new OleDbCommand();
cmd3.Connection = con;
int poz3 = checkedListBox1.CheckedItems[2].ToString().IndexOf(' ');
string ime3 = checkedListBox1.CheckedItems[2].ToString().Substring(0, poz3);
string prezime3 = checkedListBox1.CheckedItems[2].ToString().Substring(poz3 + 1);
cmd3.CommandText = string.Format("Select Autor.Ime, Autor.Prezime, Count(Autor_Izdanje.AutorID) As Broj From Autor, Autor_Izdanje Where Autor.AutorID=Autor_Izdanje.AutorID And Autor.Ime='{0}' And Autor.Prezime='{1}' Group By Autor.Ime, Autor.Prezime",
ime3,
prezime3);
DataTable dt3 = new DataTable();
Da.SelectCommand = cmd3;
Da.Fill(dt3);
dt1.Merge(dt2);
dt1.Merge(dt3);
chart1.DataSource = dt1;
chart1.ChartAreas[0].AxisX.LabelStyle.Angle = -90;
chart1.Series["Broj knjiga"].XValueMember = "Ime";
chart1.Series["Broj knjiga"].YValueMembers = "Broj";
chart1.DataBind();
}
Коментари
Постави коментар