Re: Fill a datalist with names of tables
From: kscdavefl (kscdavefl_at_discussions.microsoft.com)
Date: 08/06/04
- Next message: coughlla: "Re: Blank tab page when switching tab pages inside a thread"
- Previous message: Mike Newton: "Re: INSERT syntax error OleDB"
- In reply to: Ignacio Machin \( .NET/ C# MVP \): "Re: Fill a datalist with names of tables"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 6 Aug 2004 09:09:02 -0700
Hi again:
I'll give that a try, many thanks
Dave
"Ignacio Machin ( .NET/ C# MVP )" wrote:
> 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,
>
> --
> Ignacio Machin,
> ignacio.machin AT dot.state.fl.us
> Florida Department Of Transportation
>
>
>
> "kscdavefl" <kscdavefl@discussions.microsoft.com> wrote in message
> news:86751BAB-6D75-43B6-8159-A7BD1DC21E0C@microsoft.com...
> > 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
>
>
>
- Next message: coughlla: "Re: Blank tab page when switching tab pages inside a thread"
- Previous message: Mike Newton: "Re: INSERT syntax error OleDB"
- In reply to: Ignacio Machin \( .NET/ C# MVP \): "Re: Fill a datalist with names of tables"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
