Articles by Brian C Hart (Articles: 24, Project: 1, Tip/Tricks: 7)

Articles: 24, Project: 1, Tip/Tricks: 7

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating: 4.37

Database Development
SQL Server	Walkthrough: Filtering and Updating in an N-Tier Data Application 15 Jan 2009 Updated: 15 Jan 2009 Rating: 4.47/5 Votes: 7 Popularity: 3.77 Licence: CPOL Views: 46,238 Bookmarked: 44 Downloaded: 1,536 Please Sign up or sign in to vote. Builds on the Microsoft N-Tier Data Application walkthrough to add filtering and updating features.
	HowTo: Install the Northwind and Pubs Sample Databases 23 Oct 2007 Updated: 18 Oct 2013 Rating: 4.44/5 Votes: 80 Popularity: 8.32 Licence: CPOL Views: 533,642 Bookmarked: 79 Downloaded: 42,739 Please Sign up or sign in to vote. To save you from hunting through the docs and locating downloads, we gather both databases here and walk you through installing them using SQL Server Management Studio Express.
	HowTo: Install the Northwind and Pubs Sample Databases in SQL Server 2008 Express 4 Oct 2009 Updated: 18 Oct 2013 Rating: 4.95/5 Votes: 44 Popularity: 8.04 Licence: CPOL Views: 349,332 Bookmarked: 50 Downloaded: 22,388 Please Sign up or sign in to vote. To save you from hunting through the docs and locating downloads, we gather both databases here and walk you through installing them using SQL Server Management Studio Express -- updated for SQL Server 2008 Express Edition!
Desktop Programming
ATL	DCOM D-Mystified: A DCOM Tutorial, Step 3 6 Aug 2000 Updated: 11 Aug 2000 Rating: 4.86/5 Votes: 7 Popularity: 4.10 Licence: CPOL Views: 176,041 Bookmarked: 48 Downloaded: 2,088 Please Sign up or sign in to vote. In this step we add a simple COM object to our server using the New ATL Object Wizard.
	DCOM D-Mystified: A DCOM Tutorial, Step 4 6 Aug 2000 Updated: 11 Aug 2000 Rating: 5.00/5 Votes: 5 Popularity: 3.49 Licence: CPOL Views: 158,182 Bookmarked: 43 Downloaded: 1,921 Please Sign up or sign in to vote. Here we add a method to our DCOM-remoted object, and start on implementing its functionality.
	DCOM D-Mystified: A DCOM Tutorial, Step 5 6 Aug 2000 Updated: 11 Aug 2000 Rating: 5.00/5 Votes: 9 Popularity: 4.77 Licence: CPOL Views: 286,553 Bookmarked: 52 Downloaded: 2,130 Please Sign up or sign in to vote. We look at connection points and set up the server's end of one. We'll also finish implementing our SayHello() method.
	DCOM D-Mystified: A DCOM Tutorial, Step 7 6 Aug 2000 Updated: 21 Dec 2003 Rating: 4.92/5 Votes: 41 Popularity: 7.77 Licence: GPL3 Views: 851,986 Bookmarked: 61 Downloaded: 4,624 Please Sign up or sign in to vote. At last! We finish our tutorial by writing a client with MFC, AppWizard, and ClassWizard, like back in the good ol' days (sighhh...)
	DCOM D-Mystified: A DCOM Tutorial, Step 6 6 Aug 2000 Updated: 8 May 2005 Rating: 5.00/5 Votes: 15 Popularity: 5.88 Licence: CPOL Views: 641,600 Bookmarked: 71 Downloaded: 3,366 Please Sign up or sign in to vote. We build our new server and install it on the server machine.
	DCOM D-Mystified: A DCOM Tutorial, Step 1 3 Aug 2000 Updated: 9 Jan 2006 Rating: 4.80/5 Votes: 26 Popularity: 6.72 Licence: CPOL Views: 285,198 Bookmarked: 179 Downloaded: 3,411 Please Sign up or sign in to vote. This tutorial shows you how to write DCOM software, with all the latest features, in a simple, straightforward manner.
	DCOM D-Mystified.NET 2003: A DCOM Tutorial, Step 5 30 Dec 2005 Updated: 6 Jan 2009 Rating: 3.41/5 Votes: 12 Popularity: 3.68 Licence: CPOL Views: 71,481 Bookmarked: 29 Downloaded: 372 Please Sign up or sign in to vote. We look at connection points, and set up the server's end of one, for our simple DCOM "Hello, World!" server.
	DCOM D-Mystified.NET 2003: A DCOM Tutorial, Step 1 28 Dec 2005 Updated: 7 Jan 2009 Rating: 4.56/5 Votes: 13 Popularity: 4.74 Licence: CPOL Views: 68,541 Bookmarked: 56 Downloaded: 818 Please Sign up or sign in to vote. This tutorial guides you through the step-by-step details of how to use Visual Studio .NET 2003 to develop DCOM client/server applications.
	DCOM D-Mystified.NET 2003: A DCOM Tutorial, Step 2 28 Dec 2005 Updated: 7 Jan 2009 Rating: 4.06/5 Votes: 9 Popularity: 3.87 Licence: CPOL Views: 44,951 Bookmarked: 29 Downloaded: 340 Please Sign up or sign in to vote. We modify starter files provided by the ATL project wizard, to improve user-friendliness and provide security for our server. I also show you how to do a Replace/Replace All across the whole project.
	DCOM D-Mystified.NET 2003: A DCOM Tutorial, Step 4 30 Dec 2005 Updated: 7 Jan 2009 Rating: 2.80/5 Votes: 6 Popularity: 2.18 Licence: CPOL Views: 35,470 Bookmarked: 28 Downloaded: 277 Please Sign up or sign in to vote. Add a method, SayHello(), to the server, that fires the event which the client handles.
	DCOM D-Mystified.NET 2003: A DCOM Tutorial, Step 3 29 Dec 2005 Updated: 7 Jan 2009 Rating: 3.81/5 Votes: 12 Popularity: 4.11 Licence: CPOL Views: 285,580 Bookmarked: 27 Downloaded: 307 Please Sign up or sign in to vote. In this step, we add a simple COM object to our server using the ATL Simple Object wizard. Plus, properly initialize and cleanup your COM objects with FinalConstruct() and FinalRelease().
