Transfer ADO Code to ADO.NET

[ronaldlee]

HI,
how to do a RecordSet in OleDbConnection???
my original code is using ADODB.RecordSet
But how can i do the RecordSet in OleDbConnection?

my original code

Function openDB() As Object
objConn = New ADODB.Connection
objConn.Open(dbDNS) '("dbfile")

objRS = New ADODB.Recordset

End Function
Function closeDB() As Object
' If the RecordSet has a state of 1 (open) close it
If objRS.state = 1 Then
objRS.Close()
End If

objConn.Close()
objConn = Nothing
End Function

*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*

[Kevin Spencer]

This is really a bad way to do database operations in ASP.Net. Interop is
problematic, and there are plenty of classes in the CLR for working with
databases. I would suggest using them.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

"ronaldlee" <le***********@yahoo-dot-com.no-spam.invalid> wrote in message
news:41**********@Usenet.com...

HI,
how to do a RecordSet in OleDbConnection???
my original code is using ADODB.RecordSet
But how can i do the RecordSet in OleDbConnection?

my original code

Function openDB() As Object
objConn = New ADODB.Connection
objConn.Open(dbDNS) '("dbfile")

objRS = New ADODB.Recordset

End Function
Function closeDB() As Object
' If the RecordSet has a state of 1 (open) close it
If objRS.state = 1 Then
objRS.Close()
End If

objConn.Close()
objConn = Nothing
End Function

*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*