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,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

System.Data.DataRowView problem 2
Getting a datalist row 4
datalist within a datalist? 1
radio button in datalist 1
Auto fill not working 2
Generic list and MethodInfo 4
Datalist within a Datalist. 2
Show tif or pdf in DataList 2

Back
Top