tags:

views:

480

answers:

1
Q: 

VB.NET call ADODB.Command.Execute - not returning Recordset

Hello

I have a classic ADO command which execs a sproc and returns a RecordSet. This is being executed from a VB.NET using the PIA.

However when I .Execute the command, the result returned is not an ADODB.Recordset but a System.__ComObject.

Wonder if anyone has seen similar behaviour?

+1  A: 

Isn't that just the .NET interop wrapper for any COM object? GetType.Type will always return System.__ComObject. You can TryCast or DirectCast to a more useful type.

MarkJ  2009-09-10 11:21:48
You're spot on. I found out that I needed to make sure that the methods passing this recordset about were all strongly typed, or else it would fall over at runtime.
Duncan  2009-09-10 13:37:12

related questions

What are the most important functional differences between C# and VB.NET?
Setting Group Type for new Active Directory Entry in VB.NET
ASP.Net Datagrid: in Footer calculate Avg or Sum for column
Opening a file in my application from File Explorer
HTML Email Editor in a Windows Forms Application
Datatables, Dataviews and distincts! (ASP.Net/VB)
Naming convention for VB.NET private fields
Visual Studio - new "default" property values for inherited controls
Change the width of a scrollbar
Is String.Format as efficient as StringBuilder
Default Form Button in FireFox
VB.NET - IsNothing versus Is Nothing
'Break' equivalent keyword for VB
What is the best way to wrap time around the work day?
Best SVN Client Ignore Pattern for VB.NET Solutions?
Long-time LAMP Developer moving to VB.NET
What's the best way to find long-running code in a Windows Forms Application
What is the best way to deploy a VB.NET application?
'Best' Diff Algorithm
Setting Objects to Null/Nothing after use in .NET
CSV File Imports in .Net
How do you migrate a large app from VB6 to VB .net ?
Floating Point Number parsing: Is there a Catch All algorithm?
Decoding T-SQL CAST in C#/VB.net
Reliable Timer in a Console Application