Stored Procedures Articles

Category - Stored Procedures

05 Oct 2018 05 Oct 2018 Mudassar Khan 0 Comments 591 Views

ASP.Net SQL Server Stored Procedures MVC

Here Mudassar Ahmed Khan has explained with an example, how to populate (bind) DropDownList using Stored Procedure in ASP.Net MVC Razor.

The records from the database will be fetched using Stored Procedure and populated into a Generic List collection of Model class objects and then will be saved into a ViewBag object.

Inside the View, the ViewBag object will be passed to the Html.DropDownList Helper function for populating the DropDownList in ASP.Net MVC Razor.

04 Oct 2018 04 Oct 2018 Mudassar Khan 0 Comments 713 Views

ASP.Net ADO.Net Excel SQL Server Stored Procedures OLEDB

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

SQL Server Stored Procedures Email Gmail Triggers

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

SQL Server Stored Procedures Gmail

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

ASP.Net AJAX jQuery Entity Framework Stored Procedures JSON MVC WebGrid

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.