HELP: Custom properties in ADO.NET?

1 Mar 2006 6:09 PM

Usenet User

Hi all,

The "old-fashioned" ADO allowed for setting the custom properties
exposed by the provider, like in the example below:

Set objCommand = New ADODB.Command
    With objCommand
        .ActiveConnection = objConnection
        .CommandType = adCmdText
        .CommandText = strQuery
        .Properties("Maximum Rows") = 0    <------- !!!
        .Prepared = True
        .Execute
    End With

Is there a way to do this in ADO.NET? I am using a custom DB provider
with System.OleDb.* objects, yet am not sure how the above can be
achieved.

TIA!

P.S. I am using ADO.NET 1.1

1 Mar 2006 6:50 PM

Cor Ligthert [MVP]

Usenet,

You can do what you want using the overloaded version of the Fill,

(The other way is using the "Top" code in that in the Transact SQL)

Have a look at this paging sample on our webside.

http://www.vb-tips.com/default.aspx?ID=79afdb6a-611d-43cd-9186-def86a1baeef

I hope this helps,

Cor

Show quote

"Usenet User" < @ . > schreef in bericht
news:8hob029sm94cjbkj94i7ftftkd4k0n165o@4ax.com...
> Hi all,
>
>
> The "old-fashioned" ADO allowed for setting the custom properties
> exposed by the provider, like in the example below:
>
> Set objCommand = New ADODB.Command
>    With objCommand
>        .ActiveConnection = objConnection
>        .CommandType = adCmdText
>        .CommandText = strQuery
>        .Properties("Maximum Rows") = 0    <------- !!!
>        .Prepared = True
>        .Execute
>    End With
>
> Is there a way to do this in ADO.NET? I am using a custom DB provider
> with System.OleDb.* objects, yet am not sure how the above can be
> achieved.
>
> TIA!
>
> P.S. I am using ADO.NET 1.1