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