Show all Tables in Database and Choose with "TabSheet"
Posted on 2004-09-25
Hello All; [ Delphi 6.02 Pro | Win2K Pro]
( Sorry for the title, but that is what I am needing :-) )
[ HISTORY ]
I have just started in the ADO Database part of Delphi.,
As I am (Have already) Designed a fully working project.
Using [ TQuery, TDataSource, TAdoTable, TDBGrid]
With a lot of " [TDBComboBox, TDBEdit, TDBMemo, TDBLabel];
I have a web site, ( A Knowledge Base, like Microsoft's, that I have
Access Database "ASP" )
In the Admin area of the KB site, I have duplicated all the "Fields" into
A TPageControl.TabSheets'; With everything working beautifully. ( I Love
I have added in " DBGrid1.OnMouseMove" & "DBGrid1.TitleClick := For ASC &
( I did a lot of searching on the internet, trying out several peoples
solutions to doing the ASC & DESC
in the DBGrid. and then i just added this in place.
[ ADOTable1.Sort := 'ContentID DESC, CatID ASC'; ]
And bingo, works like a charm :-)... The simplest things are always the ones
that you do last.
So that part of it is over with.
What I would like to do now, is to be able to make the following possible.
Have my Connection to open up the "Database" showing "ALL" tables.
Then being able to click on a particular Table, and have it open a
[TabSheet from a PageControl], that is Embedded in the [Main
In this PageControl.TabSheet. Will have a
DBGrid, TDBEdits, TDBMemo, and so on. ( I know you know what I am getting at )
That will allow me to then "Add/Edit/Delete" the information that is located in its Table.
There are a Total of: [ 32 ] Tables, located in the Database. With a Great
Possibility, for more.
As the KB Site grows, and more Categories become available.And more
information is needed
For the newer Categories. That will then benefit the original categories...
I know that this project is going to be something that might take a while to
As the general project that I have right now, I started on today, and have
gotten this far.
So I did it basically quick, Which I am a Great Visual Designer for Programs, and Web Sites.
So designing the User Interface of the program was nothing, very much fun actually.
And connecting all the "DB" objects together, was extremely cool, that made me love Delphi
That much more.
So if anyone has some helpful links, information or some sample code that
they would be
Willing to share with me, that would be great.
Take Care All;