Justin Cooney

Web Development Tips and Examples

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: .Net

ASP.NET Example – Populating a DataSet Using SQLDataAdapter Fill DataSet

2013-01-10

In the example functions below I’m illustrating how to set up a basic query to a stored procedure in your database that takes a single string parameter. The examples involve using the SQLDataAdapter object to Fill a DataSet. The resulting DataTable can then be queried as desired. Specifically: The first example shows how to read the…
Use a JQuery Modal Form Dialog to Add Rows to a GridView Control

2013-01-04

Hooking up a JQuery Form Dialog Widget to an ASP.NET GridView Control Let’s face it: the stock ASP.NET GridView control has some behaviors and limitations that aren’t exactly optimal. For starters, the lack of a nice way for users to add new rows to the grid is unfortunate. There are, of course, several different work-arounds…
SQL Server – Pass a List from your ASP.NET Code to a Stored Procedure using XML

2012-12-31

Sometimes while developing a tool, a developer needs to pass a list of values with a variable size to their database. There are several ways of doing so, one of which involves passing the list in XML format. The introduction of SQL Server 2005 offered the use of XML datatypes, which had not existed in…

recent posts

about

Category: .Net

ASP.NET Example – Populating a DataSet Using SQLDataAdapter Fill DataSet

Use a JQuery Modal Form Dialog to Add Rows to a GridView Control

SQL Server – Pass a List from your ASP.NET Code to a Stored Procedure using XML