View SQL Server Tables in ASP.net/ADO.net

  • Thread starter Thread starter Allison Thomas
  • Start date Start date
A

Allison Thomas

I am trying to list the tables in a SQL Server database on an ASP.net page
but can't seem to find out how to do it. The old ADOX did it for Access data
bases and I presume SQL Server but this seems like taking a step backward.
I am using VS.Net 2003. Any Help would be appreciated.

Allison Thomas
 
SELECT Name FROM sysobjects where Type = 'U'

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top