Justin Cooney

Web Development Tips and Examples

recent posts

about

I am a Senior Applications Programmer / Analyst with years of experience developing enterprise solutions using the Microsoft technology stack including C#, VB.NET, ASP.NET, AJAX, IIS and SQL Server. I specialize in Web application development with a focus on building secure systems, integrating applications, and designing robust database structures.

Category: VB.NET

  • Generating Excel documents through HTML, XML, and CSS – Part 2

    Overview: The latest versions of Excel (2007, 2010) differ from Excel 2003 in their support of streaming a HTML document containing Excel-specific markup. Although core markup features still work, some of the previously supported functionality has now been removed. This directly affects the ability in code to stream a table to Excel and then use MSO…

  • ASP.NET DropDownList: Set the Selected List Item

    I encountered a quirk today with pre-selecting a list item in the code-behind for a data-bound dropdown list during both the Page.Load and Page.PreRender events. I could set the selected value, but I could not check the list to see if the value that I wanted to select is actually available for selection. This is…

  • VB.NET: Date & Time Custom Formatting

    Often I find that I need to display a date and/or time in a specific format. Luckily VB.NET provides many options to adjust how a date is rendered as a string. Today, for example, I was working on a Web-based report that can be exported as an Excel file. As part of the process I…