charlie_help 0 Newbie Poster

I want to fetch data from SQL Server 2000 using tcp/ip connection
and display on the client.

Q : How do i fetch data from SQL Server 2000 and put the data on a combo box.
Q: My server user interface will have "Fetch" button ?

Client User Interface:
___________________________
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
                                              |
                                              |
                                              |
                                              |
                                              |
                                              |
-------------------------------------

My server program software is Ms Visual Studio.NET 2003.
Lanuage is C++

Appreciate the kind help recieved.

Q1) COULD YOU PLS CHECK THE FOLLOWING C++ CODES:

//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");
}

_____________________________________________________________________________________________________
Errors: Leading to database.cpp and databaseDld.cpp 


c:\Documents and Settings\Student\Desktop\database\databaseDlg.cpp(9): fatal error C1190: managed targeted code requires '#using <mscorlib.dll>' and '/clr' option
c:\documents and settings\student\desktop\database\database.cpp(84): warning C4717: 'CdatabaseDlg::CreateMySqlDataReader' : recursive on all control paths, function will cause runtime stack overflow

Problem:
Q2) DEBUGGING PROBLEM: ABOVE ERRORS
Q3) IM NOT SURE HOW TO BIND DATA INTO COMBOBOX IN C++ LANG
____________________________________________________________________________________________________

Data to bind to ComboBox:
___________________________

Inside the comboBox Method:

void CdatabaseDlg::OnCbnSelchangeCombo1()
{
     //Create an array to store the data.             

        String name[]={"","","","","","","","","","","","","","",""};

     //How to Bind Data to comboBox???

        ComboBox.

}

ANYONE PLS HELP!

From
Decruz

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.