private void Form4_Load(object sender, EventArgs e)
{
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=B5B6.accdb");
List<string> gradovi = new List<string>();
string select = "Select Grad From Grad Order By Grad";
OleDbCommand cmd = new OleDbCommand(select, con);
con.Open();
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
gradovi.Add(reader.GetString(0));
comboBox1.DataSource = gradovi;
con.Close();
}
private void button5_Click(object sender, EventArgs e)
{
this.Close();
}
private void button3_Click(object sender, EventArgs e)
{
textBox1.Focus();
textBox1.Clear();
textBox2.Clear();
textBox3.Clear();
textBox4.Clear();
textBox5.Clear();
}
private void button1_Click(object sender, EventArgs e)
{
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=B5B6.accdb");
int id = 0;
string upit = "Select Min(StadionID) From Stadion";
OleDbCommand c = new OleDbCommand(upit, con);
con.Open();
OleDbDataReader r = c.ExecuteReader();
while (r.Read()) id = Convert.ToInt32(r.GetValue(0));
string select = "Select Naziv, Adresa, Kapacitet, BrojUlaza, Grad From Stadion, Grad Where Stadion.GradID=Grad.GradID And StadionID=@StadionID";
OleDbCommand cmd = new OleDbCommand(select, con);
if (textBox1.Text == "")
{
cmd.Parameters.AddWithValue("StadionID", id);
textBox1.Text = Convert.ToString(id);
}
if (textBox1.Text != "" && Convert.ToInt32(textBox1.Text) > 2)
{
id = Convert.ToInt32(textBox1.Text) - 1;
cmd.Parameters.AddWithValue("StadionID", id);
textBox1.Text = Convert.ToString(id);
}
else
{
cmd.Parameters.AddWithValue("StadionID", id);
textBox1.Text = Convert.ToString(id);
}
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
textBox2.Text = reader.GetString(0);
textBox3.Text = reader.GetString(1);
textBox4.Text = reader.GetValue(2).ToString();
textBox5.Text = reader.GetValue(3).ToString();
comboBox1.SelectedItem = reader.GetString(4);
}
con.Close();
}
private void button2_Click(object sender, EventArgs e)
{
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=B5B6.accdb");
int id_stad = 0;
string upit = "Select Max(StadionID) From Stadion";
OleDbCommand cmd1 = new OleDbCommand(upit, con);
con.Open();
OleDbDataReader dr = cmd1.ExecuteReader();
while (dr.Read())
id_stad = Convert.ToInt32(dr.GetValue(0));
string select = "Select Naziv, Adresa, Kapacitet, BrojUlaza, Grad From Stadion, Grad Where Stadion.GradID=Grad.GradID And StadionID=@StadionID";
OleDbCommand cmd = new OleDbCommand(select, con);
int id = id_stad;
if (textBox1.Text == "")
{
cmd.Parameters.AddWithValue("StadionID", id_stad);
textBox1.Text = Convert.ToString(id_stad);
}
if(textBox1.Text!="" && Convert.ToInt32(textBox1.Text) < id_stad)
{
id = Convert.ToInt32(textBox1.Text) + 1;
cmd.Parameters.AddWithValue("StadionID", id);
textBox1.Text = Convert.ToString(id);
}
if(textBox1.Text!="" && id==id_stad)
{
cmd.Parameters.AddWithValue("StadionID", id_stad);
textBox1.Text = Convert.ToString(id_stad);
}
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
textBox2.Text = reader.GetString(0);
textBox3.Text = reader.GetString(1);
textBox4.Text = reader.GetValue(2).ToString();
textBox5.Text = reader.GetValue(3).ToString();
comboBox1.SelectedItem = reader.GetString(4);
}
con.Close();
}
private void button4_Click(object sender, EventArgs e)
{
if(textBox1.Text!="" && textBox2.Text!="" && textBox3.Text!="" && textBox4.Text!="" && textBox5.Text != "")
{
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=B5B6.accdb");
string id_grada = "Select GradID From Grad Where Grad=@Grad";
int id = 0;
OleDbCommand cmd1 = new OleDbCommand(id_grada, con);
cmd1.Parameters.AddWithValue("Grad", comboBox1.SelectedItem.ToString());
con.Open();
OleDbDataReader dr = cmd1.ExecuteReader();
while (dr.Read())
id = (int)dr.GetValue(0);
string unesi = "Insert Into Stadion Values(@StadionID, @Naziv, @Adresa, @Kapacitet, @BrojUlaza,@GradID)";
OleDbCommand cmd = new OleDbCommand(unesi, con);
cmd.Parameters.AddWithValue("StadionID", Convert.ToInt32(textBox1.Text));
cmd.Parameters.AddWithValue("Naziv", textBox2.Text);
cmd.Parameters.AddWithValue("Adresa", textBox3.Text);
cmd.Parameters.AddWithValue("Kapacitet", Convert.ToInt32(textBox4.Text));
cmd.Parameters.AddWithValue("BrojUlaza", Convert.ToInt32(textBox5.Text));
cmd.Parameters.AddWithValue("GradID", Convert.ToInt32(id));
try
{
if (Convert.ToInt32(cmd.ExecuteNonQuery()) == 1)
{
MessageBox.Show("Uspešno je unet novi stadion");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
}
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=B5B6.accdb");
if (textBox1.Text != "") {
int id_stad = 0;
string upit = "Select Max(StadionID) From Stadion";
OleDbCommand cmd1 = new OleDbCommand(upit, con);
con.Open();
OleDbDataReader dr = cmd1.ExecuteReader();
while (dr.Read())
id_stad = Convert.ToInt32(dr.GetValue(0));
if (Convert.ToInt32(textBox1.Text) > id_stad)
{
textBox2.Clear();
textBox3.Clear();
textBox4.Clear();
textBox5.Clear();
}
string select = "Select Naziv, Adresa, Kapacitet, BrojUlaza, Grad From Stadion, Grad Where StadionID=@StadionID And Grad.GradID=Stadion.GradID";
OleDbCommand cmd = new OleDbCommand(select, con);
cmd.Parameters.AddWithValue("StadionID", Convert.ToInt32(textBox1.Text));
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
textBox2.Text = reader.GetString(0);
textBox3.Text = reader.GetString(1);
textBox4.Text = reader.GetValue(2).ToString();
textBox5.Text = reader.GetValue(3).ToString();
comboBox1.SelectedItem = reader.GetString(4);
}
con.Close();
}
else if (textBox1.Text == "")
{
textBox2.Clear();
textBox3.Clear();
textBox4.Clear();
textBox5.Clear();
}
}
Query:
private void button1_Click(object sender, EventArgs e)
{
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=B5B6.accdb");
string select = "Select Stadion.Naziv AS [Stadion], Klub.NazivKluba AS [Klub], Klub.Sajt AS [Web sajt kluba], Stadion.Kapacitet, Stadion.BrojUlaza AS [Broj ulaza] From Stadion, Klub Where Klub.StadionID=Stadion.StadionID And Stadion.Kapacitet>"+Convert.ToInt32(textBox1.Text)+" Order By Stadion.Kapacitet, Stadion.BrojUlaza DESC";
OleDbCommand cmd = new OleDbCommand(select, con);
//cmd.Parameters.AddWithValue("Kapacitet",Convert.ToInt32(textBox1.Text));
OleDbDataAdapter da = new OleDbDataAdapter();
da.SelectCommand = cmd;
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
}
private void button2_Click(object sender, EventArgs e)
{
this.Close();
}
Коментари
Постави коментар