Counting datarows 2

[daveonion]

Hi I have a datarow array created and populated as such

Dim over_Comp() As DataRow
over_Comp = Ds.Tables("table").Select("Expected completion <='" & Date.Today & "'")

I was wondering what the easiest way is to work out how many records are in the array
thanks in advance

 

[techsmith]

Try

over_Comp.GetUpperBound(0)

 

[earthandfire]

Unless I have totally misunderstood this question, I can't see how .GetUpperBound can possibly give the correct answer.


Arrays in VB.NET are 0 based and therefore 1 needs to be added to .GetUpperBound to return tne number of records, whereas

[tt]over_Comp.Length[/tt]

will return the correct answer without any additional modification or calculation.


Hope this helps.