Open Unconnected ADORecordset

[Brent Rogers]

I am trying to open an Unconnected/Disconnected ADORecordset.

Using VB I would use the following function call

rs.Open()

However C# requires a Source and Connection.
What do I pass in?
I have tried null, the null string, zeros, empty objects but I keep getting
a runtime error when I try to open the Recordset

Any help would be appreciated.

[Frank Rizzo]

Brent Rogers wrote:

I am trying to open an Unconnected/Disconnected ADORecordset.

Using VB I would use the following function call

rs.Open()

However C# requires a Source and Connection.
What do I pass in?
I have tried null, the null string, zeros, empty objects but I keep getting
a runtime error when I try to open the Recordset

Any help would be appreciated.

add the Interop goo to the using statement. Then

rs.Open(Type.Missing, Type.Missing);

[Brent Rogers]

Frank:

When I try that I get the error:

The connection cannot be used to perform this operation. It is either closed
or invalid in this context.

"Frank Rizzo" wrote:

Brent Rogers wrote:

I am trying to open an Unconnected/Disconnected ADORecordset.

Using VB I would use the following function call

rs.Open()

However C# requires a Source and Connection.
What do I pass in?
I have tried null, the null string, zeros, empty objects but I keep getting
a runtime error when I try to open the Recordset

Any help would be appreciated.

add the Interop goo to the using statement. Then

rs.Open(Type.Missing, Type.Missing);

[Frank Rizzo]

Brent Rogers wrote:

Frank:

When I try that I get the error:

The connection cannot be used to perform this operation. It is either closed
or invalid in this context.
Then the connection is probably not assigned to the recordset.

rs.ActiveConnection = whatever your connection is.

"Frank Rizzo" wrote:

Brent Rogers wrote:

I am trying to open an Unconnected/Disconnected ADORecordset.

Using VB I would use the following function call

rs.Open()

However C# requires a Source and Connection.
What do I pass in?
I have tried null, the null string, zeros, empty objects but I keep getting
a runtime error when I try to open the Recordset

Any help would be appreciated.

add the Interop goo to the using statement. Then

rs.Open(Type.Missing, Type.Missing);

[Brent Rogers]

The thing is that I dont have a connection..

"Frank Rizzo" wrote:

Brent Rogers wrote:

Frank:

When I try that I get the error:

The connection cannot be used to perform this operation. It is either closed
or invalid in this context.

Then the connection is probably not assigned to the recordset.

rs.ActiveConnection = whatever your connection is.

"Frank Rizzo" wrote:

Brent Rogers wrote:
I am trying to open an Unconnected/Disconnected ADORecordset.

Using VB I would use the following function call

rs.Open()

However C# requires a Source and Connection.
What do I pass in?
I have tried null, the null string, zeros, empty objects but I keep getting
a runtime error when I try to open the Recordset

Any help would be appreciated.
add the Interop goo to the using statement. Then

rs.Open(Type.Missing, Type.Missing);

[Frank Rizzo]

Brent Rogers wrote:

The thing is that I dont have a connection..
You mean, previously you saved the recordset to a file and now you're
trying to reopen it?

In that case, you have to pass in the name of that file.

You are not sharing a lot of information. Kind of difficult to help.

"Frank Rizzo" wrote:

Brent Rogers wrote:

Frank:

When I try that I get the error:

The connection cannot be used to perform this operation. It is either closed
or invalid in this context.

Then the connection is probably not assigned to the recordset.

rs.ActiveConnection = whatever your connection is.

"Frank Rizzo" wrote:

Brent Rogers wrote:
> I am trying to open an Unconnected/Disconnected ADORecordset.
>
> Using VB I would use the following function call
>
> rs.Open()
>
> However C# requires a Source and Connection.
> What do I pass in?
> I have tried null, the null string, zeros, empty objects but I keep getting
> a runtime error when I try to open the Recordset
>
> Any help would be appreciated.
add the Interop goo to the using statement. Then

rs.Open(Type.Missing, Type.Missing);

[Brent Rogers]

What I wanted was actually an 'In Memory' recordset.
I wanted to be able to perform the same action as the VB:
rs.Open()
would do.

I was able to do this with the following:
MyRecordset.Open( Missing.Value
,Missing.Value ,ADODB.CursorTypeEnum.adOpenUnspecified ,ADODB.LockTypeEnum.adLockUnspecified ,(int)ADODB.CommandTypeEnum.adCmdUnspecified );

The key was setting the Options parameter to:
(int)ADODB.CommandTypeEnum.adCmdUnspecified
rather than null and/or zero.

"Frank Rizzo" wrote:

Brent Rogers wrote:

The thing is that I dont have a connection..

You mean, previously you saved the recordset to a file and now you're
trying to reopen it?

In that case, you have to pass in the name of that file.

You are not sharing a lot of information. Kind of difficult to help.

"Frank Rizzo" wrote:

Brent Rogers wrote:
Frank:

When I try that I get the error:

The connection cannot be used to perform this operation. It is either closed
or invalid in this context.
Then the connection is probably not assigned to the recordset.

rs.ActiveConnection = whatever your connection is.

"Frank Rizzo" wrote:

> Brent Rogers wrote:
>> I am trying to open an Unconnected/Disconnected ADORecordset.
>>
>> Using VB I would use the following function call
>>
>> rs.Open()
>>
>> However C# requires a Source and Connection.
>> What do I pass in?
>> I have tried null, the null string, zeros, empty objects but I keep getting
>> a runtime error when I try to open the Recordset
>>
>> Any help would be appreciated.
> add the Interop goo to the using statement. Then
>
> rs.Open(Type.Missing, Type.Missing);
>