Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private: System::Void search_btn_Click(System::Object^ sender, System::EventArgs^ e) {
- String^ constring=L"datasource=localhost;port=3306;username=root;password=12345";
- MySqlConnection^ conDataBase=gcnew MySqlConnection(constring);
- MySqlCommand^ cmdDataBase=gcnew MySqlCommand("select * from database.employeeinfo where idEmployeeInfo = '"+this->textBox5->Text+"';",conDataBase);
- MySqlDataReader^ myReader;
- try{
- conDataBase -> Open();
- myReader = cmdDataBase -> ExecuteReader();
- if(myReader -> Read()){
- String^ EidVal = myReader -> GetInt32("idEmployeeInfo").ToString();
- textBox1 -> Text = EidVal;
- String^ NameVal = myReader -> GetString("name");
- textBox2 -> Text = NameVal;
- String^ SurnameVal = myReader -> GetString("surname");
- textBox3 -> Text = SurnameVal;
- String^ AgeVal = myReader -> GetInt32("age").ToString();
- textBox4 -> Text = AgeVal;
- // array<unsigned char,1>^ imgg = (array<unsigned char,1>^) myReader["image"];
- // MemoryStream^ mstream = gcnew MemoryStream(imgg);
- // pictureBox1->Image = Image::FromStream(mstream);
- }
- }catch(Exception^ ex){
- MessageBox::Show(ex -> Message);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement