Category - SQL Server
Results 1 - 5 of 412
15 Jan 2021 15 Jan 2021 0 Comments  293 Views
Here Mudassar Ahmed Khan has explained with an example, how to pass Model data from Controller to View in ASP.Net Core MVC.

The data from the SQL Server Database will be fetched using Entity Framework and populated into Model which will be later sent to the View in ASP.Net Core MVC.
02 Jan 2021 02 Jan 2021 0 Comments  350 Views
Here Mudassar Ahmed Khan has explained with an example, how to set Connection String with Windows Authentication in AppSettings.json in .Net Core and ASP.Net Core MVC.

In a Connection String with Windows Authentication, the Integrated Security property is set to TRUE.
02 Jan 2021 02 Jan 2021 0 Comments  465 Views
Here Mudassar Ahmed Khan has explained with an example, how to set SQL Server Connection String in AppSettings.json in .Net Core and ASP.Net Core MVC.

SQL Server Database has two types of Connection Strings i.e. Windows Authentication and SQL Server Authentication.
02 Jan 2021 02 Jan 2021 0 Comments  486 Views
Here Mudassar Ahmed Khan has explained with an example, how to set Connection String with SQL Server Authentication in AppSettings.json in .Net Core and ASP.Net Core MVC.

In a Connection String with SQL Server Authentication, the User Id and Password of the SQL Server Database is specified.
15 Dec 2020 15 Dec 2020 0 Comments  607 Views
Here Mudassar Ahmed Khan has explained with an example, how to export to Excel file in ASP.Net Core Razor Pages.

The data from the database is fetched using Entity Framework and then the data is exported and downloaded as Microsoft Excel file using ClosedXML Excel library which is a wrapper for OpenXml Excel library.
Results 1 - 5 of 412