hi guys ,

when i query my table in query analyzer , it shows the actual row in the left
        trno
1 2
2 3
3 4
4 5
5 6
6 7

for trno=2 the row is 1, how can i get the row

tnx in advanced:)

In SQL Server there is no such thing as a row number. Oracle has. By Theory the Records in a table will not have a specific order other than that specified by the indices. SQL Server follows this principle. So you cannot get teh row number of any particular row. However there are ways of achieving this. You can write a sp which creates a temporary table (or a table variable) which contains an identity column (viz. RowNumber) and insert the records from your table to this table. So each of the rows in your new table will have a rownumber.

Regards
Ganesh

heres the actual scenario

i have textboxes whoch are bounded
ii have buttonnext and btnprevoius, it works right now
but if i want to search particular data it will fill the textbox, after this when i clik the next button, it will follow the next row, and so with the prevoius

Private Sub bntNext_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles bntNext.Click
        Try

            Me.BindingContext(myInvoice.InvoiceTable).Position += 1
            updatePosition()
        Catch ex As Exception
            MsgBox(ex.Message)
        End Try
    End Sub
 what can u suggest me
tnx

I think you should be using a datarepeater for this purpose.

Regards
Ganesh

I mean Repeater with paging.

Regards
Ganesh

hi Ganesh,
im using vb.net for windows application

Sorry, I am not quite familiar with windows development in .net

Regards
Ganesh

ok tnx niway