Free Asp.Net,MVC,AngularJs,Jquery,Javascript,Sql Server,WCF,Entity framework snippets and tutorial

How to implement pagination and sorting with Angular UI Grid in MVC application

In this article I m going to explain how to implement pagination and sorting with Angular UI Grid in MVC application.

How to implement pagination and sorting with Angular UI Grid in MVC application


Description:
In last article of UI grid I have explained how to display records. Now I want to sort the data ascending and descending order and implement pagination. For pagination you have to set page size and enable the sorting as
            paginationPageSizes: [5, 10, 15],
            paginationPageSize: 5,
            enableSorting: true, 
Sql server query to get exact DOB in Years, months and days

Sql server query to get exact DOB in Years, months and days

In this article I am going to explain how to get date of birth (DOB) in years, months and days format in Sql server.


Sort and filter Grid using AngularJs in MVC

Here in this article I am going to explain how to sort and search the data in grid and also highlight the searched matched text using Angularjs in MVC application.

Sort and filter Grid using AngularJs in MVC


Description:
I am displaying the data in table using ng-repeat. I want to sort and search the data in grid also highlight the searched text results. 

AngularJs: Search and highlight matched text in MVC application

Here in this article I am going to explain how to search and highlight the matched text using Angularjs in MVC application.

AngularJs: Search and highlight matched text in MVC application


Description:
I am displaying the data in table using ng-repeat. I want to highlight the searched text results.

Implementation:
Sql Server: Calculate Age in years from Date of Birth (DOB)

Sql Server: Calculate Age in years from Date of Birth (DOB)

In this article I am going to explain how to calculate the age in years from given Date of Birth in Sql.


Implementation:

You can calculate the age from DOB using below given methods:
AngularJs: Show default image with asp.net mvc

AngularJs: Show default image with asp.net mvc

In this article I am going to explain how to show default image if image is missing or not uploaded using angularjs with asp.net mvc.


Description:
I am displaying the employees detail like name, phone number, email, profile pic etc. in Grid using ng-repeat. If users do not upload profile pic or missing, in that case show default image.

Implementation: