Category - Stored Procedures
Results 21 - 40 of 73
05 Jul 2018 05 Jul 2018 0 Comments  15349 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  51392 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.
22 Jun 2018 27 Jun 2018 0 Comments  11549 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement Client Side AJAX based Paging using jQuery in ASP.Net GridView with C# and VB.Net.

In Client Side Paging, the GridView will not be populated from Server Side instead, a jQuery function will make an AJAX call to the server and fetch the records from database based on Page Index using SQL Server Custom Paging.

Later using jQuery, the fetched records will be used to populate the GridView on Client Side.
22 Jun 2018 22 Jun 2018 0 Comments  7140 Views
Here Mudassar Ahmed Khan has explained with an example, how to perform custom Paging in GridView using jQuery AJAX in ASP.Net with C# and VB.Net.

Custom Paging will be performed within Database using SQL Server Row_Number function and only the records for the requested Page will be sent to the jQuery function using AJAX.

Later using jQuery, the fetched records will be used to populate the GridView on Client Side.
14 Jun 2018 14 Jun 2018 1 Comments  46088 Views
Here Mudassar Ahmed Khan has explained with an example, how to insert Date in dd/MM/yyyy format in SQL Server Database Table using ASP.Net with C# and VB.Net.

This article will illustrate how to insert Date in dd/MM/yyyy format in Database Table using Stored Procedures and the SQL Server DATEFORMAT command in ASP.Net.
14 Jun 2018 14 Jun 2018 0 Comments  10570 Views
Here Mudassar Ahmed Khan has explained with an example, how to convert (select) Date in dd/MM/yyyy format in SQL Server.

This article will illustrate how to use Stored Procedures for converting Dates in dd/MM/yyyy format.
14 Jun 2018 14 Jun 2018 0 Comments  2624 Views
Here Mudassar Ahmed Khan has explained with an example, what is DATEFORMAT command in SQL Server, why it is used and also an example which helps understanding the DATEFORMAT command in better way.
14 Jun 2018 14 Jun 2018 0 Comments  118568 Views
Here Mudassar Ahmed Khan has explained with an example, how to insert and select Date in dd/MM/yyyy format in DateTime Column of SQL Server database.

This article will illustrate how to use Stored Procedures for inserting and selecting Dates in dd/MM/yyyy format.
21 May 2018 21 May 2018 0 Comments  38182 Views
Here Mudassar Ahmed Khan has explained with an example, how to read, parse and insert XML File data to SQL Server Table using Stored Procedure.

SQL Server 2005 and above versions, allow to read and parse and XML file using the XML data type and it also provide functions to parse the XML and extract its Attribute and Tag values.
21 May 2018 21 May 2018 2 Comments  24007 Views
Here Mudassar Ahmed Khan has explained with an example, how to read, parse and insert XML String data to SQL Server Table using Stored Procedure.

SQL Server 2005 and above versions, allow to pass a parameter of XML data type to the Stored Procedure and provide functions to parse the XML and extract its Attribute and Tag values.
21 Apr 2018 21 Apr 2018 0 Comments  3193 Views
Here Mudassar Ahmed Khan has explained with an example, how to perform Search in Entity Framework without using LINQ with C# and VB.Net.
21 Apr 2018 21 Apr 2018 0 Comments  6396 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement Search functionality in GridView using Entity Framework in ASP.Net with C# and VB.Net.
31 Jan 2018 31 Jan 2018 0 Comments  13804 Views
Here Mudassar Ahmed Khan has explained with an example, how to display Empty (No records found) message in WebGrid when no data in ASP.Net MVC Razor.

The Empty (No records found) message will be displayed with the help of jQuery in ASP.Net MVC Razor.
31 Jan 2018 31 Jan 2018 0 Comments  13636 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement Search functionality in WebGrid with Paging in ASP.Net MVC Razor.

The Search functionality in WebGrid with Paging will be implemented using Stored Procedure and Entity Framework in ASP.Net MVC Razor.
30 Jan 2018 30 Jan 2018 0 Comments  6764 Views
Here Mudassar Ahmed Khan has explained with an example, how to populate (bind) WebGrid using Stored Procedure and Entity Framework in ASP.Net MVC Razor.

The Stored Procedure will be called by passing the parameter value using Entity Framework in ASP.Net MVC 5 Razor.
30 Jun 2017 30 Jun 2017 0 Comments  25401 Views
Here Mudassar Ahmed Khan has explained with an example, how to display (show) data in GridView when Button is clicked in ASP.Net using C# and VB.Net.
When the Button is clicked, the data will be fetched from database and then will be displayed in GridView in ASP.Net using C# and VB.Net.
13 Feb 2017 13 Feb 2017 0 Comments  16647 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement Search functionality using Entity Framework in ASP.Net MVC 5 Razor.
The Search functionality will be implemented using a Stored Procedure which will be called by passing the parameter value using Entity Framework in ASP.Net MVC 5 Razor.
13 Feb 2017 13 Feb 2017 0 Comments  12883 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement Searching using Entity Framework in ASP.Net MVC 5 Razor.
The Search functionality will be implemented using a Stored Procedure which will be called by passing the parameter value using Entity Framework in ASP.Net MVC 5 Razor.
25 Jan 2017 25 Jan 2017 0 Comments  70740 Views
Here Mudassar Ahmed Khan has explained with an example, how to implement Search functionality using Entity Framework in ASP.Net MVC 5 Razor.
The Search functionality will be implemented using a Stored Procedure which will be called by passing the parameter value using Entity Framework in ASP.Net MVC 5 Razor.
24 Jan 2017 24 Jan 2017 1 Comments  109261 Views
Here Mudassar Ahmed Khan has explained a simple tutorial with an example, how to call Stored Procedure using Entity Framework in ASP.Net MVC 5 Razor.
The Stored Procedure will be called by passing the parameter value using Entity Framework in ASP.Net MVC 5 Razor.
Results 21 - 40 of 73