private void button3_Click(object sender, EventArgs e) { Form19 f = new Form19(); this.Hide(); f.ShowDialog(); Close(); }
private void button4_Click(object sender, EventArgs e) { int index, n; string SqlText = "UPDATE [Pasagir] SET "; string ID_Pasagir, Surname, Name, NomerTelefony, Pasport, TicketsID, ReysID; // перевірка, чи є взагалі записи в таблиці Source n = dataGridView1.Rows.Count; if (n == 1) { return; } Form19 f = new Form19(); // заповнити форму даними перед відкриттям index = dataGridView1.CurrentRow.Index; ID_Pasagir = dataGridView1[0, index].Value.ToString(); Surname = dataGridView1[0, index].Value.ToString(); Name = dataGridView1[1, index].Value.ToString(); NomerTelefony = dataGridView1[2, index].Value.ToString(); Pasport = dataGridView1[2, index].Value.ToString(); TicketsID = dataGridView1[2, index].Value.ToString(); ReysID = dataGridView1[2, index].Value.ToString(); f.textBox1.Text = Surname; f.textBox2.Text = Name; f.textBox3.Text = NomerTelefony; f.textBox4.Text = Pasport; f.textBox5.Text = TicketsID; f.textBox6.Text = ReysID; if (f.ShowDialog() == DialogResult.OK) { Surname = f.textBox1.Text; Name = f.textBox2.Text; NomerTelefony = f.textBox3.Text; Pasport = f.textBox4.Text; TicketsID = f.textBox5.Text; ReysID = f.textBox5.Text; SqlText += "Surname = \'" + Surname + "\', Name = '" + Name + "\', NomerTelefony = '" + NomerTelefony + "\', Pasport = '" + Pasport + "\', TicketsID = '" + TicketsID + "', ReysID = '" + ReysID + ""; SqlText += "WHERE [Reys].Reys_ID = " + ID_Pasagir; MyExecuteNonQuery(SqlText); Pasagir(); } }