Jason N. Gaylord
Coder
from Northeast PA
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

Use LINQ to XML to Generate Excel Documents

I was looking for a quick and easy solution to export data from SQL into an Excel format from within my ASP.NET application. I came across a great video posted by Beth Massi on the asp.net website (Video #7 at the bottom at http://www.asp.net/learn/linq-videos/). Beth steps through creating the LINQ to XML and how you can populate your Excel document. When I used this in an ASP.NET application, I added the XML declaration to the Response.Write so that Excel could understand the document. In ASP.NET, the XMLDocument type has a tendency to drop the XML declaration when writing out the document using .ToString.

Read More

ASP.NET 3.5 SP1 (Formerly "ASP.NET 3.5 Extensions") Released

ASP.NET 3.5 Service Pack 1, which was formerly called the ASP.NET 3.5 extensions, has been released. The NetFX update was available as part of the SQL Server 2008 download available on Friday. Now it is available as a separate download. There are quite a few enhancements in 3.5 including Dynamic Data, the Entity Framework, the AJAX History control, better Silverlight support and more! Be sure to download it today at http://www.asp.net/downloads/3.5-sp1/.

Read More

Known Postback Issue with AJAX Controls

I came across a postback issue while using the CascadingDropDown AJAX control. I had a web page with 3 DropDownList controls. The data for these controls was populated from the CascadingDropDown which would bind the data at runtime. The issue with this is that when data is being bound at runtime, it cannot be validated during postback unless each value is registered with the page.  In most cases, this wouldn’t make sense. So, we have to fall back to turning off EventValidation at an application level in the web.config (attribute is found on the pages element) or at the page level (attribute is added to the page directive). It’s best to turn off the EventValidation at the page level. There is no way to turn this off at the control level unless you are building your own control that does not contain the SupportsEventValidation attribute.

Read More

Tip: Set the SelectedValue on a DropDownList that is populated by a CascadingDropDown

When using a DropDownList, you can set the selected item by using the SelectedIndex property. However, if your DropDownList is being populated by the CascadingDropDown control (from the ASP.NET AJAX Control Toolkit), that doesn’t work. Instead, you must use the SelectedValue property on the CascadingDropDown control.

Read More

Clearspring Widgets Don't Work on 64-Bit Platform

Unless you are using IE 32-bit, don’t expect the Clearspring widgets to work. Clearspring is one of the leaders in building widgets for social networks and Vista. The reason their widgets do not work is because Flash is not yet supported on 64-bit platforms. By default, the Vista Sidebar on a 64-bit system displays widgets by using IE 64-bit.

Read More

Visual Studio Fonts and Colors

For quite some time I’ve been working with a modified version of Scott Hanselman’s “Dark Theme” for Visual Studio. The reason for my modifications is that the HTML and CSS settings were very difficult to read. Here is the complete list of changes I’ve made in Tools > Options > Environment > Fonts and Colors:

Read More

Microsoft Releases SQL Server 2008

SQL Server 2008 has been released to manufacturing (RTM’d) today. For more information about this release, be sure to visit Microsoft’s press release at http://www.microsoft.com/presspass/press/2008/aug08/08-06SQLServer2008PR.mspx.

Read More

Who are the ASPInsiders?

Rob Chartier blogged about the ASPInsiders late last week. If you are unfamiliar about the group, it’s purpose, and it’s members, be sure to visit http://weblogs.asp.net/rchartier/archive/2008/08/01/who-are-the-aspinsiders.aspx.

Read More

Amazon introduces Kindle

Amazon released a new portable device called Kindle to their marketplace today. Kindle has the ability to read thousands of books that are available in the Amazon marketplace. Users have the ability to preview books before they decide to purchase them. In addition, the Kindle product has the ability for users to store Microsoft Word documents on it for later viewing.

Read More

Using the LINQ Keyword "First"

All day I was stumped on why there wasn’t a simple way to grab the first object in a sequence other than using:

Read More