我需要从一个数组生成一个datatable,并需要将该数组添加到datatable的不同列中。VB.net代码类似于: DataTable.Rows.Add(ID,(A(I),i=1到100),但我知道这不起作用。有没有人可以告诉我如何做到这一点,这样我就不必像DataTable.Rows.Add(ID,A(1),A(2),.....,A(100))那样,从A(1)到A(100)列出A?提前谢谢你!
发布于 2019-04-16 05:35:27
所以要做这样的事情。
Dim table1 As New DataTable("Items")
' Add columns
Dim idColumn As New DataColumn("id", GetType(System.Int32))
table1.Columns.Add(idColumn)
For i As Integer = 1 To 100
Dim itemColumn As New DataColumn("item" & i.ToString, GetType(System.Int32))
table1.Columns.Add(itemColumn)
Next i
' Set the primary key column.
table1.PrimaryKey = New DataColumn() {idColumn}
' Add RowChanged event handler for the table.
AddHandler table1.RowChanged, AddressOf Row_Changed
' Add some rows.
Dim row As DataRow
row = table1.NewRow()
row("id") = 1
For i As Integer = 1 To 100
row("item" + i.toString) = a(i)
Next i
table1.Rows.Add(row)
' Accept changes.
table1.AcceptChanges()
https://stackoverflow.com/questions/55697234
复制相似问题