[salomon.frid]

While trying to read the records in a table that belongs to a dataset, I test to verify if the record does not exist:

int i;
while (dataset.table["mytable"].rows[i] != null)
       {
          // do some work
          i++;
       }

once i reaches the value where there is no corresponding record, c# will issue an exception
I worked around it with the following code:

foreach (DataRow row in ds.Tables[0].Rows)
// do work

but i am not sure why the first code does not work
thnx

This post has been edited by AdamSpeight2008: 17 August 2010 - 09:30 PM
Reason for edit:: Fixing Code tags :code:

[n8wxs]

You get the exception because you trying to access an element outside the array.

You could use a try()...catch() block to catch the exception but your workaround is probably simpler.

[Curtis Rutland]

Yes, values outside the bounds of an array won't be null, they'll throw an IndexOutOfBoundsException.

Think of it this way. Your "while" loop will keep going until "i" becomes larger than the array. Then when you try to access that index of the array, the array says "no, that doesn't exist" and throws an error.

You could do this with a "for" loop":

for(int i=0; i<dataset.table["mytable"].rows.Count; i++)
  //do work

But the foreach is a more elegant solution if you're not changing the collection.