Advertisement
Guest User

Untitled

a guest
Dec 12th, 2016
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C++ 1.22 KB | None | 0 0
  1. private: System::Void search_btn_Click(System::Object^  sender, System::EventArgs^  e) {
  2.              String^ constring=L"datasource=localhost;port=3306;username=root;password=12345";
  3.              MySqlConnection^ conDataBase=gcnew MySqlConnection(constring);
  4.              MySqlCommand^ cmdDataBase=gcnew MySqlCommand("select * from database.employeeinfo where idEmployeeInfo = '"+this->textBox5->Text+"';",conDataBase);
  5.              MySqlDataReader^ myReader;
  6.              try{
  7.                  conDataBase -> Open();
  8.                  myReader = cmdDataBase -> ExecuteReader();
  9.                
  10.                  if(myReader -> Read()){
  11.                      String^ EidVal = myReader -> GetInt32("idEmployeeInfo").ToString();
  12.                      textBox1 -> Text = EidVal;
  13.                      String^ NameVal = myReader -> GetString("name");
  14.                      textBox2 -> Text = NameVal;
  15.                      String^ SurnameVal = myReader -> GetString("surname");
  16.                      textBox3 -> Text = SurnameVal;
  17.                      String^ AgeVal = myReader -> GetInt32("age").ToString();
  18.                      textBox4 -> Text = AgeVal;
  19.                      
  20.                     // array<unsigned char,1>^ imgg = (array<unsigned char,1>^) myReader["image"];
  21.                     // MemoryStream^ mstream = gcnew MemoryStream(imgg);
  22.                     // pictureBox1->Image = Image::FromStream(mstream);
  23.                  }
  24.              }catch(Exception^ ex){
  25.                  MessageBox::Show(ex -> Message);
  26.              }
  27.          }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement