Public Function dvtodt(ByVal dv As DataGridView) As DataTable
Dim dt As New DataTable()
Dim dc As DataColumn
For i As Integer = 0 To dv.Columns.Count - 1
dc = New DataColumn()
dc.ColumnName = dv.Columns(i).HeaderText.ToString()
dt.Columns.Add(dc)
Next
For j As Integer = 0 To dv.Rows.Count - 2
Dim dr As DataRow = dt.NewRow()
For x As Integer = 0 To dv.Columns.Count - 1
dr(x) = dv.Rows(j).Cells(x).Value
Next
dt.Rows.Add(dr)
Next
Return dt
End Function
Dim dt As New DataTable()
Dim dc As DataColumn
For i As Integer = 0 To dv.Columns.Count - 1
dc = New DataColumn()
dc.ColumnName = dv.Columns(i).HeaderText.ToString()
dt.Columns.Add(dc)
Next
For j As Integer = 0 To dv.Rows.Count - 2
Dim dr As DataRow = dt.NewRow()
For x As Integer = 0 To dv.Columns.Count - 1
dr(x) = dv.Rows(j).Cells(x).Value
Next
dt.Rows.Add(dr)
Next
Return dt
End Function
本文介绍了一种将DataGridView控件中的数据转换为DataTable的方法。通过Visual Basic.NET实现,此过程包括创建新的DataTable实例,从DataGridView中复制列名并填充数据。
7151

被折叠的 条评论
为什么被折叠?



