Category - Stored Procedures
Results 1 - 5 of 48
05 Oct 2018 05 Oct 2018 0 Comments  591 Views
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 0 Comments  713 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 0 Comments  615 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 0 Comments  762 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  1379 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.
Results 1 - 5 of 48