how to add autonumber column in datagridview vb.net

Question

_{Tuesday, February 12, 2019 10:35 AM}

Hi

Read the table from MySql Database

    Public Sub ReadPinFP()
        OpenCompanyDB()

        ds = New DataSet
        tables = ds.Tables
        da = New MySqlDataAdapter("Select * from PFP", myConnection2) 'Change items to your database name
        da.Fill(ds, "PFP") 'Change items to your database name
        Dim view As New DataView(tables(0))
        source2.DataSource = view

        DataGridView1.DataSource = view
        DataGridView1.Columns(0).HeaderText = "Code"
        DataGridView1.Columns(1).HeaderText = "Details"
        DataGridView1.Columns(1).Width = 200

        DataGridView1.Refresh()

        CloseCompanyDB()
    End Sub

I want the first column to have a column with autonumber like this

        DataGridView1.Columns(0).HeaderText = "AutoNumber"

        DataGridView1.Columns(1).HeaderText = "Code"
        DataGridView1.Columns(2).HeaderText = "Details"
        DataGridView1.Columns(2).Width = 200

Autonumber Code Details

                1  1234 qwerty

                2  2345 wertyu

How to do it?

All replies (2)

_{Tuesday, February 12, 2019 10:54 AM ✅Answered}

Hi Apostolos Doudakmanis,

I'm afraid you cannot make a column AutoNumber (numbering automatically).
But you can give number in a column by code. 

There are two ways to give number at left of DataGridView.
(1) insert a column at columns(0) and number it.

For rowNum As Integer = 0 To DataGridView1.Rows.Count - 1
    DataGridView1(0, rowNum) = (rowNum + 1).ToString
Next

(2) use HeaderCell for numbering.

For rowNum As Integer = 0 To DataGridView1.Rows.Count - 1
    DataGridView1.Rows(rowNum).HeaderCell.Value = (rowNum + 1).ToString
Next

I usually use (2).
     

Regards,

Ashidacchi -- https://ssl01.rocketnet.jp/hokusosha.com/default.html

---

_{Tuesday, February 12, 2019 11:08 AM}

This i wanted it

Thank you