Show row number in row header of a DataGridView

Question

Is it possible to show row number in the row header of a DataGridView           I m trying with this code  but it doesn t work       private void setRowNumber DataGridView dgv                foreach  DataGridViewRow row in dgv Rows                        row HeaderCell Value   row Index   1                    Do I have to set some DataGridView property

User · Answer

This work in C    private void dataGridView1 CellFormatting object sender  DataGridViewCellFormattingEventArgs e        int idx   e RowIndex      DataGridViewRow row   dataGridView1 Rows idx       long newNo   idx      if    RowNumberStartFromZero          newNo    1       long oldNo   -1      if  row HeaderCell Value    null                if  IsNumeric row HeaderCell Value                         oldNo   System Convert ToInt64 row HeaderCell Value                        if  newNo    oldNo                row HeaderCell Value   newNo ToString            row HeaderCell Style Alignment   DataGridViewContentAlignment MiddleRight

User · Answer

Based on this viedo  VB net-Auto generate row number to datagridview in windows application-winforms  you can set the DataSource and this code puts the rows numbers  works like a charm  private void DataGrid CellFormatting object sender  DataGridViewCellFormattingEventArgs e           Add row number      sender as DataGridView  Rows e RowIndex  HeaderCell Value    e RowIndex 1  ToString

User · Answer

private void setRowNumber DataGridView dgv        foreach  DataGridViewRow row in dgv Rows                row HeaderCell Value    row Index   1  ToString              This worked for me

User · Answer

private void ShowRowNumber DataGridView dataGridView       dataGridView RowHeadersWidth   50     for  int i   0  i  lt  dataGridView Rows Count  i                 dataGridView Rows i  HeaderCell Value    i   1  ToString

User · Answer

Thanks  Gabriel-Perez and  Groo  great idea  In case others want it  here s a version in VB tested in Visual Studio 2012  In my case I wanted the numbers to appear top right aligned in the Row Header   Private Sub MyDGV RowPostPaint sender As Object        e As DataGridViewRowPostPaintEventArgs  Handles MyDataGridView RowPostPaint        Automatically maintains a Row Header Index Number          like the Excel row number  independent of sort order      Dim grid As DataGridView   CType sender  DataGridView      Dim rowIdx As String    e RowIndex   1  ToString       Dim rowFont As New System Drawing Font  Tahoma   8 0             System Drawing FontStyle Bold            System Drawing GraphicsUnit Point  CType 0  Byte        Dim centerFormat   New StringFormat       centerFormat Alignment   StringAlignment Far     centerFormat LineAlignment   StringAlignment Near      Dim headerBounds As Rectangle   New Rectangle           e RowBounds Left  e RowBounds Top            grid RowHeadersWidth  e RowBounds Height      e Graphics DrawString rowIdx  rowFont  SystemBrushes ControlText            headerBounds  centerFormat  End Sub   You can also get the default font  rowFont   grid RowHeadersDefaultCellStyle Font  but it might not look as good  The screenshot below is using the Tahoma font

User · Answer

just enhancing above solution   so header it self resize its width in order to accommodate lengthy string like 12345   private void advancedDataGridView1 RowPostPaint object sender  DataGridViewRowPostPaintEventArgs e        var grid   sender as DataGridView      var rowIdx    e RowIndex   1  ToString         var centerFormat   new StringFormat                    right alignment might actually make more sense for numbers         Alignment   StringAlignment Center           LineAlignment   StringAlignment Center              get the size of the string     Size textSize   TextRenderer MeasureText rowIdx  this Font         if header width lower then string width then resize     if  grid RowHeadersWidth  lt  textSize Width   40                grid RowHeadersWidth   textSize Width   40            var headerBounds   new Rectangle e RowBounds Left  e RowBounds Top  grid RowHeadersWidth  e RowBounds Height       e Graphics DrawString rowIdx  this Font  SystemBrushes ControlText  headerBounds  centerFormat

User · Answer

This worked for me   Private Sub GridView1 CellFormatting sender As Object  e As DataGridViewCellFormattingEventArgs  Handles GridView1 CellFormatting     Dim idx As Integer   e RowIndex     Dim row As DataGridViewRow   VDataGridView1 Rows idx      Dim newNo As Long   idx     If Not  RowNumberStartFromZero Then         newNo    1     End If      Dim oldNo As Long   -1     If row HeaderCell Value IsNot Nothing Then         If IsNumeric row HeaderCell Value  Then             oldNo   CLng row HeaderCell Value          End If     End If      If newNo  lt  gt  oldNo Then  only change if it s wrong or not set         row HeaderCell Value   newNo ToString           row HeaderCell Style Alignment   DataGridViewContentAlignment MiddleRight     End If End Sub

User · Answer

row HeaderCell Value   row Index   1   when applied on datagridview with a very large number of rows creates a memory leak and eventually will result in an out of memory issue   Any ideas how to reclaim the memory   Here is sample code to apply to an empty grid with some columns   it simply adds rows and numbers the index   Repeat button click a few times   public partial class Form1   Form       public Form1                 InitializeComponent             dataGridView1 SuspendLayout            for  int i   1  i  lt  10000  i                          dataGridView1 Rows Add i                                     dataGridView1 ResumeLayout               private void button1 Click object sender  EventArgs e                foreach  DataGridViewRow row in dataGridView1 Rows              row HeaderCell Value    row Index   1  ToString

User · Answer

You can also draw the string dynamically inside the RowPostPaint event   private void dgGrid RowPostPaint object sender  DataGridViewRowPostPaintEventArgs e        var grid   sender as DataGridView      var rowIdx    e RowIndex   1  ToString         var centerFormat   new StringFormat                      right alignment might actually make more sense for numbers         Alignment   StringAlignment Center           LineAlignment   StringAlignment Center             var headerBounds   new Rectangle e RowBounds Left  e RowBounds Top  grid RowHeadersWidth  e RowBounds Height       e Graphics DrawString rowIdx  this Font  SystemBrushes ControlText  headerBounds  centerFormat

User · Answer

you can do this    private void setRowNumber DataGridView dgv        foreach  DataGridViewRow row in dgv Rows                row HeaderCell Value   row Index   1             dgv AutoResizeRowHeadersWidth DataGridViewRowHeadersWidthSizeMode AutoSizeToAllHeaders

User · Answer

It seems that it doesn t turn it into a string  Try   row HeaderCell Value   String Format   0    row Index   1

[c#] Show row number in row header of a DataGridView

Examples related to c#

Examples related to .net

Examples related to winforms

Examples related to datagridview