Advertisement
Guest User

Untitled

a guest
May 25th, 2015
234
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.82 KB | None | 0 0
  1. void UpdateList()
  2. {
  3. listBox1->Items->Clear();
  4. oleDbConnection1->Open();
  5. System::Data::OleDb::OleDbCommand ^myCommand = gcnew OleDbCommand("SELECT lname FROM tab", oleDbConnection1);
  6. System::Data::OleDb::OleDbDataReader ^readerlname;
  7. System::Data::OleDb::OleDbDataReader ^readernumb;
  8. readerlname = myCommand->ExecuteReader();
  9. myCommand = gcnew OleDbCommand("SELECT znumber FROM tab", oleDbConnection1);
  10. readernumb = myCommand->ExecuteReader();
  11. while (readerlname->Read()&& readernumb->Read())
  12. {
  13. this->listBox1->Items->Add(readerlname->GetString(0)->ToString()+"("+readernumb->GetString(0)->ToString()+")");
  14. }
  15.  
  16. readerlname->Close();
  17. readernumb->Close();
  18. oleDbConnection1->Close();
  19. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement