Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- void BankDataCollector::BankDataCollect()
- {
- OdbcConnection^ DataCollectConn = gcnew OdbcConnection();
- DataCollectConn->ConnectionString = GlobalConnectString;
- try
- {
- DataCollectConn->Open();
- }
- catch (...)
- {
- MessageBox::Show("Что-то пошло не так", "Ошибка", MessageBoxButtons::OK);
- }
- List<String^>^ TempBankDataList = gcnew List<String^>;
- OdbcCommand^ DataCollectComm = gcnew OdbcCommand("select bname from BankRequisite");
- DataCollectComm->Connection = DataCollectConn;
- OdbcDataReader^ BankDataReader = DataCollectComm->ExecuteReader();
- while (BankDataReader->Read())
- {
- TempBankDataList->Add(BankDataReader->GetString(0));
- }
- BankNameDataList = TempBankDataList;
- /*
- DataCollectComm->CommandText = "select byear from BankRequisite";
- BankDataReader = DataCollectComm->ExecuteReader();
- while (BankDataReader->Read())
- {
- BankYearDataList->Add(BankDataReader->GetString(0));
- }
- DataCollectComm->CommandText = "select baddres from BankRequisite";
- BankDataReader = DataCollectComm->ExecuteReader();
- while (BankDataReader->Read())
- {
- BankAddresDataList->Add(BankDataReader->GetString(0));
- }
- DataCollectComm->CommandText = "select bcode from BankRequisite";
- BankDataReader = DataCollectComm->ExecuteReader();
- while (BankDataReader->Read())
- {
- BankCodeDataList->Add(BankDataReader->GetString(0));
- }
- */
- BankDataReader->Close();
- DataCollectComm->ExecuteNonQuery();
- DataCollectConn->Close();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement