private void button9_Click(object sender, EventArgs e)
{
string stname = "", dur = "";
AddStation w = new AddStation();
w.ShowDialog();
if (w.DialogResult == DialogResult.OK)
{
w.get_data(out stname, out dur);
try
{
mconnect.Open();
//генерация ключа
int k = KEY_GEN(@"SELECT skey FROM Metro");
cmd[0] = new MySqlCommand();
cmd[0].Connection = mconnect;
cmd[0].CommandText = @"INSERT INTO Metro(facility_m, Station, Duration, skey)
VALUES(
@id,
@stn,
@d,
@ke)";
cmd[0].Prepare();
cmd[0].Parameters.AddWithValue("@id", _id);
cmd[0].Parameters.AddWithValue("@stn", stname);
cmd[0].Parameters.AddWithValue("@d", dur);
cmd[0].Parameters.AddWithValue("@ke", k);
cmd[0].ExecuteNonQuery();
stm = "SELECT Station, Duration FROM Metro WHERE Metro.facility_m = @id";
cmd[0] = new MySqlCommand(stm);
cmd[0].Connection = mconnect;
cmd[0].Prepare();
cmd[0].Parameters.AddWithValue("@id", _id);
da[7] = new MySqlDataAdapter(cmd[0]);
ds[7].Clear();
da[7].Fill(ds[7], "Metro");
dataGridView8.DataSource = ds[7].Tables["Metro"];
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
if (mconnect != null)
{
mconnect.Close();
}
}
}
private void button9_Click(object sender, EventArgs e)
{
string stname = "", dur = "";
AddStation w = new AddStation();
w.ShowDialog();
if (w.DialogResult == DialogResult.OK)
{
w.get_data(out stname, out dur);
try
{
mconnect.Open();
//генерация ключа
int k = KEY_GEN(@"SELECT skey FROM Metro");
cmd[0] = new MySqlCommand();
cmd[0].Connection = mconnect;
cmd[0].CommandText = @"INSERT INTO Metro(facility_m, Station, Duration, skey)
VALUES(
@id,
@stn,
@d,
@ke)";
cmd[0].Prepare();
cmd[0].Parameters.AddWithValue("@id", _id);
cmd[0].Parameters.AddWithValue("@stn", stname);
cmd[0].Parameters.AddWithValue("@d", dur);
cmd[0].Parameters.AddWithValue("@ke", k);
cmd[0].ExecuteNonQuery();
stm = "SELECT Station, Duration FROM Metro WHERE Metro.facility_m = @id";
cmd[0] = new MySqlCommand(stm);
cmd[0].Connection = mconnect;
cmd[0].Prepare();
cmd[0].Parameters.AddWithValue("@id", _id);
da[7] = new MySqlDataAdapter(cmd[0]);
ds[7].Clear();
da[7].Fill(ds[7], "Metro");
dataGridView8.DataSource = ds[7].Tables["Metro"];
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
if (mconnect != null)
mconnect.Close();
}
}