Ming Man Chan's Blog

Many developers still using C++ for some reasons. One of my customers is using VC++ but with open source database and he is not that happy with the database so he wants to change to Oracle database. This is a simple sample that I build for him with 1 button and 1 listbox.

When I was doing few lines of code for this sample I realize 2 not quite happy scenario in VC++; 1. The Oracle DataAccess Class does not appear in blue for example, OracleConnection, as compare to C#. 2. The intellisense is not as strong when comparing to C# as well.

The following are the few lines of code that in the sample:

static String ^ORA_CONNECTION_STRING = "Data Source=orcldemo;Persist Security Info=True;User ID=HR;Password=hr;";

private: System::Void button1_Click(System::Object^  sender, System::EventArgs^  e) {

       OracleConnection ^conn = gcnew OracleConnection(ORA_CONNECTION_STRING);

       conn->Open();

       OracleCommand ^cmd = gcnew OracleCommand();

       cmd->Connection = conn;

       cmd->CommandText = "select department_id, department_name, city"

                + " from departments d, locations l" + " where d.location_id =

                   l.location_id";

        OracleDataReader ^dr = cmd->ExecuteReader();

       while (dr->Read())

       {

         listBox1->Items->Add("The " + dr->GetString(1) +

                           " department is in " + dr->GetString(2));

       }

       conn->Close();      

     }

Download the sample file from http://skydrive.live.com. The sample file name is WinAppCpp.zip. My MSN ID is chanmmn@hotmail.com