I've just wrapped up the second part of my articles on Inserting into SQL Server without the VS Designer. This is only my second article, so comments are welcome!
Inserting into SQL Server, without the Designer - Part 2 - Creating a Connection
And if you haven't read part 1, you can find it here:
Inserting into SQL Server, without the Designer - Part 1 – Creating a Stored Procedure
Chris