Generate Serial Number in Gridview in Asp.net

Many times we need to keep serial number in grid view as the first column, most of us get it through select query in stored procedure by making use of ROW_NUMBER() OVER (ORDER BY fieldname) but we can do the same thing in the aspx page where gridview is placed like this.

<asp:GridView runat=”server” id=”gvInspection”>

<Columns>

<asp:TemplateField>

<ItemTemplate>

<%#Container.DataItemIndex+1 %>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>