CODEWITHSUNDEEP
c#asp.netdatagrid
Cát Tường Vy
Cát Tường Vy

Reputation: 398

Numbering sequence number in DataGrid ASP.NET?

I tried to mark numbering in DataGrid ASP.NET control but unsuccessfully. Some guys show me the link that look like working but it does not work for me. Please help - DataGrid not GridView or DataList.

<Columns>
    <asp:TemplateColumn ItemStyle-CssClass="tdCenter">
        <HeaderTemplate> No.</HeaderTemplate>
        <asp:ItemTemplate>   
           <%# (grdAttDetails.PageSize * grdAttDetails.CurrentPageIndex)   + Container.ItemIndex + 1%> 
         </asp:ItemTemplate>
    </asp:TemplateColumn>
</Columns>

Upvotes: 1

Views: 718

Answers (2)

jsanalytics
jsanalytics

Reputation: 13188

Datagrid:

<asp:DataGrid ID="DataGrid1" runat="server" DataSourceID="SqlDataSource1">
    <Columns>
        <asp:TemplateColumn HeaderText="RowCount">
            <ItemTemplate>
                    <%# (DataGrid1.PageSize * DataGrid1.CurrentPageIndex) + Container.ItemIndex + 1%>
            </ItemTemplate>
        </asp:TemplateColumn>
    </Columns>
</asp:DataGrid>

PageIndexChanged Event:

        protected void DataGrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
        {
            DataGrid1.CurrentPageIndex = e.NewPageIndex;
            DataGrid1.DataBind();
        }

Result:

enter image description here

Result with paging:

Page 1:

enter image description here

Page 2:

enter image description here

Upvotes: 1

Vishal Shrestha
Vishal Shrestha

Reputation: 354

Generate Sequence Number in Datagrid from SQL:

SELECT ROW_NUMBER() OVER(ORDER BY ID DESC) AS SeqNumber FROM TABLE_NAME

AND Bind DataGrid as,

<%#DataBinder.Eval(Container.DataItem,"SeqNumber")%>

just try it and please let me know weather it works or not..

Upvotes: 1

Related Questions