User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the C++ section within the Software Development category of DaniWeb, a massive community of 423,874 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 4,115 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: Programming Forums
Views: 1403 | Replies: 2
Join Date: Aug 2005
Posts: 3
Reputation: charlie_help is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
charlie_help charlie_help is offline Offline
Newbie Poster

Help Urgent Pls Help: My codes are in errors!

  #1  
Aug 20th, 2005
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
Last edited by Dave Sinkula : Aug 20th, 2005 at 3:31 pm. Reason: Added code tags.
AddThis Social Bookmark Button
Reply With Quote  

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb C++ Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the C++ Forum

All times are GMT -4. The time now is 4:31 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC