SQL Server Articles

Category - SQL Server

20 Dec 2021 Mudassar Khan 0 Comments 14653 Views

SQL Server

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 Mudassar Khan 0 Comments 5796 Views

ASP.Net SQL Server

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 Mudassar Khan 0 Comments 1916 Views

SQL Server Tips

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 Mudassar Khan 0 Comments 5408 Views

SQL Server Stored Procedures

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 Mudassar Khan 0 Comments 2408 Views

SQL Server Stored Procedures Table

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 Mudassar Khan 0 Comments 4030 Views

SQL Server Tips Stored Procedures

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 Mudassar Khan 0 Comments 3773 Views

SQL Server Tips Stored Procedures

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 Mudassar Khan 0 Comments 7252 Views

ASP.Net AJAX SQL Server jQuery Entity Framework MVC Web API Core

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 Mudassar Khan 0 Comments 4657 Views

ASP.Net AJAX SQL Server jQuery Entity Framework MVC Web API Core

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 Mudassar Khan 0 Comments 15719 Views

ASP.Net SQL Server Entity Framework Stored Procedures MVC Web API

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 Mudassar Khan 0 Comments 7903 Views

ASP.Net SQL Server jQuery jQuery Plugins Charts HTML5 JSON MVC Core

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 Mudassar Khan 0 Comments 10808 Views

ASP.Net SQL Server Entity Framework FileUpload MVC Web API

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 Mudassar Khan 0 Comments 2637 Views

ASP.Net ADO.Net SQL Server Charts Google MVC Core

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 Mudassar Khan 0 Comments 1842 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 4555 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 10835 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 13795 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 11505 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.

28 Jun 2021 Mudassar Khan 0 Comments 8451 Views

ASP.Net ADO.Net SQL Server DataTable DataSet MVC Core

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 Mudassar Khan 0 Comments 6229 Views

ASP.Net SQL Server Entity Framework DropDownList Core Razor Pages

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.