Visual Basic 6.0 Max Record Property to C sharp

Question

What is equivalent C sharp logic using Visual Basic 6.0 Max number of records property. I am working with a disconnected datatable.

Transfering logic to C sharp.

Visual Basic:

recordset.MaxRecords

C sharp:

using datatable

????????

Vulpes · Answer

You can't limit the number of rows in the DataTable itself which in theory could have up to (approx) 2 billion rows though you'd have run out of memory well before then. However there are overloads of the DbDataAdapter.Fill() method which can restrict the number of records inserted into the DataSet or DataTable in the first place. You could also do this in the SQL query itself using the TOP keyword.