Almost everybody in this newsgroup is using VB6 or lower. While you may
get a stray answer to VB.NET questions here, you should ask them in
newsgroups devoted exclusively to .NET programming. Look for newsgroups
with either the word "dotnet" or "vsnet" in their name.

For the microsoft news server, try these newsgroups...

microsoft.public.dotnet.general
microsoft.public.dotnet.languages.vb
microsoft.public.vsnet.general

There are some others, but these should get you started.

Rick - MVP



"jlmjrdev"  wrote in message
news:daa51155.0406150928.25eeb581{at}posting.google.com...
> 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