Using COM objects in ASP .NET

[latortugamorada]

I know this topic is a frequent one, but I haven't found anyone with my specific problem yet (well, at least no one wants to talk about it).

I've tried a couple of methods for getting an old COM object to work within ASP .NET. Here's a simple example:

----
@Import Namespace="eShoppingCart"

Dim objShoppingCart as eShoppingCart.boShoppingCart
Dim sConnectionString, sCartId

sConnectionString = Application("ConnectionString")
sCartId = ""

objShoppingCart = New eShoppingCart.boShoppingCart()

sCartId = objShoppingCart.Generatecart(sConnectionString, Request.ServerVariables("HTTP_USER_AGENT"), Request.ServerVariables("REMOTE_ADDR"), "DEF")
----

I've used the tlbimp.exe to create a wrapper from the old .dll and all that and I've put it in the /bin directory of my web site.

In this example, objShoppingCart is successfully created, but the call to Generatecart fails for an unknown reason.

My question is this: Is there something else obvious or not that I've missed that is necessary to the success of this conversion to .NET? Or is it possible that the object I'm trying to use here just won't work?

(I've also tried the other method using the Server.CreateObject() on the original .dll with the same results)

The function call is successful when run in asp classic with the exact same parameters.

Thanks in advance

[latortugamorada]

So, I've figured out that problem was a simple oversight of the Application(...) call. Oops.

However, I'm having difficulty finding out how to use an ADODB.RecordSet in ASP.NET. Do I need to Import some assembly .dll like other COM objects?

Thanks

[ilearneditonline]

So, I've figured out that problem was a simple oversight of the Application(...) call. Oops.

However, I'm having difficulty finding out how to use an ADODB.RecordSet in ASP.NET. Do I need to Import some assembly .dll like other COM objects?

Thanks

Why would you want to use ADODB.recordset with ASP.NET? You should be using either a datareader or a dataset.

You would do something like this with VB.NET. I don't really use VB.NET but rather C#, but it should be something like below. I always use code behind files, but could be done inline. You should also add some type of error handling to this.

Public ReadOnly Property ConnectionString() As String
    Get
        Return "Your Connection String"
    End Get
End Property
 
Public Function executeDataReader() As SqlDataReader
    Dim query As String = "SELECT field1, field2, field3 FROM t_table"
    Using conn As New SqlConnection(Me.ConnectionString)
    Dim cmd As New SqlCommand(query, conn)
    cmd.CommandType = CommandType.Text
    cmd.CommandTimeout = 30
 
    'open the connection
    conn.Open()
    return cmd.ExecuteReader(CommandBehavior.CloseConnection)
End Function