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

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…
T-SQL – Search a Database for all Table Columns with a Text Value

2013-01-03

There are times when it comes in handy to be able to query all columns of all of the tables in a database for a particular text match. For example: if you have just taken over a project with a large database and are trying to find where values from the UI are coming from,…
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: Database

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

T-SQL – Search a Database for all Table Columns with a Text Value

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