Loading

Visual Basic 6.0 Max Record Property to C sharp

David Smith

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

????????

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vulpes12y ago
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.