BlackWasp Latest Additionshttp://www.blackwasp.co.uk/New articles, tips and tricks at the BlackWasp web site.en-uk27 Apr 2016 00:00:00 GMT27 Apr 2016 00:00:00 GMT1440BlackWasphttp://www.blackwasp.co.uk/rss/RSSLogo.png12060http://www.blackwasp.co.uk/Copyright (c)2006-2024 BlackWaspSQL Server NOWAIT Hinthttp://www.blackwasp.co.uk/RSSLanding.aspx?page=SqlNoWaitIn some situations it can be necessary to fail quickly when a query is blocked, rather than wait for locks to be released. This can be achieved simply using the NOWAIT hint.Checking if Types are Compatiblehttp://www.blackwasp.co.uk/RSSLanding.aspx?page=IsAssignableFromSometimes is it necessary to determine if an object of one type can be assigned to a variable of another, this being possible either due to inheritance or because of the implementation of an interface. You can make such determinations using reflection.SQL Server Connection Colourshttp://www.blackwasp.co.uk/RSSLanding.aspx?page=SQLStatusColourSQL Server Management Studio allows multiple concurrent connections to different servers and instances. This can be risky when connecting to live, test and development systems at the same time.Terminating Processeshttp://www.blackwasp.co.uk/RSSLanding.aspx?page=TerminateProcessSometimes it is necessary to terminate a process immediately, or request that an application close normally, possibly with user intervention. Both actions are possible using methods of the Process class.Ungrouping Page Numbershttp://www.blackwasp.co.uk/RSSLanding.aspx?page=PageNumberUngrouperWhen users provide a set of page numbers, or similarly numbered items, it is common to allow the information to be entered as a comma-delimited list. Each item in that list could represent a single page or range of adjacent pages that will need to be converted to a simple list.Page Number Groupinghttp://www.blackwasp.co.uk/RSSLanding.aspx?page=PageNumberGrouperWhen listing page numbers in document indexes or for printing, it is common to group adjacent pages. This article describes a method that creates such groupings from a simple collection of integers.Raising Events Using Reflectionhttp://www.blackwasp.co.uk/RSSLanding.aspx?page=ReflectionRaiseEventsSometimes it is necessary to raise an object's events using reflection. This can be achieved by obtaining the event's multicast delegate and invoking each of its child delegates in turn.WPF Window Start-Up Locationshttp://www.blackwasp.co.uk/RSSLanding.aspx?page=WPFWindowStartupLocationWPF windows can initially be displayed using three positioning options. The location of a window can be set manually, or the new window can be centred on the screen or in relation to its owner.WPF Application Exit Codeshttp://www.blackwasp.co.uk/RSSLanding.aspx?page=WPFExitCodeWhen a program exits, it can return an integer that describes its closing status. Although this is commonly used for command-line utilities, the same system of exit codes can be used by WPF applications.Windows Forms Message Boxeshttp://www.blackwasp.co.uk/RSSLanding.aspx?page=MessageBoxMessage boxes provide a simple, standardised method to display information, warnings and errors to the user. They can also be used to ask simple questions and to request confirmation of actions.