I have some string fields on a few of my forms that have apostrophes (single quotes) in them in the database.  Things like New Year's Day cause errors when I go to save the BO using the Save method.  How do I get around this?

Hehe, that's not a problem.  If you have any problems on the save, just post that debug output along with the post, and it will help us solve the problem much faster.

If you ever need to send values to the server (especially string values, since they can contain single quotes), don't concatenate a bunch of strings together into the whole command; parameterize the command instead.  Parameterizing commands also helps SQL Server to cache the execution path of the command for future executions since the command text itself doesn't change, just the values of the parameters.

So, instead of this:

Me.FillDataTable("SELECT * FROM MyTable WHERE MyField = '" & SomeValue & "'")

Do this:

Dim loCommand As New SqlCommand()
loCommand.CommandText = "SELECT * FROM MyTable WHERE MyField = @MyValue"
loCommand.Parameters.Add("@MyValue", SqlDbType.NVarChar)
loCommand.Parameters("@MyValue").Value = MyValue
Me.FillDataTable(loCommand)

You'll notice that you can pass a DbCommand object to the data source for execution (which is your SqlCommand object).  Have fun