How to execute a query and check the results?

How to execute a query and check the results?

Postby tsvetanakos » Thu 26 Jan 2012 21:52

Hello! I'm really new in visual c++ and newer in dbforge.I have a question and hope that someone will answer it.I started a database application,but my problem is that I can't execute and see the query results.As I can see visual c++ have created 2 codes:
Code: Select all
// mySqlCommand1
         //
         this->mySqlCommand1->CommandText = L"select *\r\nfrom Users";
         this->mySqlCommand1->Connection = this->mySqlConnection1;
         this->mySqlCommand1->Name = L"mySqlCommand1";
         this->mySqlCommand1->Owner = this;
         //
         // mySqlConnection1
         //
         this->mySqlConnection1->ConnectionString = L"User Id=programm;Host=*******.net;Database=programm;Password=14"
            L"7****;";
         this->mySqlConnection1->Name = L"mySqlConnection1";
         this->mySqlConnection1->Owner = this;


Ok its very well made,but how can execute the mySqlCommand1 and see the results?
I have made a ritchtext box wich is supposed to show me the results:

Code: Select all
private: System::Void btntest_Click(System::Object^  sender, System::EventArgs^  e) {
             box1-> Text =
          }


How am I supposed to print the results inthere?PLEASE help me!

any replay is highly appreciated!

THANKS in advance!
tsvetanakos
 
Posts: 1
Joined: Thu 26 Jan 2012 21:41

Postby Pinturiccio » Fri 27 Jan 2012 14:02

When you want to retrieve all the data, returned by query "select * from", you should use a MySqlDataReader object. You can change your code to retrieve data from database:
Code: Select all
private: System::Void button1_Click(System::Object^  sender, System::EventArgs^  e) {
             System::String^ str="";
             Devart::Data::MySql::MySqlDataReader^ reader=MySqlCommand1->ExecuteReader();
             while (reader->Read())
             {
               for (int i=0;iFieldCount;i++)
               {
                  str+=reader->GetValue(i)+"\t";
               }
               str+="\n";
             }
             box1->Text=str;
          }

For more details please refer to: http://www.devart.com/dotconnect/mysql/ ... eving.html
There are samples only for C# and Visual basic languages. So, if anything would be unclear, feel free to contact us.
Pinturiccio
Devart Team
 
Posts: 1866
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for MySQL