Synchronized RichTextBox objects (or how to scroll 2 RichTextBox objects together)

In my previous posts I have described, how to create synchronized (or linked) ListBox and ListView objects. Now I continue in investigation in this area and I have found another interesting example which describes synchronization of two RichTextBox objects. First step is to create class which derives from RichTextBox class.

public class SynchronizedScrollRichTextBox : System.Windows.Forms.RichTextBox
{
    public event vScrollEventHandler vScroll;
    public delegate void vScrollEventHandler(System.Windows.Forms.Message message);

    public const int WM_VSCROLL = 0x115;

    protected override void WndProc(ref System.Windows.Forms.Message msg)
    {
        if (msg.Msg == WM_VSCROLL)
        {
            if (vScroll != null)
            {
                vScroll(msg);
            }
        }
        base.WndProc(ref msg);
    }

    public void PubWndProc(ref System.Windows.Forms.Message msg)
    {
        base.WndProc(ref msg);
    }
}

I have created two SynchronizedScrollRichTextBox controls and placed them on the form. Then I have added following code (vScroll event):

private void synchronizedScrollRichTextBox1_vScroll(Message message)
{
    message.HWnd = synchronizedScrollRichTextBox2.Handle;
    synchronizedScrollRichTextBox2.PubWndProc(ref message);
}

Here you can find original post.

Synchronized ListView objects (or how to scroll 2 ListView objects together)

In my previous post I have described how to synchronize two ListBox objects. Here I will show, how to synchronize two ListView objects.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Runtime.InteropServices;

namespace SyncLists
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            this.listView1.View = View.Details;
            this.listView2.View = View.Details;
            for (int j = 0; j < 10; j++)
            {
                this.listView1.Columns.Add("c" + j.ToString());
                this.listView2.Columns.Add("c" + j.ToString());
            }
            for (int j = 0; j < 300; j++)
            {
                ListViewItem item = new ListViewItem("item" + j.ToString());
                for (int k = 1; k < 10; k++)
                {
                    item.SubItems.Add("sub item" + k.ToString());
                }
                this.listView1.Items.Add(item);
                this.listView2.Items.Add(item.Clone() as ListViewItem);
            }

            this.listView1.Scroll += new ListViewEx.ScrollHandler(listView1_Scroll);
        }

        [DllImport("user32.dll")]
        static extern IntPtr SendMessage(IntPtr hWnd, int Msg, IntPtr wParam, IntPtr lParam);
        [DllImport("user32.dll")]
        static extern int SetScrollPos(IntPtr hWnd, int nBar, int nPos, bool bRedraw);

        private const int WM_HSCROLL = 0x114;
        private const int WM_VSCROLL = 0x115;
        private const int SBS_HORZ = 0;
        private const int SBS_VERT = 1;

        void listView1_Scroll(object sender, MyScrollEventArgs e)
        {
            ListViewEx listVw = sender as ListViewEx;

            Int16 hi = (Int16)((int)e.WParam >> 16);//position
            Int16 lo = (Int16)e.WParam;//scroll type

            if (e.Orientation == ScrollOrientation.VerticalScroll)
            {
                if (lo == 5) //SB_THUMBTRACK
                {
                    if (SetScrollPos(this.listView2.Handle, SBS_VERT, hi, true) != 0)
                    {
                        SendMessage(this.listView2.Handle, WM_VSCROLL,
                          (IntPtr)(4 + 0x10000 * hi), IntPtr.Zero);
                    }
                }
                else
                {
                    SendMessage(this.listView2.Handle, WM_VSCROLL, e.WParam, IntPtr.Zero);
                }
            }
            if (e.Orientation == ScrollOrientation.HorizontalScroll)
            {
                if (lo == 5)//SB_THUMBTRACK
                {
                    SetScrollPos(this.listView2.Handle, SBS_HORZ, hi, true);
                    SendMessage(this.listView2.Handle, WM_HSCROLL,
                       (IntPtr)(4 + 0x10000 * hi), IntPtr.Zero);
                }
                else
                {
                    SendMessage(this.listView2.Handle, WM_HSCROLL, e.WParam, IntPtr.Zero);
                }
            }
        }

    }

    public class ListViewEx : ListView
    {
        public delegate void ScrollHandler(object sender, MyScrollEventArgs e);
        public event ScrollHandler Scroll;
        public void OnScroll(MyScrollEventArgs e)
        {
            if (Scroll != null)
            {
                Scroll(this, e);
            }
        }

        private const int WM_HSCROLL = 0x114;
        private const int WM_VSCROLL = 0x115;

        protected override void WndProc(ref Message m)
        {
            if (m.Msg == WM_VSCROLL)
            {
                MyScrollEventArgs e = new MyScrollEventArgs();
                e.WParam = m.WParam;
                e.Orientation = ScrollOrientation.VerticalScroll;
                OnScroll(e);
            }
            if (m.Msg == WM_HSCROLL)
            {
                MyScrollEventArgs e = new MyScrollEventArgs();
                e.WParam = m.WParam;
                e.Orientation = ScrollOrientation.HorizontalScroll;
                OnScroll(e);
            }
            base.WndProc(ref m);
        }
    }

    public class MyScrollEventArgs : EventArgs
    {
        private ScrollOrientation orientation;
        private IntPtr wParam;

        public IntPtr WParam
        {
            get { return wParam; }
            set { wParam = value; }
        }

        public ScrollOrientation Orientation
        {
            get { return orientation; }
            set { orientation = value; }
        }
    }
}

