Item not Found in Collection

[Simon_R]

Ok, this is my first .net program and it is converted from vb6

I searched but could not find the answer.

                  
For Count = 1 To SQL_RS.Fields.Count
                Me.List_of_Fields.Items.Add(SQL_RS.Field(Count).Name)
Next

Count is defined as long.

I get a item not in collection error when count is 1
I can see the value in the quickwatch window

Heeelp

Simon

[Negative0]

I think that it may be a zero based collection. Try going from 0 to .Count -1 and see if that works.

[Simon_R]

Yes it is, but I tried hard coding 1 in there and I get a value
I use a long field with a value 1 and I get item not found in collection.

Simon

[Simon_R]

got it, I have to use schema's

and .net's debugger SUCKS !!!!!!!!

Simon

[techgnome]

NOTE: Ints have changed form VB6 to .NET.
In VB6, an integer is now a short in .NET.
In VB6, what was a long is now an integer in .NET
Try changing it from a long type to an integer type.

TG