Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void cmdDodaj_Click(object sender, EventArgs e)
- {
- int temp = lsbSpisakScenarija.Items.Count;
- if (txtImeScenarijaUnos.Text != "")
- {
- if (lsbSpisakScenarija.Items.Contains(txtImeScenarijaUnos.Text) == false)
- {
- MySqlConnection conDatabase = new MySqlConnection("Data Source=localhost;" +
- "Persist Security Info=yes;" +
- "UserId=root; PWD=root;");
- MySqlCommand cmdDatabase;
- try
- {
- conDatabase.Open();
- cmdDatabase = new MySqlCommand("USE NOVAbazaROBOT1;", conDatabase);
- cmdDatabase.ExecuteNonQuery();
- cmdDatabase = new MySqlCommand("INSERT INTO NOVAbazaROBOT1_spisakSvihScenarija" +
- " (" +
- "Ime_Scenarija" +
- ")" +
- " values " +
- "('" +
- txtImeScenarijaUnos.Text +
- "')"
- + ";", conDatabase);
- cmdDatabase.ExecuteNonQuery();
- //Ovo dole je lose resenje ako ne zabranis unos u tabele!!!!!!!!!!!!!!!!!
- cmdDatabase = new MySqlCommand("INSERT INTO NOVAbazaROBOT1_definicijeScenarija" +
- " (" +
- "FK_Stanja" +
- ")" +
- " values " +
- "('" +
- glavnaforma.novaBaza_ChildFrm.dgvSpisakSvihStanja.SelectedRows[0].Cells["PK_Orig"].Value +
- "')"
- + ";", conDatabase); //glavnaforma.novaBaza_ChildFrm.dgvSpisakSvihStanja.SelectedCells[0]
- cmdDatabase.ExecuteNonQuery();
- //cmdDatabase = new MySqlCommand("UPDATE NOVAbazaROBOT1_definicijeScenarija" +
- //" SET " +
- //"FK_Spisak_Svih_Scenarija='" + +
- //" values " +
- //"('" +
- //glavnaforma.novaBaza_ChildFrm.dgvSpisakSvihStanja.SelectedRows[0].Cells["PK_Orig"].Value +
- //"')"
- //+ ";", conDatabase); //glavnaforma.novaBaza_ChildFrm.dgvSpisakSvihStanja.SelectedCells[0]
- //cmdDatabase.ExecuteNonQuery();
- //cmdDatabase = new MySqlCommand("INSERT INTO NOVAbazaROBOT1_definicijeScenarija" +
- //" (" +
- //"FK_Stanja" +
- //")" +
- //" SELECT PK_Orig.NOVAbazaROBOT1_TabelaStanja FROM NOVAbazaROBOT1_TabelaStanja WHERE " +
- //"('" +
- //glavnaforma.novaBaza_ChildFrm.dgvSpisakSvihStanja.SelectedRows[0].Cells["PK_Orig"].Value +
- //"')"
- //+ ";", conDatabase); //glavnaforma.novaBaza_ChildFrm.dgvSpisakSvihStanja.SelectedCells[0]
- //cmdDatabase.ExecuteNonQuery();
- //samo kao primer za where
- // cmdDatabase = new MySqlCommand("INSERT INTO bazaROBOT8_listaZeljenihPokreta (ImePokreta, Glava, PrviZglobLevi, DrugiZglobLevi, TreciZglobLevi, PrviZglobDesni, DrugiZglobDesni, TreciZglobDesni, Vreme)" +
- //"SELECT ImePokreta, Glava, PrviZglobLevi, DrugiZglobLevi, TreciZglobLevi, PrviZglobDesni, DrugiZglobDesni, TreciZglobDesni, Vreme " +
- //"FROM bazaROBOT8_definicijePokreta WHERE PK_Orig ='" + (dgvDefinicijePokreta.SelectedRows[i - 1].Index + 1) + "'" +
- // ";", conDatabase);
- // cmdDatabase.ExecuteNonQuery();
- }
- catch (Exception ex)
- {
- MessageBox.Show(ex.Message);
- }
- if (conDatabase.State == ConnectionState.Open)
- {
- conDatabase.Close();
- }
- }
- else
- {
- MessageBox.Show("Uneto ime scenarija vec postoju i listi.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
- }
- glavnaforma.novaBaza_ChildFrm.PopuniTabeleNOVEbaze();
- this.Hide();
- }
- else
- {
- MessageBox.Show("Morate uneti ime scenarija ili izabrati neki od postojecih u listboxu.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement