AngularJS is a JavaScript framework for web pages. This is perfect for Single Page Application. It works with HTML by extending the attributes with directives and using expressions. It is developed by Google and this framework is available as a set of Google APIs. The prerequisite of using AngularJS is…
How to Rotate Advertisements using JQuery and ASP NET AdRotator Control
The ASP.NET AdRotator control is a useful control to randomly display advertisements on a webpage. However the ads in the adrotator control are rotated only when the user refreshes the page. In this article, we will use a single line of jQuery code to rotate ads using the adrotator control, at regular…
How to use cookies in ASP.Net
Cookies A cookie is a small bit of text that accompanies requests and pages as they go between the Web server and browser. The cookie contains information the Web application can read whenever the user visits the site. Scenarios: Cookies provide a means in Web applications to store…
How to use caching in ASP.Net
ASP.NET Caching: ASP.NET provides two types of caching that you can use to create high-performance Web applications. 1. The first is output caching, which allows you to store dynamic page and user control responses on any HTTP 1.1 cache-capable device in the output stream, from the originating server to the…
How to Count total number of objects in SQL Server instance
Below query will help you find the list of object counts in the database: SELECT type, total_count = COUNT(*), last_crdate = MAX(crdate), last_refdate = MAX(refdate) FROM ( SELECT type = CASE WHEN xtype = ‘U’ THEN ‘table’ WHEN xtype = ‘V’ THEN ‘view’ WHEN xtype = ‘P’ THEN ‘proc’ WHEN…