Advertisement
Guest User

Untitled

a guest
Oct 31st, 2014
130
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C++ 1.47 KB | None | 0 0
  1. void BankDataCollector::BankDataCollect()
  2. {
  3.     OdbcConnection^ DataCollectConn = gcnew OdbcConnection();
  4.     DataCollectConn->ConnectionString = GlobalConnectString;
  5.     try
  6.     {
  7.         DataCollectConn->Open();
  8.     }
  9.     catch (...)
  10.     {
  11.         MessageBox::Show("Что-то пошло не так", "Ошибка", MessageBoxButtons::OK);
  12.     }
  13.  
  14.     List<String^>^ TempBankDataList = gcnew List<String^>;
  15.  
  16.     OdbcCommand^ DataCollectComm = gcnew OdbcCommand("select bname from BankRequisite");
  17.     DataCollectComm->Connection = DataCollectConn;
  18.  
  19.     OdbcDataReader^ BankDataReader = DataCollectComm->ExecuteReader();
  20.     while (BankDataReader->Read())
  21.     {
  22.         TempBankDataList->Add(BankDataReader->GetString(0));
  23.     }
  24.  
  25.     BankNameDataList = TempBankDataList;
  26.  
  27.     /*
  28.     DataCollectComm->CommandText = "select byear from BankRequisite";
  29.     BankDataReader = DataCollectComm->ExecuteReader();
  30.     while (BankDataReader->Read())
  31.     {
  32.         BankYearDataList->Add(BankDataReader->GetString(0));
  33.     }
  34.  
  35.     DataCollectComm->CommandText = "select baddres from BankRequisite";
  36.     BankDataReader = DataCollectComm->ExecuteReader();
  37.     while (BankDataReader->Read())
  38.     {
  39.         BankAddresDataList->Add(BankDataReader->GetString(0));
  40.     }
  41.  
  42.     DataCollectComm->CommandText = "select bcode from BankRequisite";
  43.     BankDataReader = DataCollectComm->ExecuteReader();
  44.     while (BankDataReader->Read())
  45.     {
  46.         BankCodeDataList->Add(BankDataReader->GetString(0));
  47.     }
  48.     */
  49.     BankDataReader->Close();
  50.     DataCollectComm->ExecuteNonQuery();
  51.  
  52.     DataCollectConn->Close();
  53.  
  54.    
  55. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement