If you want help with Delphi then :
Try to work with ADO components , So
Add a
ADOConnection
after configuring it(setting its connection string) ,set its Active property to true then
Add a
ADOTable
and set its connection and table and set its Active to True
And then add a
DataSource
and set its
DataSet
to
ADOTable
Then drop a
DataGrid
and set its
DataSource
to the previously added datasource
If you want to work with individual rows in table try to observe
ADOTable
methods.
Also consider using
ADOQuery
and
ADOCommand
.
Good Luck
After you comment :
So if you did these things start writing your SQLs in
ADOQuery
's
SQL
:
select * from EnigmaTable where ID=:id
put a ":" behind every name that you want to become a parameter.
and set the parameters values before executing the
ADOQuery
datasets.
After running the SQL you can access their values by something like this :
Query1.FieldByName("EngineName").AsString