Category - SQL Server
Results 21 - 40 of 521
20 Dec 2021 20 Dec 2021 0 Comments  14653 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  5796 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  1916 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  5408 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  2408 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  4030 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  3773 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  7252 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  4657 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  15719 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  7903 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  10808 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  2637 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  1842 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  4555 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  10835 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  13795 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  11505 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.
28 Jun 2021 28 Jun 2021 0 Comments  8451 Views
Here Mudassar Ahmed Khan has explained with an example, how to use a DataSet or DataTable as Model in View in ASP.Net Core MVC.

Though it is not a good practice to use to use DataSet or DataTable as Model in View in MVC Core architecture, thus user’s please make a note that this is just an informative article and does not recommend to use DataSet or DataTable as Model in View in ASP.Net Core MVC.
24 Jun 2021 24 Jun 2021 0 Comments  6229 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement multiple Selection DropDownList using jQuery Select2 plugin in ASP.Net Core Razor Pages.

The multiple Selection DropDownList will be populated from SQL Server database using Entity Framework in ASP.Net Core Razor Pages.
Results 21 - 40 of 521