Check out this two part article on programming with stored procedures over at codeguru.
Part 1: http://www.codeguru.com/vb/gen/vb_database/storedprocedures/article.php/c5147/
Part 2: http://www.codeguru.com/vb/gen/vb_database/storedprocedures/article.php/c5155/