Category - Stored Procedures
Results 16 - 20 of 70
04 Oct 2018 04 Oct 2018 0 Comments  30577 Views
Here Mudassar Ahmed Khan has explained with an example, how to import Excel data to SQL Server Database using Stored Procedure in ASP.Net using C# and VB.Net.

The Excel file will be first uploaded and copied to a folder on Server. Then using Stored Procedure and OLEDB, the data from Excel file will be read and imported into SQL Server Database Table.
07 Sep 2018 07 Sep 2018 1 Comments  25392 Views
Here Mudassar Ahmed Khan has explained with an example, how to send Email from Trigger in SQL Server.

This article will illustrate how to send email from Trigger using sp_send_dbmail Stored Procedure in SQL Server by using GMAIL SMTP settings.

This article is applicable to following SQL Server versions i.e. 2008, 2008R2, 2012, 2014, 2016 and 2017.
06 Sep 2018 06 Sep 2018 2 Comments  60169 Views
Here Mudassar Ahmed Khan has explained with an example, how to send email in SQL Server using Stored Procedure.

This article will illustrate how to send email using sp_send_dbmail Stored Procedure in SQL Server by using GMAIL SMTP settings.

This article is applicable to following SQL Server versions i.e. 2008, 2008R2, 2012, 2014, 2016 and 2017.
05 Jul 2018 05 Jul 2018 0 Comments  11667 Views
Here Mudassar Ahmed Khan has explained with an example, how to perform Custom Paging in WebGrid using Stored Procedure and Entity Framework in ASP.Net MVC Razor.

Custom Paging will be performed at Database level inside the Stored Procedure using the ROW_NUMBER function.

The PageIndex and PageSize values will be passed to the Stored Procedure using Entity Framework and only the specific records will be fetched and displayed in WebGrid, thus reducing the bandwidth usage.
03 Jul 2018 03 Jul 2018 1 Comments  42383 Views
Here Mudassar Ahmed Khan has explained with an example, how to perform Select Insert Edit Update and Delete (CRUD) using Single Stored Procedure in ASP.Net MVC Razor.

Single Stored Procedure will be called using Entity Framework and a parameter named Action will be used to send instructions about the operation to be performed in SQL Server database. Single Stored Procedure CRUD operation will be performed by calling the Controller Action methods using jQuery AJAX and JSON in ASP.Net MVC Razor.
Results 16 - 20 of 70