This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 12%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVW%3C/text%3E%3C/svg%3E)
I have an c# code that runs fine on local maskin access local database. The first think that happens is a call to a stored procedure and the record set populates a dropdown. I have move the database to azure and also published the app to azure. The app starts in the browser bur no thing is loaded into the dropdown. If I run the same code but with a select from a table it will work fine I have run the stored procedure from my local SSMS and it works So what are I'm doing wrong?
So what are I'm doing wrong?
Without any error message, any line of code and any kind of more detailed information, no one can say what you are doing wrong. So please provide the required informations.
Hi @Olaf Helper I'm new in Azure and I'm using Radzen do create a simple application. I rebuilt my simple application with two UI, one that loads a dropdown with a select statement and the other UI has a dropdown with a stored procedure call. This one works. I was happy with that. I wrote some new code and a new database, same thing a dropdown that uses a select statement, this does not work. It is very random what works and what does not work. So a compered the two databases, same setup, I compered the apps, same setup. Now i'm guessing, but it seams that the DB call is timed out or something else is wrong. So no error messages.
@Victor Wallenberg (SBK) Thank you for reaching out ans sorry about the issue you are facing. Could you please share the error message you are getting. Regards, Oury
Hi, I have posted a new question and a think the problem is the connectstring
@Victor Wallenberg (SBK) Could you please share the link of the new question you posted. Regards, Oury
Oury, just click Victor's name to get his profile and you will see his recent posts.
Enable Diagnostic Logging for your Azure App Service.
Try to enable Application Insights also.
Make sure you allow Azure Services to access the Azure SQL Database as explained here.
In addition, @Victor Wallenberg (SBK) have a look at Tutorial: Deploy an ASP.NET Core and Azure SQL Database app to Azure App Service for steps regarding deploying a your local database to Azure and configuring your app service to connect to it.
/cc @Oury Ba-MSFT
@Victor Wallenberg (SBK) Did you get the chance to review the above link to check if you are not missing any steps. Regards, Oury