Tutorials - C#, WPF, ASP.NET MVC, WCF, Entity Framework, AngularJS and MVVM Frameworks - MVVM Light - DotNetPattern.com

SQL Server Interview Questions Series - Part 2

22. What is SQL Server Trigger? A trigger is a special stored procedure which automatically executes when you execute any insert, update, or delete commands on table or view. 23. Can we execute a Trigger directly? No 24. How many types of Triggers available in SQL Server? There are two types of Triggers: Instead-of Trigger After Trigge...

Continue Reading

SQL Server Interview Questions Series - Part 1

1. What is SQL Temporary Table? A temporary table is a table which developer creates at runtime only for the scope of a query or for the scope of the connection. You can do all CRUD operations on the table. There are two kinds of temporary tables: a. Local temporary table b. Global temporary table Local temporary table: This table is available only ...

Continue Reading

SQL Server Interview Questions Series - Part 3

43. What is the function name for getting the current date in SQL Server? We can use GETDATE() with SELECT statement for getting the current date. SELECT GetDate() 44. Print the name of distinct employee whose date of birth is between 01/01/1950 to 12/31/1970. SELECT DISTINCT Name FROM Employee WHERE DOB BETWEEN '01/01/1950' AND '12/31/1970'...

Continue Reading

C# Reflection Introduction

Reflection in C# is a big topic in itself. I'll summarize a little list of what you can do with reflection. Get currently executing assembly, load assembly, get assembly from type Get classes declared in assemblies Get methods, properties, fields, events, constructors declared in classes Check access modifiers of classes, properties, fields and me...

Continue Reading

WPF Architecture

WPF is a successor of Windows Forms. Earlier Windows Forms uses the Windows Graphics Device Interface (GDI+) for rendering any graphics, and drawing text. WPF is a new framework for developing rich Windows smart client applications that uses the DirectX technology behind the scene. WPF is resolution-independent because WPF uses vector graphics for drawing the controls on the sc...

Continue Reading

WPF BackgroundWorker

To build more responsive WPF UI, we have to use multiple threads that can work in the background and update the UI when the work completed. But background threads can't access the objects created in the STA. Then how can we update the UI when the background threads completed their work?  WPF applications are based on Single Threaded Apartment Model (STA). Ob...

Continue Reading

WPF ComboBox - Tooltip for each item

Many readers ask me a question regarding how we can add a tooltip for each item of ComboBox in WPF. Here I am presenting a very simple solution. In the below example, I am creating a simple combobox. ComboBox DataTemplate defines a ListBoxItem for each item in combobox. ListBoxItem has both Content and Tooltip property.  As we cannot use String.Format in Tooltip bi...

Continue Reading

WPF DataGrid - Auto Generate Columns

AutoGenerateColumns property automatically generate columns for display in UI from the bounded data source. It takes every public property in bounded data source to generate columns. For example, if you bind to below Employee class to DataGrid: public class Employee { protected int Property1 { get; set; } private int Property2 { get; set; } static int Propert...

Continue Reading

WPF DataGrid - Common Tasks

Table of Contents Change WPF DataGrid Selected Row Background Color WPF DataGrid Select All Checkbox Change Alternate Row Background Color Change the order (Reorder) of Auto Generated Columns Set Auto Generated Column ReadOnly Change WPF DataGrid Selected Row Background Color To change the background color of selected row of WPF DataGrid, you have two ...

Continue Reading

WPF DataGrid - Custom Columns

In the last tutorial AutoGenerateColumns, I have shown how DataGrid automatically shows different columns based on the data types of data. But by using the Columns property, you can change how columns are generated and of which control. By default, WPF provides 5 different types of custom columns shown below: Column Type Display Da...

Continue Reading

Join our newsletter and get an occasional email with a technology and DotNetPattern.com news update.