•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the C++ section within the Software Development category of DaniWeb, a massive community of 363,558 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,885 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our C++ advertiser:
Views: 1317 | Replies: 2
![]() |
•
•
Join Date: Aug 2005
Posts: 3
Reputation:
Rep Power: 0
Solved Threads: 0
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:
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:
____________________________________________________________________________________________________
____________________________________________________________________________________________________
_____________________________________________________________________________________________________
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:
ANYONE PLS HELP!
From
Decruz
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
|
|
|
|
|
|
-------------------------------------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
Last edited by Dave Sinkula : Aug 20th, 2005 at 3:31 pm. Reason: Added code tags.
•
•
Join Date: Aug 2005
Posts: 3
Reputation:
Rep Power: 0
Solved Threads: 0
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
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
![]() |
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb C++ Marketplace
- Urgent Help- Printing Screen (Pascal and Delphi)
- Urgent: I need Help in c++.net! (ASP.NET)
- print datagrid (JavaScript / DHTML / AJAX)
- Urgent: Please Help Computer Keep Saying Kernel_data_inpage_error And Some Times Kern (Storage)
- how do i bring my pc back to life (Troubleshooting Dead Machines)
- which version you recommend ? (C++)
Other Threads in the C++ Forum
- Previous Thread: unsigned character pointer to Hex values
- Next Thread: algorithm simulation


Linear Mode