Solved

connection on mysql server using dbexpress from the borland c++ builder

Posted on 2002-07-19
1
1,032 Views
Last Modified: 2012-06-21
hi, i tried to get a tables data from a mysql server with dbexpress komponents. i used sql connect to connect to the server.all went fine.then i could get all tables and send the names to a listbox.not a problem so fare.but now my problem is, to get the fieldnames and values into a dbgrid. does anyone knows, whicn komponents i have to use? so that im able to get all the tables data in an dbgrid and be able to edit it there?
or does anyone knows a great site with some hints for my problem?
thx in advance
0
Comment
Question by:newbie0815
1 Comment
 
LVL 11

Accepted Solution

by:
vo1d earned 500 total points
ID: 7177254
hi, try this:
insert to ur form:
TSQLConnection
TSQLClientDataSet
TDataSource
TDBGrid
----------
- TSQLClientDataSet->DBConnection needs to belinked to TSQLConnection
- TDataSource->DataSet needs to be linked to TSQLClientDataSet
- TDBGrid->DataSource needs to be linked to TDataSource
------
now in ur code,u only have todo:
SQLClientDataSet->CommandType = ctTable;
SQLClientDataSet->CommandText = <thetablename>;
SQLClientDataSet->Open();

thats all.
greets void

0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by John Humphreys C++ Threading and the POSIX Library This article will cover the basic information that you need to know in order to make use of the POSIX threading library available for C and C++ on UNIX and most Linux systems.   [s…
  Included as part of the C++ Standard Template Library (STL) is a collection of generic containers. Each of these containers serves a different purpose and has different pros and cons. It is often difficult to decide which container to use and …
The goal of the video will be to teach the user the difference and consequence of passing data by value vs passing data by reference in C++. An example of passing data by value as well as an example of passing data by reference will be be given. Bot…
The viewer will be introduced to the member functions push_back and pop_back of the vector class. The video will teach the difference between the two as well as how to use each one along with its functionality.

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question