SQL Server Articles

Category - SQL Server

17 Jul 2021 Mudassar Khan 0 Comments 888 Views

ASP.Net SQL Server SqlDataSource Stored Procedures

Here Mudassar Ahmed Khan has explained with an example, how to use the CancelSelectOnNullParameter property in ASP.Net SqlDataSource.

The CancelSelectOnNullParameter property is used to cancel the SELECT query i.e. return no result when a parameter is NULL.

17 Jul 2021 Mudassar Khan 0 Comments 916 Views

ASP.Net SQL Server GridView SqlDataSource Stored Procedures

Here Mudassar Ahmed Khan has explained with an example, how to use NULL Parameters with SqlDataSource and how to pass NULL parameters to StoredProcedure using SqlDataSource in ASP.Net.

In this article, a GridView will be populated and filtered using a StoredProcedure and SqlDataSource in ASP.Net.

29 Jun 2021 Mudassar Khan 0 Comments 1780 Views

ASP.Net Excel SQL Server Entity Framework MVC Core

Here Mudassar Ahmed Khan has explained with an example, how to download Excel file in ASP.Net Core MVC.

The data from the database is fetched using Entity Framework and then the data is downloaded as Excel file using ClosedXML Excel library in ASP.Net Core MVC.

29 Jun 2021 Mudassar Khan 0 Comments 1655 Views

ASP.Net Excel SQL Server MVC Core

Here Mudassar Ahmed Khan has explained with an example, how to read (import) Excel file in ASP.Net Core MVC.

The uploaded Excel file data will be read using OLEDB library and the read data will be inserted into SQL Server database using SqlBulkCopy class in ASP.Net Core MVC.

29 Jun 2021 Mudassar Khan 0 Comments 1682 Views

ASP.Net Excel SQL Server DataTable DataSet MVC Core

Here Mudassar Ahmed Khan has explained with an example, how to export DataSet or DataTable to Excel file in ASP.Net Core MVC.

The data from the database is fetched using ADO.Net into a DataTable.

Then the DataTable is exported and downloaded as Microsoft Excel file using ClosedXML Excel Library which is a wrapper for OpenXml Excel library.