ASP.NET: How to insert Serial Numbers in repeater and gridview

We often need to put serial number or row number while listing data into a gridview or repeater control.

There are many methods to do this. We can do this either using C# code or directly writing in the stored procedure for retrieving the data.

By using the C# way, when using the Gridview control with paging option set,

<%#(gvResult.PageIndex * gvResult.PageSize) + (gvResult.Rows.Count + 1)%>

Use this code then you will get row number in the gridview.

when using the Repeater control (remember repeater control has no paging option in default, but we can give it with paging option set).

<%#(((RepeaterItem)Container).ItemIndex+1).ToString()%>

The above 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