Q: Index for a row

[Geoff Jones]

Hi

Can anybody help me with the following question?

Suppose I have the following code, where myTable is already defined
elsewhere:

For Each row In myTable.Rows
' Get an index for the row
Next

Within the loop, I'd like to be able to get hold of the zero based index for
the row being used. I know that I could simply add a variable before the
loop and then increment it within the loop, but I think there is an inbuilt
function to do it e.g. row.GetIndex(), or whatever.

Can anybody help?

Geoff

[Alex Levi]

You can use the for statement:

For i as intgeger = 0 to myTable.items.count - 1
' [i] - represent the index of each row
' [myTable.items.item(i)] - represent the item for each row (index)
Next i


"Geoff Jones" wrote:

Hi

Can anybody help me with the following question?

Suppose I have the following code, where myTable is already defined
elsewhere:

For Each row In myTable.Rows
' Get an index for the row
Next

Within the loop, I'd like to be able to get hold of the zero based index for
the row being used. I know that I could simply add a variable before the
loop and then increment it within the loop, but I think there is an inbuilt
function to do it e.g. row.GetIndex(), or whatever.

Can anybody help?

Geoff

[David Williams]

You can look at the RowNumber property for a cell in the row.

index = row.Item(0).RowNumber

HTH
--
David Williams, VB.NET MVP
"Geoff Jones" wrote:

Hi

Can anybody help me with the following question?

Suppose I have the following code, where myTable is already defined
elsewhere:

For Each row In myTable.Rows
' Get an index for the row
Next

Within the loop, I'd like to be able to get hold of the zero based index for
the row being used. I know that I could simply add a variable before the
loop and then increment it within the loop, but I think there is an inbuilt
function to do it e.g. row.GetIndex(), or whatever.

Can anybody help?

Geoff

[Geoff Jones]

Thanks Alex

However, it isn't possible to do using For Each then? That is, is there no
way of working out the index (using inbuilt members) of the row being
process in the loop?

Geoff

"Alex Levi" <Al******@discussions.microsoft.com> wrote in message
news:7A**********************************@microsof t.com...

You can use the for statement:

For i as intgeger = 0 to myTable.items.count - 1
' [i] - represent the index of each row
' [myTable.items.item(i)] - represent the item for each row (index)
Next i


"Geoff Jones" wrote:

Hi

Can anybody help me with the following question?

Suppose I have the following code, where myTable is already defined
elsewhere:

For Each row In myTable.Rows
' Get an index for the row
Next

Within the loop, I'd like to be able to get hold of the zero based index for the row being used. I know that I could simply add a variable before the
loop and then increment it within the loop, but I think there is an inbuilt function to do it e.g. row.GetIndex(), or whatever.

Can anybody help?

Geoff

[Cor Ligthert]

Hi Geoff,

You make me curious, why would you want to use it and what is than the
benefit of that?
(That for index method very effective in my opinion)

Cor

Thanks Alex

However, it isn't possible to do using For Each then? That is, is there no
way of working out the index (using inbuilt members) of the row being
process in the loop?

Geoff

"Alex Levi" <Al******@discussions.microsoft.com> wrote in message
news:7A**********************************@microsof t.com...

You can use the for statement:

For i as intgeger = 0 to myTable.items.count - 1
' [i] - represent the index of each row
' [myTable.items.item(i)] - represent the item for each row (index)
Next i


"Geoff Jones" wrote:

Hi

Can anybody help me with the following question?

Suppose I have the following code, where myTable is already defined
elsewhere:

For Each row In myTable.Rows
' Get an index for the row
Next

Within the loop, I'd like to be able to get hold of the zero based index

for

the row being used. I know that I could simply add a variable before

the loop and then increment it within the loop, but I think there is an

inbuilt function to do it e.g. row.GetIndex(), or whatever.

Can anybody help?

Geoff

[Geoff Jones]

Hi Cor

Merely being inquisitive :)

Geoff

