コード例 #1
0
        private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            labalreset();
            Ajandek a        = (Ajandek)listBox1.SelectedItem;
            int     tboxbaid = a.Id;

            txbx_id.Text = Convert.ToString(tboxbaid);
            string tboxbanev = a.Nev;

            txtbx_nev.Text = tboxbanev;
            string tboxbauzlet = a.Uzlet;

            txtbx_uzlet.Text = tboxbauzlet;

            lbl_idreszlet.Text    += " " + tboxbaid;
            lbl_nevreszlet.Text   += " " + tboxbanev;
            lbl_uzletreszlet.Text += " " + tboxbauzlet;
        }
コード例 #2
0
        private void btn_insert_Click(object sender, EventArgs e)
        {
            int    id    = Convert.ToInt32(txbx_id.Text);
            string nev   = txtbx_nev.Text;
            string uzlet = txtbx_uzlet.Text;

            var insertComm = conn.CreateCommand();

            insertComm.CommandText = @"
                            INSERT INTO ajandek (nev,uzlet)
                            VALUES(@nev,@uzlet)
                        ";
            insertComm.Parameters.AddWithValue("@nev", nev);
            insertComm.Parameters.AddWithValue("@uzlet", uzlet);
            insertComm.ExecuteNonQuery();
            Ajandek ajandek = new Ajandek(id, nev, uzlet);

            listBox1.Items.Add(ajandek);
        }
コード例 #3
0
 private void btn_delete_Click(object sender, EventArgs e)
 {
     if (listBox1.SelectedIndex > -1)
     {
         Ajandek a          = (Ajandek)listBox1.SelectedItem;
         int     id         = a.Id;
         var     deleteComm = conn.CreateCommand();
         deleteComm.CommandText = @"
                     DELETE FROM ajandek
                     WHERE id=@id
                 ";
         deleteComm.Parameters.AddWithValue("@id", id);
         deleteComm.ExecuteNonQuery();
         listaupdate();
     }
     else
     {
         MessageBox.Show("Nincs adat kiválasztva!", "Hiba", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }
コード例 #4
0
        private void AdatBetoltes()
        {
            string sql  = @"
                SELECT id, nev, uzlet
                FROM ajandek
                ORDER BY nev
            ";
            var    comm = this.conn.CreateCommand();

            comm.CommandText = sql;
            using (var reader = comm.ExecuteReader())
            {
                while (reader.Read())
                {
                    int     id      = reader.GetInt32("id");
                    string  nev     = reader.GetString("nev");
                    string  uzlet   = reader.GetString("uzlet");
                    Ajandek ajandek = new Ajandek(id, nev, uzlet);
                    listBox1.Items.Add(ajandek);
                }
            }
        }
コード例 #5
0
 private void btn_update_Click(object sender, EventArgs e)
 {
     if (listBox1.SelectedIndex > -1)
     {
         Ajandek a          = (Ajandek)listBox1.SelectedItem;
         int     id         = a.Id;
         string  nev        = txtbx_nev.Text;
         string  uzlet      = txtbx_uzlet.Text;
         var     updateComm = conn.CreateCommand();
         updateComm.CommandText = @"
                     UPDATE ajandek SET nev=@nev, uzlet=@uzlet
                     WHERE id=@id
                 ";
         updateComm.Parameters.AddWithValue("@id", id);
         updateComm.Parameters.AddWithValue("@nev", nev);
         updateComm.Parameters.AddWithValue("@uzlet", uzlet);
         updateComm.ExecuteNonQuery();
         listaupdate();
     }
     else
     {
         MessageBox.Show("Nincs adat kiválasztva!", "Hiba", MessageBoxButtons.OK, MessageBoxIcon.Error);
     }
 }