Urgent: I need Help in c++.net!
 

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