Autonumber column in datatable based on number of rows

[Gokul001 (Gokul Balaji)]

Hi @Evert_Randers

How about this expression?

dataTable.Columns.Add("ID", GetType(Integer))
For i As Integer = 0 To dataTable.Rows.Count - 1
dataTable.Rows(i).Item("ID") = i + 1
Next

This will add a new column named “ID” to your DataTable and fill it with numbers starting from 1 .

You can also use an Auto-Number System column to generate an automatically incremented counter for each row that contains data

Check out the thread

How to make datatable with variable number of columns?

I’m making a datatable, but the number of columns and rows needs to be different from one run to the next. How do you make a datatable where the number of columns is a variable?

Regards
Gokul