how to add autonumber column in datagridview vb.net

[Apostolos Doudakmanis]

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


How to do it?

Continue reading...