ASPSnippets.com
Category - Stored Procedures
Results 1 - 5 of 42
22 Jun 2018 22 Jun 2018 0 Comments  32 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  34 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 0 Comments  320 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  242 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  277 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.
Results 1 - 5 of 42