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