"Cor Ligthert" <no**********@planet.nl> wrote in message
news:eD**************@TK2MSFTNGP09.phx.gbl...

Hi Geoff,

You make me curious, why would you want to use it and what is than the
benefit of that?
(That for index method very effective in my opinion)

Cor

Thanks Alex

However, it isn't possible to do using For Each then? That is, is there no

way of working out the index (using inbuilt members) of the row being
process in the loop?

Geoff

"Alex Levi" <Al******@discussions.microsoft.com> wrote in message
news:7A**********************************@microsof t.com...

You can use the for statement:

For i as intgeger = 0 to myTable.items.count - 1
' [i] - represent the index of each row
' [myTable.items.item(i)] - represent the item for each row (index) Next i


"Geoff Jones" wrote:

> Hi
>
> Can anybody help me with the following question?
>
> Suppose I have the following code, where myTable is already defined
> elsewhere:
>
> For Each row In myTable.Rows
> ' Get an index for the row
> Next
>
> Within the loop, I'd like to be able to get hold of the zero based

index

for

> the row being used. I know that I could simply add a variable before

the > loop and then increment it within the loop, but I think there is an

inbuilt

> function to do it e.g. row.GetIndex(), or whatever.
>
> Can anybody help?
>
> Geoff
>
>
>
>

[Cor Ligthert]

Hi David,

I can not find that, do you have a link on MSDN for that one?

Cor

You can look at the RowNumber property for a cell in the row.

index = row.Item(0).RowNumber

HTH
--
David Williams, VB.NET MVP
"Geoff Jones" wrote:

Hi

Can anybody help me with the following question?

Suppose I have the following code, where myTable is already defined
elsewhere:

For Each row In myTable.Rows
' Get an index for the row
Next

Within the loop, I'd like to be able to get hold of the zero based index for the row being used. I know that I could simply add a variable before the
loop and then increment it within the loop, but I think there is an inbuilt function to do it e.g. row.GetIndex(), or whatever.

Can anybody help?

Geoff

[Samuel L Matzen]

David,

I can't seem to get your solution to work. Can you point me to some
documentation on the RowNumber method of the Item object of a row?

-Sam Matzen
"David Williams" <Da***********@discussions.microsoft.com> wrote in message
news:BD**********************************@microsof t.com...

You can look at the RowNumber property for a cell in the row.

index = row.Item(0).RowNumber

HTH
--
David Williams, VB.NET MVP
"Geoff Jones" wrote:

Hi

Can anybody help me with the following question?

Suppose I have the following code, where myTable is already defined
elsewhere:

For Each row In myTable.Rows
' Get an index for the row
Next

Within the loop, I'd like to be able to get hold of the zero based index for the row being used. I know that I could simply add a variable before the
loop and then increment it within the loop, but I think there is an inbuilt function to do it e.g. row.GetIndex(), or whatever.

Can anybody help?

Geoff

[Geoff Jones]

I think David was using a member of a DataGrid; which wasn't the case I was
dealing with. Good try though!

Geoff

"Samuel L Matzen" <sm*****@slm.com> wrote in message
news:%2******************@TK2MSFTNGP09.phx.gbl...

David,

I can't seem to get your solution to work. Can you point me to some
documentation on the RowNumber method of the Item object of a row?

-Sam Matzen
"David Williams" <Da***********@discussions.microsoft.com> wrote in message news:BD**********************************@microsof t.com...

You can look at the RowNumber property for a cell in the row.

index = row.Item(0).RowNumber

HTH
--
David Williams, VB.NET MVP
"Geoff Jones" wrote:

Hi

Can anybody help me with the following question?

Suppose I have the following code, where myTable is already defined
elsewhere:

For Each row In myTable.Rows
' Get an index for the row
Next

Within the loop, I'd like to be able to get hold of the zero based index

for

the row being used. I know that I could simply add a variable before

the loop and then increment it within the loop, but I think there is an

inbuilt function to do it e.g. row.GetIndex(), or whatever.

Can anybody help?

Geoff