Synchronized ListBox objects (or how to scroll 2 ListBox objects together)

Before couple of days I had a task where I must synchronize two ListBox objects. I have fount out, that ListBox object doesn't have any property which allow to accomplish this. After a few hours of googling I found code of class that inherited from ListBox class. Here is the code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.ComponentModel;
using System.Runtime.InteropServices;
namespace SyncLists
{
    class SyncListBox : System.Windows.Forms.ListBox
    {
        [Category("Action")]

        private const int WM_HSCROLL = 0x114;
        private const int WM_VSCROLL = 0x115;

        public event ScrollEventHandler OnHorizontalScroll;
        public event ScrollEventHandler OnVerticalScroll;


        private const int SB_LINEUP = 0;
        private const int SB_LINELEFT = 0;
        private const int SB_LINEDOWN = 1;
        private const int SB_LINERIGHT = 1;
        private const int SB_PAGEUP = 2;
        private const int SB_PAGELEFT = 2;
        private const int SB_PAGEDOWN = 3;
        private const int SB_PAGERIGHT = 3;
        private const int SB_THUMBPOSITION = 4;
        private const int SB_THUMBTRACK = 5;
        private const int SB_PAGETOP = 6;
        private const int SB_LEFT = 6;
        private const int SB_PAGEBOTTOM = 7;
        private const int SB_RIGHT = 7;
        private const int SB_ENDSCROLL = 8;

        private const int SIF_TRACKPOS = 0x10;
        private const int SIF_RANGE = 0x1;
        private const int SIF_POS = 0x4;
        private const int SIF_PAGE = 0x2;
        private const int SIF_ALL = SIF_RANGE | SIF_PAGE | SIF_POS | SIF_TRACKPOS;

        [DllImport("user32.dll", SetLastError = true)]
        private static extern int GetScrollInfo(
        IntPtr hWnd, int n, ref ScrollInfoStruct lpScrollInfo);


        private struct ScrollInfoStruct
        {
            public int cbSize;
            public int fMask;
            public int nMin;
            public int nMax;
            public int nPage;
            public int nPos;
            public int nTrackPos;
        }

        protected override void WndProc(ref System.Windows.Forms.Message msg)
        {
            if (msg.Msg == WM_HSCROLL)
            {
                if (OnHorizontalScroll != null)
                {
                    ScrollInfoStruct si = new ScrollInfoStruct();
                    si.fMask = SIF_ALL;
                    si.cbSize = Marshal.SizeOf(si);
                    GetScrollInfo(msg.HWnd, 0, ref si);

                    if (msg.WParam.ToInt32() == SB_ENDSCROLL)
                    {
                        ScrollEventArgs sargs = new ScrollEventArgs(
                        ScrollEventType.EndScroll,
                        si.nPos);
                        OnHorizontalScroll(this, sargs);
                    }
                }
            }
            if (msg.Msg == WM_VSCROLL)
            {
                if (OnVerticalScroll != null)
                {
                    ScrollInfoStruct si = new ScrollInfoStruct();
                    si.fMask = SIF_ALL;
                    si.cbSize = Marshal.SizeOf(si);
                    GetScrollInfo(msg.HWnd, 0, ref si);

                    if (msg.WParam.ToInt32() == SB_ENDSCROLL)
                    {
                        ScrollEventArgs sargs = new ScrollEventArgs(
                        ScrollEventType.EndScroll,
                        si.nPos);
                        OnVerticalScroll(this, sargs);
                    }
                }
            }
            base.WndProc(ref msg);
        }


        private void InitializeComponent()
        {
            this.SuspendLayout();
            // 
            // scrolled
            // 
            this.Size = new System.Drawing.Size(120, 95);
            this.ResumeLayout(false);
        }
    }
}

add two SyncListBox objects on the form and add following code:

private void syncListView2_OnVerticalScroll(object sender, ScrollEventArgs e)
{
    syncListView1.TopIndex = syncListView2.TopIndex;
}

private void syncListView1_OnVerticalScroll(object sender, ScrollEventArgs e)
{
    syncListView2.TopIndex = syncListView1.TopIndex;
}

