Fill a datalist with names of tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 datalists on a web form. I want to fill one with the names of the
tables and the other with the fields in the tables of an Oracle database.
Does anyone know the code to make this happen?

Thanks,

Dave
 
Hi,

Oracle must have listed somewhere the elements of a DB, in SQL it's stored
in a table named sysobjects , in oracle must exist something similar, you
can query this table to get your tables names, after that all you have to do
is build a query to get all the records from the selected table,
you may have one problem though, as the fields of each table are different
you may have problem with the second datalist, therefore I think that it's
best to use a datagrid with autogeneratecolumns set to true.


Cheers,
 
Back
Top