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

I do not understand why you want to directly use a tcp/ip connection for fetching the data.

Rather creater a dsn to be used over the network to access the sqlserver data.

From your Cpp file use Sqlconnect using the dsn name. Prepare the stmt and exceute the sql statement to retrieve the data.

Hi Sutanu!

I'm using tcp/ip to transfer those data from my sql server 2000 to my client.

You suggest that to use:

Rather creater a dsn to be used over the network to access the sqlserver data.
From your Cpp file use Sqlconnect using the dsn name. Prepare the stmt and exceute the sql statement to retrieve the data.

Q1) How do i do that?
Q2) Can you provide some source codes?

Thank You

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.