T-SQL: Subquery with Sum

Please see my other Database Development articles. Performing a subquery while Sum-ming a column In this article I will demonstrate how to use a subquery with SUM() to return parent records and related child records while aggregating currency amounts. First, I’ll start with a a couple customer records, each with two order records with a…

Telerik: Display Dynamic Instructions

Please see my other Telerik articles. Displaying instructions dynamically to save space In this article I’ll demonstrate how to use Telerik’s Window control to dynamically display instructions in a popup window. Using a dynamically-displayed windows allows the instructions to remain hidden until the user requires them, saving valuable screen real estate. First, I’ll define my…

AJAX

Please see my other Web articles. This page demonstrates some of my AJAX skills in delivering server-side functionality to the client. AJAX Dropdown Update Table

Telerik: Dropdown with Template

Please see my other Telerik articles. Displaying dropdown choices with special formatting In this article I’ll demonstrate how to create a Telerik dropdown using templates to display data in a tabular format. First, I’ll create a ViewModel to serve as the data layer. Note: Ensure you’ve decorated the CustomerID property with the [Key] attribute or…

Telerik UI for ASP.NET MVC

Please see my other Web articles. This page demonstrates some of Telerik’s impressive suite of rich controls designed to empower users, increase productivity and streamline business processes. Telerik UI for ASP.NET MVC Display Dynamic Instructions Dropdown Filter on Multiple Columns Dropdown with Custom Date Format Dropdown with Template Grid-Dropdown Column Filter Grid-Display Success/Failure Notification Grid-Dropdown…

OOP: Abstract Classes vs Interfaces

Please see my other Object-Oriented Programming (OOP) articles. Knowing How to Leverage Abstractions Topic Abstract classes Interfaces Implementation details: Some members (methods). No. Fields: Yes No. Inherit from: Abstract class, interface Interface only. Members can have access modifiers: Yes. Abstract members private by default. No. Interface members public by default. Implementation Details: Abstract Classes As…

OOP: Polymorphism

Please see my other Object-Oriented Programming (OOP) articles. Leveraging the power of Object-Oriented Programming with Polymorphism Related to inheritance, polymorphism illustrates a powerful advantage OOP over procedural programming. It allows classes created to standardize attributes and behaviors, or provide a consistent interface for objects to later use when instantiated. The example below demonstrates a common…

JavaScript

Please see my other Web articles. JAVASCRIPT Changing a CSS class Classes Functions Knockout: Computed fields Knockout: Edit fields Knockout: Input Fields Knockout: Updating the ViewModel Get RadioButtonList Selection JQuery: Date Input JQuery: Toggle Radiobutton Choices Scroll User Toggling RadioButton Choices