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.

  • SQL Server: Delete Duplicate Records Except the First Duplicate Record

    Problem:

    I encountered an interesting problem today. I had a SQL Server table with many records in it that I needed to clean up. Specifically, I needed to find all duplicate records in the table, but keep the first of each of the duplicate records.

    The table also contained several rows of detail information that was different for each entry, but I only wanted to keep whatever detail information that the first of each of the duplicate records contained.

    Solution:

    (more…)

  • ASP.NET GridView RowUpdating Event Handler – Programmatically Reference Controls and set SqlDataSource UpdateParameters

    Introduction:

    Visual Studio allows developers to quickly put together a WebForms page simply using drag and drop options from the Visual Studio editor. Binding form controls is mostly a simple matter of attaching a DataSource and setting your controls to reference the correct field in the DataSource.

    Binding a GridView control can sometimes get tricky when using the VisualStudio editor, especially when working with DropDownList controls within the grid.

    Today I was working on getting a row of the GridView control to save the contents of a DropDownList, and needed to add some custom code to set values passed to the SqlDataSource control on the update event.

    Solution:

    (more…)

  • CSS3 Table Border Rounding in Older Versions of the Major Browsers

    Introduction:

    In the past while I have been playing with CSS3 markup to round my HTML table borders.

    The latest versions of the major browsers now support CSS3 table border rounding using standardized CSS3 property tags. This means that IE9+, Firefox8+, Chrome5+, Opera10.5+, Safari5+ all support the border-radius: Npx property style.

    However older versions of the major browsers each used somewhat different CSS to support rounding of table borders. Here is a result of my investigations.

    Overview:

    Below is a table of the CSS properties that earlier versions of the major browsers required to support HTML table border rounding. (more…)