VB.NET - Convert multi dimentional ArrayList to DataTable



Cheat sheet to Convert an ArrayList to a DataTable

Dim arrList As ArrayList = New ArrayList()
Dim dt As New DataTable()
Dim intCnt As Integer = 0

dt.Columns.Add(New DataColumn("Name", System.Type.GetType("System.String")))
dt.Columns.Add(New DataColumn("Age", System.Type.GetType("System.String")))

arrList.Add(New String() {"Jacob", "34"})
arrList.Add(New String() {"Hima", "28"})
arrList.Add(New String() {"Vamshi", "34"})
arrList.Add(New String() {"Pinal", "30"})

For Each item As Object In arrList
Dim dr As DataRow
Dim arrItem As String() = DirectCast(item, String())
dr = dt.NewRow()
dr("Name") = arrItem(0)
dr("Age") = arrItem(1)
dt.Rows.Add(dr)
Next

Share |

 Cant find the page you are looking for?
 Help us to improve by adding the content that you are looking for.
 Leave a feedback
 We look forward to hear your comments and feedback.