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

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
newbie0815Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
vo1dConnect With a Mentor Commented:
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
All Courses

From novice to tech pro — start learning today.