private: System::Void button3_Click(System::Object^  sender, System::EventArgs^  e) {
    kierunek->Items->Clear();
    linia->ClearSelected();
    przystanek->Items->Clear();
}
private: System::Void zaladuj_Click(System::Object^  sender, System::EventArgs^  e) {
    String^ constring = L"datasource = localhost; port = 3306; username = root; password = password";
    MySqlConnection^ conDataBase = gcnew MySqlConnection(constring);
    MySqlCommand^ cmdDataBase = gcnew MySqlCommand("SELECT * FROM rozkladjazdy.linia;", conDataBase);
    MySqlDataReader^ myReader;
    try {
        conDataBase->Open();
        myReader = cmdDataBase->ExecuteReader();
        while (myReader->Read()){
            linia->Items->Add(myReader->GetString("linia_numer"));
        }
    }
    catch (Exception^ ex) {
        MessageBox::Show(ex->Message);
    }
}
private: System::Void szukprzys_Click(System::Object^  sender, System::EventArgs^  e) {
    this->Hide();
    Przystanki^ pokaz = gcnew Przystanki();
    pokaz->ShowDialog();
    this->Show();
}
private: System::Void wyjdz_Click(System::Object^  sender, System::EventArgs^  e) {
    Application::Exit();
}
private: System::Void linia_SelectedIndexChanged(System::Object^  sender, System::EventArgs^  e) {
    int i = linia->SelectedIndex;
    kierunek->Items->Clear();
    String^ constring = L"datasource = localhost; port = 3306; username = root; password = password";
    MySqlConnection^ conDataBase = gcnew MySqlConnection(constring);
    MySqlCommand^ cmdDataBase = gcnew MySqlCommand("SELECT * FROM rozkladjazdy.kierunek where linia_id = '" + (i + 1) + "' ;", conDataBase);
    MySqlDataReader^ myReader;
    try {
        conDataBase->Open();
        myReader = cmdDataBase->ExecuteReader();
        while (myReader->Read()) {
            kierunek->Items->Add(myReader->GetString("kierunek"));
        }
    }
    catch (Exception^ ex) {
        MessageBox::Show(ex->Message);
    }
}
private: System::Void kierunek_SelectedIndexChanged_1(System::Object^  sender, System::EventArgs^  e) {
    int i = kierunek->SelectedIndex;
    int s = linia->SelectedIndex;
    przystanek->Items->Clear();
    String^ constring = L"datasource = localhost; port = 3306; username = root; password = password";
    MySqlConnection^ conDataBase = gcnew MySqlConnection(constring);
    MySqlCommand^ cmdDataBase = gcnew MySqlCommand("SELECT * FROM rozkladjazdy.przystanek where kierunek_id = '" + (i + 1) + "' and linia_numer = '" + (s + 1) + "' ;", conDataBase);
    MySqlDataReader^ myReader;
    try {
        conDataBase->Open();
        myReader = cmdDataBase->ExecuteReader();
        while (myReader->Read()) {
            przystanek->Items->Add(myReader->GetString("przystanek"));
        }
    }
    catch (Exception^ ex) {
        MessageBox::Show(ex->Message);
    }
}
private: System::Void przystanek_SelectedIndexChanged(System::Object^  sender, System::EventArgs^  e) {
    int i = kierunek->SelectedIndex;
    int s = linia->SelectedIndex;
    int t = przystanek->SelectedIndex;
    rozklad->Items->Clear();
    String^ constring = L"datasource = localhost; port = 3306; username = root; password = password";
    MySqlConnection^ conDataBase = gcnew MySqlConnection(constring);
    MySqlCommand^ cmdDataBase = gcnew MySqlCommand("SELECT * FROM rozkladjazdy.rozkladjazdy where przystanek_id = '" + (t + 1) + "' and kierunek_id = '" + (i + 1) + "' and linia_numer = '" + (s + 1) + "' ;", conDataBase);
    MySqlDataReader^ myReader;
    try {
        conDataBase->Open();
        myReader = cmdDataBase->ExecuteReader();
        while (myReader->Read()) {
            rozklad->Items->Add(myReader->GetString("godziny"));
        }
    }
    catch (Exception^ ex) {
        MessageBox::Show(ex->Message);
    }