MFC	A Better CenterWindow() Function 7 Aug 2000 Updated: 3 Oct 2000 Rating: 4.57/5 Votes: 4 Popularity: 2.75 Licence: Not specified Views: 108,485 Bookmarked: 21 Downloaded: 778 Please Sign up or sign in to vote. This is a good replacement for CWnd::CenterWindow() that works.
	Resize MDI Child Frame Windows to Fit Form Views 3 Feb 2001 Updated: 16 Apr 2001 Rating: 4.58/5 Votes: 22 Popularity: 5.75 Licence: Not specified Views: 130,433 Bookmarked: 29 Downloaded: 2,723 Please Sign up or sign in to vote. Make the MDI windows which contain your program's forms snap to match the forms' sizes.
	Center CMDIChildWnds and Other Tips 9 Jun 2000 Updated: 6 Apr 2005 Rating: 4.36/5 Votes: 10 Popularity: 3.94 Licence: Not specified Views: 149,635 Bookmarked: 39 Downloaded: 1,559 Please Sign up or sign in to vote. Center CMDIChildWnds in the client area of the main frame window.
	Lookup and Display Win32/COM Error Strings With One Line of Code 31 Dec 2005 Updated: 31 Dec 2005 Rating: 4.96/5 Votes: 41 Popularity: 7.95 Licence: Not specified Views: 148,077 Bookmarked: 64 Downloaded: 1,569 Please Sign up or sign in to vote. Use compiler COM support (even in non-COM applications) to get a Win32 error code or HRESULT's message in one line of code.
