Jason N. Gaylord
Social Distancing since 3/14
Small planet on JasonGaylord.com A planet with rings on JasonGaylord.com
Visit JasonGaylord.com

Hello, I'm  jasongaylord Jason

I live with my family in the rolling hills of Northeastern Pennsylvania. I'm a web developer by trade, but have broad experience in various business areas. Want to know more about me?

Learn More

Adding QueryString Parameters to the SiteMapNode

There is no way to add querystring parameters to the SiteMapNode in a SiteMap control “out of the box.” I’m quite surprised there is no option but luckily the SiteMap uses the provider model. After a Live search, I was able to find a solution provided by Bobby DeRosa. By creating a custom provider, this can be accomplished. The project I was on is an update of an ASP.net app written in VB.net so here is my VB.net port:

Read More

"OLE received a packet with an invalid extension." in Microsoft Word

We still have Small Business Accounting 2006 implemented for some companies. When we use a custom invoice to print using the MS Word Smart Document set, we receive the error “OLE received a packet with an invalid extension.” This error occurs since the document was created before .NET 2.0 (or 3.0) was installed and before the Smart Document set was installed. To work around this issue, perform the following:

Read More

DirecTV: The Story of Bad Customer Service

I’ve had DirecTV service for 3 years now. During all 3 years I’ve subscribed to the premium package, the NFL Sunday Ticket, and NHL Center Ice. I have high-definition service with DVR capabilities. So, I pay a decent amount each month to DirecTV. Over the past 3 years I’ve also had my share of customer service “experiences.” When I wanted to upgrade to the HD-DVR receiver, I had to talk to the customer retention department to try to get some money off the receiver. Comcast, at the time, was new to our area and had a great HD/DVR offer for new customers. I finally received some credit for my HD service. When the installer came out, he threw my old dish off my house breaking it into little pieces and leaving a hole in the yard. They also took my old receiver. I called up and complained and all they did was leave the old receiver on the porch.

Read More

Retrieving SQL Type Image Using LINQ

LINQ views the Image type in SQL Server as Binary. So, there are a few options that we have. We can either (a) modify our LINQ to SQL class and change the property to Byte() instead of Binary or we can (b) convert the Binary to an array. To do the latter, you can use a lambda expression to obtain the image you are looking for and grabbing just the image. Here’s an example:

Read More

ASP.NET MVC Preview 3 Announced

Scott Guthrie just posted about the 3rd preview of the ASP.NET MVC over on his blog. You can catch the full details here: http://weblogs.asp.net/scottgu/archive/2008/05/27/asp-net-mvc-preview-3-release.aspx.

Read More

Attention Twitter: Wise up!

I read through the Twitter blog from time to time just to see how things are going. Apparently, things aren’t going good. Pagination and IM updates have been temporarily disabled and something has caused my twitter utilities (twhirl and OutTwit) to cease function. I keep getting an error that shows “Rate limit exceeded. Clients may not make more than 30 requests per hour.” Can you imagine if Twitter was an eCommerce shop and stopped a viewer after 30 page views? They’d slowly lose business. Does the Twitter team get that?

Read More

Force Your Website To Be IE8 Compatible

Microsoft recognizes that it will be difficult to have all sites use the latest HTML and CSS specs that are found in IE8. To accommodate the web sites that cannot be converted at this time, they’ve created a work around. There are two options: a) you can modify the config in IIS 7 or b) you can add a new meta tag to your page headers. More information about this can be found by visiting http://support.microsoft.com/kb/952030.

Read More

SQL Management Studio Shows All Databases

This has “bugged” me for awhile. When you log into any version of SQL (2000, 2005, and even 2008) as a user with restricted access to just a single database (or even a few databases), you can still see a complete list of all the databases on that server. There have been times when I needed to share a database with a customer or have accessed a shared database at a host such as DiscountASP.net or GoDaddy and can see all of the customers on that one box. It’s more of a nuisance than a real threat but I really wish it was changed. It has been confirmed as a bug. Please vote for it at http://tinyurl.com/6pk74q.

Read More

Using "Like" in LINQ to SQL

I’ve recently discovered that LINQ and VB can be confusing. I was attempting to pull the top 10 rows of a table where the column started with ‘W’. You’d think after I typed that, I’d figure out the solution. That’s not the case. Instead, I struggled. Here’s what I originally came up with:

Read More

Using LINQ to SQL and ConnectionStrings in a Class Library

I was looking to separate my LINQ to SQL data layer from the rest of my application. So, I decided to move the files to a class library. This way, when my application builds, all of my LINQ files are found in MyApp.DL or something similar. However, I wanted the class library to use the SQL connection that I have set in my web.config. Because the class library does not have a reference to System.Configuration, I had to add that first. I then created a partial class for my Context object. Inside, I created a new constructor with a boolean parameter called UseWebConfigConnectionString. My web.config would contain a generic connection string name called LinqSqlConnectionString. This allows me to make changes to the LINQ files, save them, and not affect this method. So, here’s what I ended up with:

Read More