Use stored procedures instead of embedding Transact-SQL in your VB code. This significantly reduces network traffic and speeds up query execution

See this topic:

http://www.sql-server-performance.com/visual_basic_performance.asp