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

Articles: 24, 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: 45,398 Bookmarked: 44 Downloaded: 1,530 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: 521,852 Bookmarked: 79 Downloaded: 42,443 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: 338,401 Bookmarked: 50 Downloaded: 22,355 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: 174,041 Bookmarked: 48 Downloaded: 2,083 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: 155,642 Bookmarked: 43 Downloaded: 1,916 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: 279,373 Bookmarked: 52 Downloaded: 2,123 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: 812,934 Bookmarked: 61 Downloaded: 4,607 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: 623,050 Bookmarked: 70 Downloaded: 3,356 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: 280,327 Bookmarked: 179 Downloaded: 3,393 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: 69,521 Bookmarked: 29 Downloaded: 369 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: 67,481 Bookmarked: 56 Downloaded: 817 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,421 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: 34,890 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: 281,130 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: 106,865 Bookmarked: 21 Downloaded: 773 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: 128,623 Bookmarked: 29 Downloaded: 2,709 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: 147,854 Bookmarked: 39 Downloaded: 1,556 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: 144,217 Bookmarked: 64 Downloaded: 1,561 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: 62,790 Bookmarked: 35 Downloaded: 3,744 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: 174,048 Bookmarked: 18 Downloaded: 956 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: 32,313 Bookmarked: 32 Downloaded: 347 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: 236,934 Bookmarked: 55 Downloaded: 2,200 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: 526,079 Bookmarked: 50 Downloaded: 4,914 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: 48,262 Bookmarked: 44 Downloaded: 1,975 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: 80,970 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,287 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: 6,403 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: 81,835 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,061 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: 76,834 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: 63,103 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:

No projects have been posted.

Brian C Hart

Team Leader

United States

Brian C. Hart, Ph.D., is a strategic engagement leader on a mission to leverage space technology to protect U.S. interests and assets against adversaries. Throughout Dr. Hart's career, he has enjoyed: Working closely with business executives to provide strategic direction and leadership, translating customer and competitive intelligence into compelling capture strategies and solutions, and mentoring teams to enhance individual and company capabilities while fostering an engaging and accountable environment, being involved in STEAM initiatives and education to develop greater awareness in the community, and serving the armed forces with the U.S. Navy and U.S. Army National Guard. He is excited to begin developing his career in Jacobs's Critical Mission Systems business unit, supporting NORAD and the U.S. Space Force.

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

Articles: 24, Tip/Tricks: 7

Average article rating: 4.37

Database Development

Desktop Programming

Productivity Apps and Services

Programming Languages

Web Development