Windows Forms	Custom VisualStudio 2008-style MenuStrip and ToolStrip Renderer in C# 13 Apr 2012 Updated: 1 Apr 2010 Rating: 5.00/5 Votes: 6 Popularity: 3.89 Licence: CPOL Views: 65,361 Bookmarked: 35 Downloaded: 3,789 Please Sign up or sign in to vote. An adaptation of Nick Thissen's article on VBForums translated to C# and bottled up into a Class Library you can just drop into your projects.
	The Sleep() Function in .NET 15 Oct 2007 Updated: 17 Oct 2007 Rating: 1.42/5 Votes: 21 Popularity: 1.66 Licence: Not specified Views: 176,149 Bookmarked: 18 Downloaded: 959 Please Sign up or sign in to vote. Where are your favorite Windows APIs in the .NET Framework? This article points out where the Windows Sleep() function now can be found.
Productivity Apps and Services
Microsoft Office	A Handy-Dandy Little Class for Accessing Excel Worksheet Cells 23 Nov 2010 Updated: 1 Dec 2010 Rating: 3.71/5 Votes: 10 Popularity: 3.71 Licence: CPOL Views: 33,253 Bookmarked: 33 Downloaded: 351 Please Sign up or sign in to vote. A class that accepts a reference to an Excel.Worksheet and lets you use an overloaded subscript operator to cleanly and intuitively read/write the Value2 of Excel cells, and get the Excel.Range corresponding to a given cell.
Programming Languages
C++	DCOM D-Mystified: A DCOM Tutorial, Step 2 5 Aug 2000 Updated: 11 Aug 2000 Rating: 4.79/5 Votes: 10 Popularity: 4.57 Licence: CPOL Views: 239,614 Bookmarked: 55 Downloaded: 2,210 Please Sign up or sign in to vote. We modify starter files, provided by the ATL COM AppWizard, to improve the user-friendliness of our server.
Objective C	DCOM D-Mystified: Questions and Answers 3 Aug 2000 Updated: 11 Aug 2000 Rating: 4.75/5 Votes: 17 Popularity: 5.59 Licence: CPOL Views: 545,430 Bookmarked: 50 Downloaded: 4,939 Please Sign up or sign in to vote. Brian's detailed answers to your most frequently asked questions about his DCOM tutorial.
Web Development
ASP.NET	Walkthrough: Creating an N-tier Data Application with a ASP.NET Presentation Tier 2 Dec 2011 Updated: 2 Dec 2011 Rating: 4.69/5 Votes: 7 Popularity: 3.96 Licence: CPOL Views: 49,022 Bookmarked: 44 Downloaded: 1,978 Please Sign up or sign in to vote. How to create an N-tier Data Application with a ASP.NET Presentation Tier

Average blogs rating:

No blogs have been submitted.

Average tips rating: 4.70

Database Development
SQL Server	Tip: Run a Transact-SQL Script (.SQL File) From the Command Line [Tip/Trick] 22 Dec 2010 Updated: 22 Dec 2010 Rating: 4.75/5 Votes: 9 Popularity: 4.53 Licence: CPOL Views: 83,180 Bookmarked: 9 Downloaded: 0 Please Sign up or sign in to vote. Provides the quick-and-dirty syntax to connect to a given Microsoft SQL Server instance so you can then run a .sql query script against it, e.g., if you are calling this from code as part of a larger pipeline
Desktop Programming
Windows Forms	Tip: Minor Improvements on the DockPanel Suite, Part 1 [Tip/Trick] 6 Jul 2011 Updated: 6 Jul 2011 Rating: 5.00/5 Votes: 3 Popularity: 2.39 Licence: CPOL Views: 22,967 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. This tip shows how to add support for New Horizontal Tab Group and New Vertical Tab Group commands to the Window menu of an application using the DockPanel Suite by Weifen Luo, and some other minor improvements to help decided if at least one of your windows is docked to the side of the main form an
General Programming
String	Regex to Match Version Number Beginning with a Specific Digit [Tip/Trick] 20 Aug 2022 Updated: 20 Aug 2022 Rating: 4.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 9,686 Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. Example of how to use the caret (^) in Regexes that have specific matching requirements
Productivity Apps and Services
Microsoft Office	Import a CSV File Into an Excel Workbook Programmatically [Tip/Trick] 14 Dec 2010 Updated: 19 Dec 2010 Rating: 4.38/5 Votes: 7 Popularity: 3.71 Licence: CPOL Views: 84,025 Bookmarked: 12 Downloaded: 0 Please Sign up or sign in to vote. Code to call Excel Interop to take a Comma-Separated-Values (.CSV) file and suck it into your Excel workbook programmatically, and then Auto-Fit the resultant columns.
	Tip: Perform a Merge and Center With Excel Automation [Tip/Trick] 13 Dec 2010 Updated: 19 Dec 2010 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 33,901 Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. You know that little "Merge and Center" button in Microsoft Excel? Here's how to 'click' it in C# with Excel Interop (and this carries over to VB etc, too).
	Tip: Format an Excel Range as a Table Programatically [Tip/Trick] 16 Dec 2010 Updated: 26 Aug 2011 Rating: 5.00/5 Votes: 6 Popularity: 3.89 Licence: CPOL Views: 79,234 Bookmarked: 10 Downloaded: 0 Please Sign up or sign in to vote. C# code to format a certain range of Excel cells using the Format As Table button -- but from C# interop code
