Parameterised Stored procedure with select query and output parameter

 create proc sp_test_select_output

(

@id int,

@rtnval int output

)

as 

begin

select * from tblCities;

select @rtnval = @@ROWCOUNT;

end

--declare @output int;

--exec sp_test_select_output 0, @output output;

--select @output as 'OUT PUT'

RaspberryPi Remote Desktop windows 10 OR Install XRDP in RaspberryPi

In this Post I will show how to install XRDP in RaspberryPi
or
How to connect RaspberryPi from Windows using Remote Desktop.

Previously I had shown you

• How to Install Linux on Raspberry Pi 3
• How to Install .Net Core 3.1 on Raspberry Pi 3
• The entity type '' requires a primary key to be defined
• Unable to configure HTTPS endpoint. No server certificate was specified
• Failed to bind to address https://127.0.0.1:5001: address already in use
• Jquery DataTable Custom Excel Export
• Jquery DataTable Custom PDF Export
• Jquery DataTable Custom PDF Export with New Column
• Jquery DataTable Custom PDF Export with logo

 OutPut:

System.IO.IOException: Failed to bind to address https://127.0.0.1:5001: address already in use.

In this post I will show you how to solve above problem. To solve this problem there are multiple ways in VS Code. some of them are...
Before that previously I had shown you

• How to Install Linux on Raspberry Pi 3
• How to Install .Net Core 3.1 on Raspberry Pi 3
• Jquery DataTable Custom Excel Export
• Jquery DataTable Custom PDF Export
• Jquery DataTable Custom PDF Export with New Column
• Jquery DataTable Custom PDF Export with logo
• The entity type '' requires a primary key to be defined.
• Unable to configure HTTPS endpoint. No server certificate was specified

Solution:

Unable to configure HTTPS endpoint. No server certificate was specified, and the default developer certificate could not be found or is out of date.

In this post I will show you how to solved the Issue. Here I am using VS Code.
Previously I had shown

• How to Install Linux on Raspberry Pi 3
• How to Install .Net Core 3.1 on Raspberry Pi 3
• Jquery DataTable Custom Excel Export
• Jquery DataTable Custom PDF Export
• Jquery DataTable Custom PDF Export with New Column
• Jquery DataTable Custom PDF Export with logo
• The entity type '' requires a primary key to be defined.

To solve this problem I had generated certificates as described in the error message as shown below.
    To generate a developer certificate run 'dotnet dev-certs https'.
    To trust the certificate (Windows and macOS only) run 'dotnet dev-certs https --trust'.
    But no use.

Don't worry there is a solution.

Steps for solution:

The entity type '' requires a primary key to be defined. If you intended to use a keyless entity type call 'HasNoKey()'.

As the title says The entity type '' requires a primary key to be defined. If you intended to use a keyless entity type call 'HasNoKey()'.

In the previous post I had shown

• How to Install Linux on Raspberry Pi 3
• How to Install .Net Core 3.1 on Raspberry Pi 3
• Jquery DataTable Custom Excel Export
• Jquery DataTable Custom PDF Export
• Jquery DataTable Custom PDF Export with New Column
• Jquery DataTable Custom PDF Export with logo

Source Code

Jquery DataTable Custom PDF Export with logo

In this post I 'll show how to Custom PDF Export with logo using Jquery DataTables.
Previously I had shown..

• How to Install Linux on Raspberry Pi 3
• How to Install .Net Core 3.1 on Raspberry Pi 3
• Jquery DataTable Custom Excel Export
• Jquery DataTable Custom PDF Export
• Jquery DataTable Custom PDF Export with New Column

Sample OutPut:

Source Code:

Jquery DataTable Custom PDF Export with New Column

In this post I 'll show how to Custom PDF Export with New Column(SNo.) using Jquery DataTables.
Previously I had shown..

• How to Install Linux on Raspberry Pi 3
• How to Install .Net Core 3.1 on Raspberry Pi 3
• Jquery DataTable Custom Excel Export
• Jquery DataTable Custom PDF Export

Sample OutPut:

Source Code: