예제 #1
0
        private void buttonEdit_Click(object sender, EventArgs e)
        {
            String idGrada = "nepoznato";
            String imeGrada = "nepoznato";
            if (comboBoxGradovi.SelectedIndex == -1)
            {
                if (dataGridView1.SelectedCells.Count > 0)
                {
                    int selectedrowindex = dataGridView1.SelectedCells[0].RowIndex;
                    DataGridViewRow selectedRow = dataGridView1.Rows[selectedrowindex];
                    idGrada = Convert.ToString(selectedRow.Cells[0].Value);
                    imeGrada = Convert.ToString(selectedRow.Cells[1].Value);

                    EditGrad editGrad = new EditGrad(this, sqlite, idGrada, imeGrada);
                    editGrad.Show();
                }
            }
            else
            {
                SQLiteCommand nadjiIdGrada = sqlite.CreateCommand();
                nadjiIdGrada.CommandText = "select gradID from GRAD where imeGrada ='" + comboBoxGradovi.SelectedItem.ToString() + "';";
                SQLiteDataReader dr = nadjiIdGrada.ExecuteReader();
                dr.Read();
                //int broj = dr.GetInt32(0);
                idGrada = Convert.ToString(dr.GetInt32(0));
                imeGrada = comboBoxGradovi.SelectedItem.ToString();

                EditGrad editGrad = new EditGrad(this, sqlite, idGrada, imeGrada);
                editGrad.Show();
                populateDropDown();
            }
        }
예제 #2
0
        private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            String idGrada = "nepoznato";
            String imeGrada = "nepoznato";
            int selectedrowindex = dataGridView1.SelectedCells[0].RowIndex;
            DataGridViewRow selectedRow = dataGridView1.Rows[selectedrowindex];
            idGrada = Convert.ToString(selectedRow.Cells[0].Value);
            imeGrada = Convert.ToString(selectedRow.Cells[1].Value);

            EditGrad editGrad = new EditGrad(this, sqlite, idGrada, imeGrada);
            editGrad.Show();
            populateDropDown();
        }