Category - Stored Procedures
Results 11 - 15 of 70
15 Oct 2020 15 Oct 2020 0 Comments  3232 Views
Here Mudassar Ahmed Khan has explained with an example, how to pass Table Variable as Parameter to Stored Procedure in SQL Server.

A Table of User Defined Table Type has to be created of the same schema as that of the Table Valued parameter and then it is passed as Parameter to the Stored Procedure in SQL Server.
15 Oct 2020 15 Oct 2020 1 Comments  7632 Views
Here Mudassar Ahmed Khan has explained with an example, how to pass Table Variable as Parameter to Stored Procedure in SQL Server.

A Table Variable of User Defined Table Type has to be created of the same schema as that of the Table Valued parameter and then it is passed as Parameter to the Stored Procedure in SQL Server.
15 Oct 2020 15 Oct 2020 0 Comments  6357 Views
Here Mudassar Ahmed Khan has explained with an example, how to pass TEMP Table as Parameter to Stored Procedure in SQL Server.

A TEMP Table of User Defined Table Type has to be created of the same schema as that of the Table Valued parameter and then it is passed as Parameter to the Stored Procedure in SQL Server.
20 Nov 2018 20 Nov 2018 0 Comments  23155 Views
Here Mudassar Ahmed Khan has explained with an example, how to insert (save) data (records) to database by calling Stored Procedure using Entity Framework in ASP.Net MVC Razor.

First the multiple rows (records) will be insert into an HTML Table and then the data from all the rows of the HTML Table will be sent to Controller using jQuery AJAX which will be ultimately saved to database by calling Stored Procedure using Entity Framework in ASP.Net MVC Razor.
05 Oct 2018 05 Oct 2018 0 Comments  23239 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.
Results 11 - 15 of 70