So me again :)
In ASP.NET, how can i get a row number of the record from the table.

There is no "Row number".. there's an identity field you would either need to set or you can use an autonumber which would create an identity for you.

Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

What are you using to display the records?

If you are using a Datagrid you can use datagrid1.datakeys

This is after setting <asp:DataGrid id="datagrid1" runat="server" AutoGenerateColumns="False" DataKeyField="id" ...>

*"id" is the column name from the table.

I think that my question was not precise. What exectly I need is the position of a perticular record in a perticular table of a DataSet.

For example if the records in the table are:

id Name
1 John
2 Maria
3 Glen
6 Smith
8 Bush
13 Cathy
14 Nina

Now what exectly I need is the exect location of a name in the records. For example if I search for "Bush" then in return I need anumber indicating its location i.e. 5

Is it possible ?

That also depends on how you are sorting it. Are you using a database, hash table, or anything else?

If you are using a DataGrid or a Repeater to display the records, then you can use DataGridItem.ItemIndex or RepeaterItem.ItemIndex to get the row number.

Manish Jadhav

I am using the DataSet in a class and to sort the data I am just usin the ORDER BY clause of the query that is used to create the DataSet.

I need to use it in some ASP.NET pages.

I basically need to create a utility method that has a signature like this:

  Public Function GetRowPosition(ByVal TableName As String, ByVal ColumnName As String, ByVal SearchKey As String) As Integer

I will use this method like this:

Dim Position As Integer = GetRowPosition("Table1", "Column1", "Bush")

and the value in the variable Position should be 5 according to the records in the table.

I am not using any GUIs and it must be in a plain simple class.