T-SQL - Find which Object resides in which FileGroup

Select Distinct OBJECT_NAME(SI.object_id) AS ObjectName
,OBJECTPROPERTYEX(SI.object_id,'BaseType') AS ObjectType
,FG.Name AS FileGroupName
from sys.indexes SI , sys.filegroups FG
where SI.data_space_id = FG.data_space_id
Order by ObjectName

Measure execution time in C#

Sometimes developers need to measure execution time of task. This methodics could be useful when is important to compare two or more approaches and choose the best. .Net Framework contains Stopwatch class that can measure elapsed time for one interval, or total elapsed time across multiple intervals.
For more information navigate to: Stopwatch Class.

Following example demonstrates how to use Stopwatch Class to determine execution time for an application. Using this example you can see differences in efficiency by calling Contains method of StringCollection and HashTable.

Hashtable hs = new Hashtable();
StringCollection sc = new StringCollection();
            
for (int i = 0; i < int.MaxValue/1000; i++)
{
    hs.Add(i.ToString(), i);
    sc.Add(i.ToString());
}

Random rnd = new Random();
Stopwatch timer = new Stopwatch();

int val = rnd.Next(int.MaxValue / 1000);

timer.Start();
if (sc.Contains(val.ToString()))
{
    Console.WriteLine("Contains");
}
timer.Stop();

Console.WriteLine(timer.ElapsedTicks);
timer.Reset();

timer.Start();
if (hs.Contains(val.ToString()))
{
    Console.WriteLine("Contains");
}
timer.Stop();

Console.WriteLine(timer.ElapsedTicks);

MCTS .NET Application Development Foundation - 70-536 – Objectives List Part 7 (Implementing globalization, drawing, and text manipulation functionality in a .NET Framework application)

Format data based on culture information.

• Globalizing and Localizing Applications
  
  • Introduction to International Applications Based on the .NET Framework
  • Encoding and Localization
  • Localizing Applications
  • Globalizing Applications
  • Bi-directional Language Features in Visual Studio
• CultureInfo Class
• Using the CultureInfo Class
• RegionInfo Class
• Names Associated with a RegionInfo Object
• CultureTypes Enumeration
• Formatting Date and Time for a Specific Culture
• DateTimeFormatInfo Class
• Formatting Numeric Data for a Specific Culture
• NumberFormatInfo Class
• NumberStyles Enumeration
• Comparing and Sorting Data for a Specific Culture
• CompareInfo Class
• CompareOptions Enumeration
• How to: Create Custom Cultures
• How to Save Custom Cultures Without Administrative Privileges
• CultureAndRegionInfoBuilder Class
• CultureAndRegionModifiers Enumeration

Enhance the user interface of a .NET Framework application by using brushes, pens, colors, and fonts.

• Brush class
• Brushes class
• SystemBrushes class
• TextureBrush class
• Pen class
• Pens class
• SystemPens class
• SolidBrush class
• Color structure
• ColorConverter class
• ColorTranslator class
• SystemColors class
• StringFormat class
• Font class
• FontConverter class
• FontFamily class
• SystemFonts class

Enhance the user interface of a .NET Framework application by using graphics, images, bitmaps, and icons.

• Graphics class
• BufferedGraphics class
• BufferedGraphicsManager class
• Image class
• ImageConverter class
• ImageAnimator class
• Bitmap class
• Icon class
• IconConverter class
• SystemIcons class

Enhance the user interface of a .NET Framework application by using shapes and sizes.

• Point Structure
• PointConverter class
• Rectangle Structure
• RectangleConverter class
• Size Structure
• SizeConverter class
• Region class

Enhance the text handling capabilities of a .NET Framework application (refer System.Text namespace), and search, modify, and control text in a .NET Framework application by using regular expressions.

• Basic String Operations
  
  • Creating New Strings
  • Trimming and Removing Characters
  • Padding Strings
  • Comparing Strings
  • Changing Case
  • Using the StringBuilder Class
  • How to: Perform String Manipulations by Using Basic String Operations
• .NET Framework Regular Expressions
  
  • Regular Expressions as a Language
  • Regular Expression Language Elements
  • Regular Expression Classes
  • Details of Regular Expression Behavior
  • Regular Expression Examples
• StringBuilder class
• Regex class
• Match class
• MatchCollection class
• Group class
• GroupCollection class
• Encode text by using Encoding classes
  
  • Encoding class
  • EncodingInfo class
  • ASCIIEncoding class
  • UnicodeEncoding class
  • UTF8Encoding class
  • Encoding Fallback classes
    
    • EncoderFallback
    • EncoderFallbackBuffer
    • EncoderFallbackException
    • EncoderReplacementFallback
    • EncoderReplacementFallbackBuffer
    • EncoderExceptionFallback
    • EncoderExceptionFallbackBuffer
