Comments by Viswanatha Swamy

Viswanatha Swamy 16-Mar-20 0:14am View

@João Henrique Braga,
Good morning.
1. Are you trying to develop Windows Forms project and want to save to File Service?
2. Are you trying to develop Web Project and want to save to Server?
3. Are you trying to develop a solution where you want to save the documents into the database?

Please advise. Many thanks.

Viswanatha Swamy 14-Mar-20 10:19am View

+1

Viswanatha Swamy 12-Mar-20 10:05am View

Looks like the issue is with the route you are using in .ts file.
return this.http.post(this.ApiUrl + '/register/login', user)

I assume it should be "/login/login" instead of "/register/login". Becuase your API method has only [Route("login")] has route. Many thanks.
return this.http.post(this.ApiUrl + '/login/login', user)

Viswanatha Swamy 12-Mar-20 9:58am View

I am working on it. Let me try your code on my laptop and let you know. Give me some time. Many thanks.

Viswanatha Swamy 12-Mar-20 9:53am View

@Eliza,
I the server-side the up and running. I assume it should work when we use a postman. Please advise if your postman is going through?

Viswanatha Swamy 12-Mar-20 9:48am View

@Eliza,
Good evening. Could you please just post the method signature? It will be helpful to have the Attributes too. Many thanks.

Viswanatha Swamy 12-Mar-20 9:41am View

@Eliza,
Good evening. So the two experiments point the Web API. Is this Web API Developed in .Net Framework OR .Net Core? Is it being executed in Kestrel Server OR IIS Express OR IIS? Please advise.

Viswanatha Swamy 12-Mar-20 9:31am View

@Eliza Maria,
Good evening. Could you please try sending the logic values using Postman to the /register/login endpoint? That will help us see what output is returned from that endpoint.

Viswanatha Swamy 12-Mar-20 8:36am View

@Eliza Maria,
Good evening. Based on the URL https://localhost:5001 it looks like you are executing the Web Api on the Local Laptop. The configuration should be done on the ASP.Net Web API side. Could you please hit the API endpoint using postman to see what output is given.

Viswanatha Swamy 8-Mar-20 8:00am View

Good evening. I had a table with a Unique Identifier, Varchar, int, and DateTime. I have used the below command for the output. I have tested in SQL Server Mgt Studio.

SELECT [ColumnName], [ColumnValue]
FROM Health
CROSS APPLY
(
VALUES
('Id', cast(Id as varchar(50))),
('Name', [Name]),
('Health Parameter1', cast(HealthParameter1 as varchar(10))),
('Health Parameter2', cast(HealthParameter2 as varchar(10))),
('Received At', cast(ReceivedAt as varchar(50)))
) c ([ColumnName], [ColumnValue])
where Id = 'F84BBA87-6241-4E0A-4F42-08D7C291F501';

Viswanatha Swamy 8-Mar-20 7:56am View

Deleted

Good evening. I had a table with a Unique Identifier, Varchar, int, and DateTime. I have used the below command for the output. I have tested in SQL Server Mgt Studio.

SELECT [ColumnName], [ColumnValue]
FROM Health
CROSS APPLY
(
VALUES
('Id', cast(Id as varchar(50))),
('Name', [Name]),
('Health Parameter1', cast(HealthParameter1 as varchar(10))),
('Health Parameter2', cast(HealthParameter2 as varchar(10))),
('Received At', cast(ReceivedAt as varchar(50)))
) c ([ColumnName], [ColumnValue])
where Id = 'F84BBA87-6241-4E0A-4F42-08D7C291F501';

Viswanatha Swamy 8-Mar-20 4:50am View

Do we need to cast if the columns are of multi-data types? Example: Employee Id is int and the rest of the columns are of varchar type.

Viswanatha Swamy 4-Mar-20 7:11am View

Cool. Ok once you execute those commands it will create the database inside the C:\User folder. Inside your IIS could you please modify the connection string too Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\YourUserName\YourDatabaseName.mdf;Integrated Security=True;Connect Timeout=30

Viswanatha Swamy 4-Mar-20 4:18am View

I have updated the solution 2. Please see the instructions and execute the commands. I have also given the URL for additional details. I have replicated the issue on my Laptop and execute the commands.

Viswanatha Swamy 4-Mar-20 3:41am View

Please give me a few minutes. I am replicating the issue on my Laptop.

Viswanatha Swamy 4-Mar-20 3:29am View

Could you please paste the image of the Connection Strings section from IIS?

Viswanatha Swamy 4-Mar-20 1:00am View

Is there a way you can do the screen share. We both can hunt the issue. That will be faster.

Viswanatha Swamy 4-Mar-20 0:04am View

@WeiJun420,
Do you have SQL Server installed on your Laptop? Please advise.

Viswanatha Swamy 3-Mar-20 23:45pm View

@WeiJun420,
Good morning. I have updated the solution 2 with the steps to add connection string inside your published website. Please let me know how did it go. Many thanks.

Viswanatha Swamy 3-Mar-20 8:34am View

Under the website, please navigate to ASP.Net, then double click "Connection Strings" and provide your connection string. Please let me know if that worked. Many thanks.

Viswanatha Swamy 3-Mar-20 5:04am View

Thanks. I see you are connecting to your local database. Now the query is where are you publishing? If you are publishing to Azure OR Any other could, then the hosted application will be trying to reach the database with your local setting and will throw the above-mentioned exception. Could you please advise if you are hosting the website outside your Laptop?

Viswanatha Swamy 3-Mar-20 4:57am View

Good afternoon. Could you please paste the connection string inside the rdlc file. You can remove the User Name and Password before pasting the connection String

Viswanatha Swamy 3-Mar-20 4:57am View

Deleted

Good afternoon. Could you please paste the connection string inside the rdlc file. You can remove the User Name and Password before pasting the connection String

Viswanatha Swamy 3-Mar-20 4:41am View

Good afternoon. Could you please post the error message which you have posted earlier? Many thanks.

Viswanatha Swamy 2-Mar-20 3:08am View

In your local the error will not come as both the UI and Web API will have http(s)://localhost. Now that you have hosted Web API and trying to access it from your local the domains are different. In this case, you have to whitelist the domains from which you want the Web API to be accessed. When you try through the postman it will go through without any issues. Please refer this URL https://developer.mozilla.org/en-US/docs/Web/HTTP/CORS/Errors/CORSMissingAllowOrigin

Viswanatha Swamy 2-Mar-20 1:42am View

Are you accessing the hosted Web API using your application from "http://localhost:8100"? Please advise. In this case you need to add the URL to the CORS section. Please refer to the URL: https://docs.microsoft.com/en-us/aspnet/web-api/overview/security/enabling-cross-origin-requests-in-web-api

Comments by Viswanatha Swamy (Top 26 by date)