Welcome to the Digital Tool Factory blog

Backend web development in Atlanta GA

How to Fix “Cannot Publish Because a Project Failed to Build” error

The Problem: You attempt to publish your C# ClickOnce application in Visual Studio 2010, but you get the “How to Fix “Cannot Publish Because a Project Failed to Build” error” error. There are no syntax errors. The Cause: No idea The Solution: Simply right click on the solution in the Solution Explorer, and click “Publish” […]

How to fix the Asp.net CalendarExtender and CompareValidator to accept European date formats

The Problem: You want to use the standard European Date Format, DD/MM/YYYY instead of the American Date Format MM/DD/YYYY.  You change the “Format” feature of the CalendarExtender to “DD/MM/YYYY”, but then the CompareValidator (which you’re using to ensure valid dates) calls out that you have entered an invalid date. The Cause: The Compare Validator is […]

How to fix the “could not load file or assembly microsoft.sqlserver.batchparser” error

The Problem: Every time you attempt to run Microsoft’s excellent Database Publishing Wizard Utility you get the following error after you enter your login information could not load file or assembly microsoft.sqlserver.batchparser The Cause: This problem can be taken literally – Microsoft.SqlServer.Batchparser is not installed on your computer. The Solution: Go To this link on […]

Exploring the long tail topics of my personal knowledge

One lesson I learned (not from anything specifically said, purely a deduction) from this excellent Mixergy interview with Brian Crane of LuckyGunner.com is to NOT weave  small thoughts into the big picture, but to instead let them be small thoughts. Apparently LuckyGunner.com succeeds by chasing the long tail.  Therefore I am going to keep the “How To […]

How to fix problems with the placeholder control and custom web user controls

The Problem: You are using an asp.net PlaceHolder control and populating it with a collection of custom web controls.  You then get “Null Reference Exception” and “Are you missing an assembly?” errors.  Your code looks much like this foreach (string str in strStringList) { CustomWebBox cb=new CustomWebBox()[ cb.CustomTitle=str; myPlaceHolder.Controls.Add(cb); } The Cause: The same ID’s are […]

Instead of my original thoughts, here are other peoples

Rather, here are some things I’ve been reading MyType study: iPad owners are ‘selfish elites’ The real money in Farmville Windows Phone 7 Dev tools are released Child Up is going through John Medina’s book – Brain Rules For Baby, which does not seem to be coming out on the Kindle. Media Warning Labels   […]

How to Truncate a Table in Sql Server

I hadn’t used this handy tool in sql server in a while and actually had to look it up recently, so here it is in the code review. TRUNCATE TABLE “table_name” Truncating not only deletes all of rows in the table, but it deletes all information about the table, which makes all auto numbering integer […]

The List in C#

The first entry in my Code Review is the List<>. So far, the List is my favorite sort of array in C#.  It has the benefits of being obvious in naming you do not have to know the size when it is declared – the List can expand or contract as needed adding items to […]

Introducing the new Code Review Category

One of the lessons I learned from John Medina’s excellent book Brian Rules is that of elaborative rehearsal, which is (roughly) defined as remembering something more strongly by doing something with the new information, like giving a book report or relating that information back into something you already know.   Example: Say you already know […]

How To Fix Column Doubling in an ASP.net GridView – with Code Sample

The Problem: You are trying to create an ASP.net GridView that automatically populates on any dataset, as well as automatically sorts, but for some reason whenever you click the headers to sort the GridView, the data doubles. The Cause: I originally omitted crucial line gv.Columns.Clear(); in the code sample below.    For whatever reason I […]