Well, this query "how to connect sql server 2000 vb
.net" throw a lot of results in google.
Anyway, .net use a complete different way to connect to a database, also to handle "recordsets". Depends on what you need, is what you open an use to process. There are objects that you can just throw on the form to make the connection open automatic. There is no more recordset, now you have datatables (something like a table), datasets and others. Maybe you can start digging from there.
The easy answer would be, you have to create a connection object and pass the connection string to it, open it, then build a datatable for what you need.
Read this if you want to know how to get a correct reply for your question:
^^Took that from dparsons signature and he Took that from planoie's profile
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
I know that CVS was evil, and now i got the proof: