Vb.net First row as header in datatable
I have the datatable
Example:
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihQ8uAn08vhYimWGW5Tf1jk0wjXow9M0__cXohg5Z6PnnLJiiiGKUoyYdaB734nhN_0EfrTs6JNjCrDPZKs6nRDPNQCC56UhpyfT12b7NiUBinbRBXAjB6lOqZEIi5zxBCOj1EChVlXQqc/s1600/Datatable.png)
Solution:
Vb.net Code
I have the datatable
Example:
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihQ8uAn08vhYimWGW5Tf1jk0wjXow9M0__cXohg5Z6PnnLJiiiGKUoyYdaB734nhN_0EfrTs6JNjCrDPZKs6nRDPNQCC56UhpyfT12b7NiUBinbRBXAjB6lOqZEIi5zxBCOj1EChVlXQqc/s1600/Datatable.png)
Solution:
Vb.net Code
'Assign Column Name
For i As Integer = 0 To dtFinalImport.Columns.Count - 1
If dtFinalImport.Rows.Count > 0 Then
dtFinalImport.Columns(i).ColumnName = dtFinalImport.Rows(0)(i)
End If
Next
dtFinalImport.Rows(0).Delete()
dtFinalImport.AcceptChanges()
0 Comments