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

  • Thread starter Thread starter Empire City
  • Start date Start date
E

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
 
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
Click to expand...

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------
 
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
 
Back
Top