Null Dataset Row Produces System.IndexOutOfRangeException 1

[Mike555]

I have a dataset which contains between 1-70 records. I also dimension 70 string variables which hold the "BundleID" value from each record. If I have 8 records in the dataset, the first 8 string variables will populate successfully, but then I get the following error on #9...
System.IndexOutOfRangeException: There is no row at position 9.

My code (similar for all 70 variables) looks like this...

If Not IsNothing(dataset.Tables("spMobileBundleIDSelect").Rows.Item(1)("BundleID")) Then StringVariable1 = dataset.Tables("spMobileBundleIDSelect").Rows.Item(1)("BundleID").ToString()

As you can see I'm trying to use Not IsNull to check if a record exists for the specific dataset row.

How can I check whether or not a dataset row exists without having this exception?

Thanks.

 

[chrissie1]

try using if not isdbnull look at the db

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[ThatRickGuy]

Check and see what the

dataset.Tables("spMobileBundleIDSelect").Rows.Count

property returns

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[Mike555]

Thanks Rick - That's what we needed!

 

[ThatRickGuy]

Remember to use .rows.count-1 if you are looping through the collection. .Count returns the 1-based value, where as .item(x) is 0-Based.

'This will work:
dim iRow as integer
for iRow = 0 to datatable.rows.count-1
 '...
next

'This will NOT work:
dim iRow as integer
for iRow = 1 to datatable.rows.count
 '...
next
[code]

-Rick

VB.Net Forum forum796    forum855 ASP.NET Forum
    [monkey][url=http://www.ringdev.com]I believe in killer coding ninja monkeys.[/url][monkey]