Programming Languages
C#	Find Prime Numbers in C# Using the Sieve of Eratosthenes [Tip/Trick] 19 Jul 2011 Updated: 3 Oct 2011 Rating: 4.80/5 Votes: 5 Popularity: 3.36 Licence: CPOL Views: 64,803 Bookmarked: 8 Downloaded: 0 Please Sign up or sign in to vote. This tip illustrates a simple C# console program that uses the Sieve of Eratosthenes algorithm to quickly find prime numbers.

Average reference rating:

No reference articles have been posted.

Average project rating: 3.40

Fast Search and Replace in Large Number of Files: A Practical Guide [Project]

8 May 2024 Updated: 8 May 2024 Rating: 3.40/5 Votes: 3 Popularity: 1.62

Licence: GPL3 Views: 1,370 Bookmarked: 1 Downloaded: 17

This is a guide, written at an intermediate level, to performing high-speed search and replace operations across thousands of files in C# using advanced techniques such as memory-mapped files, asynchronous processing, and user-friendly interfaces with modal progress dialogs.

Brian C Hart

Team Leader

United States

Dr. Brian Hart obtained his Ph.D. in Astrophysics from the University of California, Irvine in 2008. Under Professor David Buote, Dr. Heart researched the structure and evolution of the universe. Dr. Hart is currently employed as a Astrodynamicist / Space Data Scientist with Point Solutions Group in Colorado Springs, CO supporting Space Operations Command, United States Space Force. Dr. Hart is a Veteran of the U.S. Army and the U.S. Navy, having most recently served at Fort George G. Meade, MD as a Naval Officer with a Cyber Warfare Engineer designator. Dr. Hart has previously held positions at Jacobs Engineering supporting Cheyenne Mountain/Space Force supporting tests, with USSPACECOM/J58 supporting operators using predictive AI/ML with Rhombus Power, and with SAIC supporting the Horizon 2 program at STARCOM. Dr. Hart is well known to the community due to his over 150 technical publications and public speaking events. Originally from Minneapolis/Saint Paul, Minnesota, Dr. Hart lives in Colorado Springs with his Black Lab, Bruce, and likes bowling, winter sports, exploring, and swimming. Dr. Hart has a new movie coming out soon, which is a documentary called "Galaxy Clusters: Giants of the Universe," about his outer space research. The movie showcases the Chandra X-ray Observatory, one of NASA’s four great observatories and the world’s most powerful telescopes for detecting X-rays. The movie has been accepted for screening at the USAFA Planetarium and will highlight the need of updating and maintaining X-ray telescopes for scientific advancement.

Articles by Brian C Hart (Articles: 24, Project: 1, Tip/Tricks: 7)

Articles: 24, Project: 1, Tip/Tricks: 7

Average article rating: 4.37

Database Development

Desktop Programming

Productivity Apps and Services

Programming Languages

Web Development