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: Programming

  • GridView OnRowUpdated how to get the Edited Row

    This article deals with the GridView WebForms .NET control; in particular with how to detect and record changes after the user has saved data in the GridView. Sometimes using WebForms controls is not well documented and unintuitive, which is the case with the onRowUpdated event, where a lot of information available online is incorrect or misleading.…

  • TSQL Query to List Tables in a Database with Row Counts

    In a previous post I talked about how to find highly populated tables in a database. I’m going to expand on that in this post to show how to catalog a database into data-holding tables and supporting details tables.

  • TSQL Search for the Last Record in a Group

    In this article I’ll show how to get the most recent record for a group of records in a SQL Server table. There are a number of ways to do this including CTEs and nested subqueries. Since nested subqueries are the most widely supported across the different versions of SQL Server, I consider them the…