Recordsets from ASP to ASP.NET 1

[oldwen]

Hello all,

I need some expertise here. I am trying to learn this .NET stuff and I am confused about recordsets. Traditionally I would use a recordset like this....
Dim objComm, objComm2
Set objComm = Server.CreateObject("ADODB.Command")
Set objComm2 = Server.CreateObject("ADODB.Command")
objComm.ActiveConnection = strConnect
objComm2.ActiveConnection =strConnect
objComm.CommandText = Orlando
objComm.Execute
Set objComm = Nothing

I have not been able to identify how to accomplish this same thing using .NET. I have read some about datareader and dataset, but I am still confused. Can anyone give me some insight?

Oldwen

 

[link9]

Some places to start:

http://msdn.microsoft.com/msdnmag/issues/04/07/DataPoints/default.aspx

http://msdn.microsoft.com/msdnmag/issues/04/08/DataPoints/default.aspx

The basic paradigm is still the same. You still need a connection, a command, and a target datasource. What has been added is the dataadapter, which you only need when populating a datatable and/or dataset.

I also invite you to check out Microsoft's application blocks, which abstract alot of the plumbing details from you:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/daab-rm.asp

Post back with specific questions if anything is unclear.

-p

The answer to getting answered -- faq855-2992