hi all,

apparently i'm losing it here... i can't declare a recordset and have a normal usage of these.

in ASP.OLD i used:
Code:
Dim StrConnect as String
Dim Rs As ADODB.Recordset

StrConnect = "Provider=Microsoft.Jet.OLEDB.4.0; " & _
    "Data Source=c:\inetpub\wwwroot\mysite\database\mysite.mdb"
Rs=Createobject("Adodb.Recordset")	'connection to DB
Stropen="Select * FROM cmodc_login WHERE (Active AND iduser='" & iduser & "')"

Rs.Open StrOpen,StrConnect,3,3

if NOT Rs.eof then
    do while not Rs.EOF
        Response.Write(Rs("idname"))
        Rs.MoveNext
    loop
end if
Rs.close

'free memory
Set Rs=nothing
...can someone point me in the direction of how the code would look like in asp.net...?

thanks...

wc.