HELP: Custom properties in ADO.NET?

[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

 

[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