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();
}
}