How Do I Do This VB Code In C# - Set Conn = Server.CreateObject("ADODB.Connection")

[Empire City]

Set Conn = Server.CreateObject( "ADODB.Connection" )
Conn.Open( "DSN = mydsn; UID = myuserid; PWD = mypassword;" )
sql = "select * from customers"
Set RS = Conn.Execute( sql )

Preferably with a SqlDataAdapter not an OleDbDataAdapter

[Peter Koen]

"Empire City" <[e-mail]> wrote in news:ahYnb.38723$ri.5738323
@twister.nyc.rr.com:

Set Conn = Server.CreateObject( "ADODB.Connection" )
Conn.Open( "DSN = mydsn; UID = myuserid; PWD = mypassword;" )
sql = "select * from customers"
Set RS = Conn.Execute( sql )

Preferably with a SqlDataAdapter not an OleDbDataAdapter

Sorry, but this posting just shouts to post a RTFM. ;-)

You may want to check out this web site:

http://msdn.microsoft.com/library/en...wtaccessdb.asp

--
------ooo---OOO---ooo------

Peter Koen - www.kema.at
MCAD CAI/RS CASE/RS IAT

------ooo---OOO---ooo------

[Juan Gabriel Del Cid]

A lot of posts deserve an RTFM response, :-D. A lot more deserve a "did you
actually search google for this and that? I got 500 search results myself."

-JG