Anti-QSL Injection. I'm sure it could be better, so any improvements are welcome.

Util Class with methods for executing datasets, nonquerys, sending mails, etc.

Some usefull snippets for SQL Server.

Databinding in asp.net 2.0 is takes very few lines of code.

Simple Connection Class.

Databinding in asp.net 2.0 takes very few lines of code. This example shows how to bind a CheckBoxList using a SqlDataSource.

Get Selected Values From a CheckBoxList in C#

Strip HTML Tags From a String

I actually like SQL. So, things like Hibernate with it's own query language don't quite fit my style. But, I don't want to code the same catch SQLException conn.close over and over either. So, I came up with this.

The idea is you extend SQLCommand (usually anonymously) override getSql(), and call execute() to get a list of whatever objects you are selecting - all the cleanup stuff is taken care of. It also handles nullable attributes more intuitively using ResultSetWrapper and PreparedStatementWrapper so that in your overridden getRow(ResultSetWrapper rs) method, you can call getInt on a nullable column and have it return null - what a concept! Also I like java.util.Date for my dates, so the wrappers convert to/from java.sql.Timestamp.

Right now I've only bothered with some basic types - it should be pretty clear how to add more if you need em.

See what ya'll think.

Oh, it uses JDK 1.5 Generics, but stripping that away would be pretty easy if you wanted 1.2 compliance.

Dynamically Populate a CheckBoxList in VB.Net