I have an ASP.NET application in which I need to connect to a specific SQL Server database and then list all of the tables contained within that database.

How can I accomplish this?