Adding a Incrementing Column to a Grid View

I have a grid view which takes its data from an SQL query.

The query returns a league Table of results. I would like to a add a
column which show the poistion of result (i.e 1,2,3,4)

how can i get add a column which simply showns an incremented number
for each row.

Glenn

just add a column and give it the value of the grid view current row
index.

rjl

You could generate it in the original SQL statement. Use a temp table with
an identity column, and fill it with the original data, and then select from
the temp table.

Jeff

"Glenn" <> wrote in message
news: oups.com...
>I have a grid view which takes its data from an SQL query.
>
> The query returns a league Table of results. I would like to a add a
> column which show the poistion of result (i.e 1,2,3,4)
>
> how can i get add a column which simply showns an incremented number
> for each row.
>

Jeff Dillon