We often
need to put
a serial number or
a
row number while listing
the
data into a GridView or
a repeater control.
There are many methods to do this. We can do this either
by
using
a C# code or directly
by writing in the stored procedure for retrieving the data.
By using
the C#
method:
When
using the GridView control with paging option set,
<%#(gvResult.PageIndex * gvResult.PageSize) + (gvResult.Rows.Count + 1)%>
Use this code then you will get the row number in the GridView.
When using the Repeater control (remember repeater control has no paging option
in the default, but we can give it with the paging option set).
<%#(((RepeaterItem)Container).ItemIndex+1).ToString()%>
The above mentioned code will do it for you.
The third option is directly selecting the row number from the stored procedure
itself.
SELECT
ROW_NUMBER()
OVER
(ORDER
BY
ColumnName1)
As SrNo,
ColumnName1,
ColumnName2
FROM TableName
This will select the row number from the stored procedure by itself.