Category - SQL Server
Results 1 - 20 of 501
21 Dec 2021 21 Dec 2021 0 Comments  634 Views
Here Mudassar Khan has explained how to download and install the Northwind database in SQL Server 2014.

This article also contains a YouTube Video tutorial which explains how to download and install Microsoft’s Northwind database in SQL Server 2014.
20 Dec 2021 20 Dec 2021 0 Comments  466 Views
Here Mudassar Khan has explained how to download and install the Northwind database in SQL Server 2017.

This article also contains a YouTube Video tutorial which explains how to download and install Microsoft’s Northwind database in SQL Server 2017.
20 Dec 2021 20 Dec 2021 0 Comments  886 Views
Here Mudassar Khan has explained how to download and install the Northwind database in SQL Server 2019.

This article also contains a YouTube Video tutorial which explains how to download and install Microsoft’s Northwind database in SQL Server 2019.
24 Nov 2021 26 Nov 2021 0 Comments  1495 Views
Here Mudassar Ahmed Khan has explained with an example, how to prevent (avoid) duplicate (double) record insert into SQL Server Database in ASP.Net using C# and VB.Net.
08 Nov 2021 08 Nov 2021 0 Comments  1257 Views
Here Mudassar Ahmed Khan has explained with an example, how to use WHILE LOOP in SQL Server (Transact-SQL).

The WHILE statement as used in various programming languages works in similar way in SQL Server. It is a control flow statement and it is used to perform iterations until the condition holds TRUE.
24 Sep 2021 24 Sep 2021 0 Comments  2031 Views
Here Mudassar Ahmed Khan has explained with an example, how to get Total Record Count (Row Count) of Table when Paging in Stored Procedure using Common Table Expression (CTE) in SQL Server.
24 Sep 2021 24 Sep 2021 0 Comments  1569 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement Paging in SQL Server Stored Procedure without using Temp Tables (Temporary Tables).

This article will illustrate how to write a Stored Procedure that does Paging using Common Table Expression (CTE) technique in SQL Server.
14 Sep 2021 14 Sep 2021 0 Comments  1946 Views
Here Mudassar Ahmed Khan has explained with an example, how to write a Stored Procedure that does Paging using Common Table Expression (CTE) in SQL Server.
04 Sep 2021 04 Sep 2021 0 Comments  1697 Views
Here Mudassar Ahmed Khan has explained with an example, how to write a Stored Procedure that does Paging along with Total Row Count in SQL Server.

This article will illustrate how to implement Paging in Stored Procedure using TEMP Tables in SQL Server.
12 Aug 2021 12 Aug 2021 0 Comments  2185 Views
Here Mudassar Ahmed Khan has explained with an example, how to call (consume) Web API using jQuery AJAX in ASP.Net Core MVC.

This article will explain how to make a jQuery POST call to Web API Controller’s method using jQuery AJAX in ASP.Net Core MVC.
12 Aug 2021 12 Aug 2021 0 Comments  2767 Views
Here Mudassar Ahmed Khan has explained a step by step tutorial with an example for beginners, how to build a simple Web API in ASP.Net Core MVC.

This article will explain how to make a jQuery POST call to Web API using jQuery AJAX in ASP.Net Core MVC.
11 Aug 2021 11 Aug 2021 0 Comments  6959 Views
Here Mudassar Ahmed Khan has explained with an example, how to perform CRUD operation (Create, Read, Update and Delete) using Web API and Stored Procedure in ASP.Net MVC Razor using Entity Framework and jQuery AJAX.

The Stored Procedure will be called using Entity Framework to perform CRUD operations such as Select, Insert, Edit, Update and Delete operations.
31 Jul 2021 31 Jul 2021 0 Comments  3411 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement and populate charts from database using jQuery AJAX in ASP.Net Core MVC.

The HTML 5 Canvas charts have been implemented in ASP.Net Core MVC using Chart.js library.

This article will illustrate how to display the animated HTML5 chart in browsers that do not support CSS3 like IE 8.
29 Jul 2021 29 Jul 2021 0 Comments  4756 Views
Here Mudassar Ahmed Khan has explained with an example, how to upload (insert) and download (retrieve) Files from Folder (Directory) and Path in Database using Web API in ASP.Net MVC Razor.

The Web API will insert the File information into SQL Server database using Entity Framework while the actual File will be saved in Folder (Directory) in ASP.Net MVC Razor.

The Web API will be called using jQuery AJAX and the file will be uploaded to Database using HTML5 Form Data and XmlHttpRequest (XHR).
29 Jul 2021 29 Jul 2021 0 Comments  1227 Views
Here Mudassar Ahmed Khan has explained with an example, how to use, implement and populate Charts from database using Google Charts API in ASP.Net Core MVC.

This article will illustrate how to populate Pie and Doughnut Charts from database using the Google Charts API in ASP.Net Core MVC.
17 Jul 2021 17 Jul 2021 0 Comments  1278 Views
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 17 Jul 2021 0 Comments  1950 Views
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 29 Jun 2021 0 Comments  4712 Views
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 29 Jun 2021 0 Comments  4113 Views
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 29 Jun 2021 0 Comments  4790 Views
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.
Results 1 - 20 of 501