Here's some code I use in VB6.  How could I do this same thing in
VB.NET?  I am having a hard time finding a simple example showing how
to do this in .net.  Please help.


Const DB_CONNECT_STRING = "Provider=SQLOLEDB.1;Persist Security
Info=False;User ID=User;Initial Catalog=Northwind;Data
Source=ServerName;Use Procedure for Prepare=1;Auto
Translate=True;Packet Size=4096;Use Encryption for Data=False;Tag with
column collation when possible=False;User Id=sa;PASSWORD=password;"

Set dbConn= CreateObject("adodb.connection")
dbConn.Open DB_CONNECT_STRING, "User", "password"

Set rs = dbConn.Execute("sp_ListNames")

While Not rs.EOF
strNames = strNames & rs("Name") & VbCrLf

rs.MoveNext
WEnd
---
þ RIMEGate(tm)/RGXPost V1.14 at BBSWORLD * Info{at}bbsworld.com

---
 * RIMEGate(tm)V10.2áÿ* RelayNet(tm) NNTP Gateway * MoonDog BBS
 * RgateImp.MoonDog.BBS at 6/15/04 4:45:41 PM