___________________________
Category:                                |
 o Books            o Stationey      |  }   Radio Buttons: If Books is choose, books items will display
 o accessories    o I.T Stuffs      |  }
                                              |
                _________              |
 Item:       |____|_^_|------------------------> {ComboBox} The data is retrieved /fetch from SQL Server 2000 by tcp/ip
                                              |
                                              |
                                              |
                                              |
                                              |
                                              |
-------------------------------------

//databaseDlg.cpp 
 
 
#using <mscorlib.dll>
#using <System.dll>
#using <System.Data.dll>
 
void CdatabaseDlg::CreateMySqlDataReader(char* mySelectQuery, char* myConnectionString)
{   
     SqlConnection* myConnection = new SqlConnection(myConnectionString "provider=sqloledb;Data Source=local;Initial Catalog=PRODUCT;User Id=temp;Password=password;");
 
     SqlCommand* myCommand = new SqlCommand(mySelectQuery "SELECT ITEM FROM PRODUCT",  myConnection);
 
     myConnection->Open();
     SqlDataReader* myReader = myCommand->ExecuteReader(CommandBehavior::CloseConnection);
     while(myReader->Read())
     {
          Console::WriteLine(myReader->GetString(0));
     }
     myReader->Close();
     //Implicitly closes the connection because CommandBehavior::CloseConnection was specified.
};

//databaseDlg.h
//Declare the method here
 
public:
 
    void CreateMySqlDataReader(char* mySelectQuery, char* myConnectionString);

//database.cpp
//Call the Method here
 
void CdatabaseDlg::CreateMySqlDataReader(char* mySelectQuery, char* myConnectionString)
{
     CdatabaseDlg call;
     call.CreateMySqlDataReader("SELECT ITEM FROM PRODUCT",
     "provider=sqloledb;Data Source=local;Initial Catalog=MENU;User Id=temp;Password=password");
}

void CdatabaseDlg::OnCbnSelchangeCombo1()
{
     //Create an array to store the data.             
 
        String name[]={"","","","","","","","","","","","","","",""};
 
     //How to Bind Data to comboBox???
 
        ComboBox.
 
}