How to display row numbers in GridView,urgently required

Question

Hi,

I need this very badly.

I am using a datagridview for which the datasource is a dataview. This dataview is assigned with a datatable from database.

I am able to display the row numbers for the gridview by adding new column like shown below:

            int rowcount = table1.Rows.Count;
            table1.Columns.Add(new DataColumn("SNO", typeof(int)));

            for (int i = 1; i <= rowcount; i++)
            {
                table1.Rows[i - 1]["SNO"] = i;
            }

But main problem arised when i sort any another colum , the "SNO" also gets sorted with row numbers not in proper order. Like if I sort by name then row numbers are displyed like 3,2,1 ..

Even when i use Dataview's row filter, only few columns are displayed with previous rownumbers. Suppose, after row filter we are left with only last two columns, then the Row numbers are displayed as 2,3 but '1' is missing because it was filtered in rowfilter.

But I want 1,2 to be displayed there.

Please can any one help. Thanks in Advance,

Sukanya.

Answer 1

If all you want is to display the rank of each row in the current gridview, then you should be able to modify the data binding to hook to some rank-generating code instead of trying to put the data into the dataset.

Answer 2

Hi,

If you want to show the rank in the current data table, you can add a public property to your datarow class that returns the rank and you can then bind this property to the column of the gridview.

Regards,
Charles

Answer 3

You can display the row numbers like shown below:

//To add First column as rownumber
DataGridViewTextBoxCell newCell = new DataGridViewTextBoxCell();
DataGridViewColumn SNOCol = new DataGridViewColumn(newCell);
SNOCol.DisplayIndex = 0;
SNOCol.HeaderText = "SNO";
SNOCol.Name = "SNO";
DataGridView1.Columns.Add(SNOCol);

int cnt = DataGridView1.Rows.Count;
int i;
for (i = 1; i <= cnt; i++)
{
DataGridView1.Rows[i - 1].Cells["SNO"].Value = i;
}

Now during sorting or filtering, just remove the cell from datagridview and again add it.

Answer 4

Try using this...

it worked for me...

 

<asp:TemplateField>
  <ItemTemplate>
    <%# Container.DataItemIndex + 1 %>
  </ItemTemplate>
</asp:TemplateField>

Answer 5

Very elegant -- thanks for posting this.

Answer 6

Awesome! Thank You Venus Lazarus 

Answer 7

Thanks a ton venus, just what i was looking for. very helpful

Answer 8

i dun know where to put this code and what each means
please guide me,
thanks

Answer 9

Thanks for a good idea, Venus!
I've upgraded your variant to be used with paging. :-)

Code Snippet

<asp:TemplateField HeaderText="#">
    <ItemTemplate>
        <%# (((GridView)((GridViewRow)Container).Parent.Parent).PageIndex) * ((GridView)((GridViewRow)Container).Parent.Parent).PageSize + Container.DataItemIndex + 1 %>.
    </ItemTemplate>
</asp:TemplateField>

Answer 10

Same problem, but cannot use above solution since the grid is being created dynamically.  I need to add the row numbers via VB code.  Can someone provide the VB code equivalent to the above template solution for showing row numbers in a DataGrid? 

 

(ps - the row numbers cannot be limited to a default of 1-n since I'm paging results on the back end, it has to show the current start number for the current sort order and paged result).

 

 

Answer 11

Thank you very much.

<asp:TemplateField>
  <ItemTemplate>
    <%# Container.DataItemIndex + 1 %>
  </ItemTemplate>
</asp:TemplateField>

It worked for me too...

Answer 12

Thanks for a good idea, Venus!
I've upgraded your variant to be used with paging. :-)

Code Snippet

<asp:TemplateField HeaderText="#">
    <ItemTemplate>
        <%# (((GridView)((GridViewRow)Container).Parent.Parent).PageIndex) * ((GridView)((GridViewRow)Container).Parent.Parent).PageSize + Container.DataItemIndex + 1 %>.
    </ItemTemplate>
</asp:TemplateField>

Can be simplified :)

<asp:TemplateField HeaderText="#">
    <ItemTemplate>
        <%# {GridViewID}.PageIndex * {GridViewID}.PageSize + Container.DataItemIndex + 1 %>.
    </ItemTemplate>
</asp:TemplateField>

Answer 13

Hi Denis

What you have contributed is good but there's a mistake.

The dataitemindex doesnt start from 0 for every page of data. It actually continues from the last page i.e if your page size is 20, the dataitemindex for the first row of next page will be 21(adding 1 to avoid starting S. No. from 0) . The expression you gave would result in wrong S.No from the second page onward. So, if you need to add a S. No. column that continues the count from the last page, the expression would simply be:

<%# Container.DataItemIndex+1 %>

In other case if you wish the S.No to start from 1 for every page, the expression would be:

<%# ((GridViewRow) Container).RowIndex+1 %>

Answer 14

It was very useful, Thanks Venus