CODEWITHSUNDEEP
sqlazure
user2728409
user2728409

Reputation: 275

How to view data on the Azure SQL database

I created a default ASP.NET web form web site using Visual Studio. By default it contains a .mdf database file, Registration page, Login page and some other pages. Then I host this web application on Azure as a web app.

After that I did several registrations for the web site and I need to see the data (data which i used on registration) on the hosted application.

Is there any way to connect to the database file in Azure? In Azure, I did not set up a connection string. I just publish the app and it manages the database connection itself.

Upvotes: 1

Views: 2251

Answers (1)

Joey Cai
Joey Cai

Reputation: 20067

There is nothing inside the "Database" section

It seems that you do not publish your asp.net to Azure with Sql Database correctly. So, you could refer to this article to check if you have deploy database correctly.

As you have published, you could go to the database on Azure portal and choose query editor(preview). Click Login and enter the username and password you have set in Azure Sql server. enter image description here

Also, you could open Microsoft SQL Server Management Studio to get your database. And you also need to login into the Sql Server as above.

enter image description here

After logining into the sql database, you will see all the data you have insert.

BTY, make sure you have synced the data in local database to Azure Sql Database. For more details, you could refer to this article.

Upvotes: 2

Related Questions