如何在VB.NET中将datagridview的数据转换为数据表？ [英] How to shift the data of a datagridview to a datatable in VB.NET ?

问题描述

我在VB.NET 2010中工作。

我想移动数据表中的所有数据。

简而言之，你可以说我想将datagridview与数据一起转换成数据表！



我该怎么办？



任何人都可以帮助我吗？



我的尝试：



我试过....

Hi,

I am working in VB.NET 2010.
I want to shift all the data in a datatable.
In short you can say that i want to convert my datagridview into a datatable along with the data !

How can i do this ?

Can anyone help me ?

What I have tried:

I tried ....

Public Sub Grid_to_DataTable(myGrid As DataGridView, myDataTable As DataTable)
        Try
            Dim Cols As Integer = 0
            While Cols <= myGrid.ColumnCount - 1
                myDataTable.Columns.Add(myGrid.Columns(Cols).Name, myGrid.Columns(Cols).CellType)
                Cols = Cols + 1
            End While
            myDataTable = myGrid.DataSource

        Catch ex As Exception
            MessageBox.Show(ex.Message, "Grid_to_DataTable", MessageBoxButtons.OK, MessageBoxIcon.Exclamation)
        End Try
    End Sub

推荐答案

试试这个

Try This

Dim NewTable As DataTable = DirectCast(DataGridView1.DataSource, DataTable)

这篇关于如何在VB.NET中将datagridview的数据转换为数据表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！