• Decode text by using Decoding classes.
  
  • Decoder class
  • Decoder Fallback classes
    
    • DecoderFallback
    • DecoderFallbackBuffer
    • DecoderFallbackException
    • DecoderReplacementFallback
    • DecoderReplacementFallbackBuffer
    • DecoderExceptionFallback
    • DecoderExceptionFallbackBuffer
• Capture class
• CaptureCollection class

MCTS .NET Application Development Foundation - 70-536 – Objectives List Part 6 (Implementing interoperability, reflection, and mailing functionality in a .NET Framework application)

Expose COM components to the .NET Framework and the .NET Framework components to COM.

• System.Runtime.InteropServices Namespace
• Interoperability
  
  • Interoperating with Unmanaged Code
  • Advanced COM Interoperability
• Exposing COM Components to the .NET Framework
• Exposing .NET Framework Components to COM
• Importing a Type Library as an Assembly
  
  • How to: Add References to Type Libraries
  • Type Library Importer (Tlbimp.exe)
  • How to: Generate Interop Assemblies from Type Libraries
  • Type Library to Assembly Conversion Summary
    
    • Imported Library Conversion
    • Imported Module Conversion
    • Imported Type Conversion
    • Imported Member Conversion
    • Imported Parameter Conversion
• Create COM types in managed code.
• Compile an interop project.
• Deploy an interop application.
• Qualify the .NET Framework types for interoperation.
• Apply Interop attributes
• ComVisibleAttribute class.
• Package an assembly for COM.
• Deploy an application for COM access.
• TypeConverter Class

Call unmanaged DLL functions in a .NET Framework application, and control the marshaling of data in a .NET Framework application.

• Consuming Unmanaged DLL Functions
• Interop Marshaling
• A Closer Look at Platform Invoke
• Creating a Class to Hold DLL Functions
• Creating Prototypes in Managed Code
  
  • Specifying an Entry Point
  • Specifying a Character Set
  • Platform Invoke Examples
  
  
• How to: Map HRESULTs and Exceptions
• DllImportAttribute Class
• Calling a DLL Function
  
  • Passing Structures
  • Callback Functions
  • How to: Implement Callback Functions
• Default Marshaling Behavior
• Marshaling Data with Platform Invoke
• Marshaling Data with COM Interop
• Marshal Class
• MarshalAsAttribute Class

Implement reflection functionality in a .NET Framework application (refer System.Reflection namespace), and create metadata, Microsoft intermediate language (MSIL), and a PE file by using the System.Reflection.Emit namespace.

• System.Reflection Namespace
• System.Reflection.Emit Namespace
• Reflection
• Emitting Dynamic Methods and Assemblies
  
  • Reflection Emit Abstractions
  • Reflection Emit Dynamic Method Scenarios
  • Reflection Emit Dynamic Assembly Scenarios
  • Reflection Emit Application Scenarios
  • Security Issues in Reflection Emit
  • Using Reflection Emit
  • More Information About Reflection Emit
• Assembly Class
• Assembly attributes
  
  • AssemblyAlgorithmIdAttribute class
  • AssemblyCompanyAttribute class
  • AssemblyConfigurationAttribute class
  • AssemblyCopyrightAttribute class
  • AssemblyCultureAttribute class
  • AssemblyDefaultAliasAttribute class
  • AssemblyDelaySignAttribute class
  • AssemblyDescriptionAttribute class
  • AssemblyFileVersionAttribute class
  • AssemblyFlagsAttribute class
  • AssemblyInformationalVersionAttribute class
  • AssemblyKeyFileAttribute class
  • AssemblyTitleAttribute class
  • AssemblyTrademarkAttribute class
  • AssemblyVersionAttribute class
• Info classes
  
  • ConstructorInfo class
  • MethodInfo class
  • MemberInfo class
  • PropertyInfo class
  • FieldInfo class
  • EventInfo class
  • LocalVariableInfo class
• 
  Binder class
• BindingFlags
• MethodBase class
• MethodBody class
• Builder classes
  
  • AssemblyBuilder class
  • ConstructorBuilder class
  • EnumBuilder class
  • EventBuilder class
  • FieldBuilder class
  • LocalBuilder class
  • MethodBuilder class
  • ModuleBuilder class
  • ParameterBuilder class
  • PropertyBuilder class
  • TypeBuilder class

Send electronic mail to a Simple Mail Transfer Protocol (SMTP) server for delivery from a .NET Framework application.

• MailAddress class
• MailAddressCollection class
• SmtpClient class
• SmtpPermission class
• SmtpPermissionAttribute class
• Attachment class
• AttachmentBase class
• AttachmentCollection class
• SmtpException class
• SmtpFailedRecipientException class
• SendCompletedEventHandler delegate
• LinkedResource class
• LinkedResourceCollection class
• AlternateView class
• AlternateViewCollection class