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]

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-us/dnadonet/html/adon_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