Torna al Thread

Sub ImportTable() 'Ricavo il datatable da remoto Dim DtRemote As New DataTable DtRemote = ClassRemoteDb.GetTable() 'Funzione che restituisce il datatable con i dati da importare Dim Cn As New OleDbConnection(vLocalCnString) Dim Da As OleDbDataAdapter = New OleDbDataAdapter("SELECT * FROM " & vNomeTabella, Cn) Dim Ds As DataSet = New DataSet(vNomeTabella) Da.FillSchema(Ds, SchemaType.Source, vNomeTabella) Da.Fill(Ds, vNomeTabella) Dim Dt As DataTable = New DataTable Dt = Ds.Tables(vNomeTabella) For Each DrDt As DataRow In DtRemote.Rows Dim Dr As DataRow Dr = Dt.NewRow For Each ColDt As DataColumn In DtRemote.Columns Dr(ColDt.ColumnName) = DrDt(ColDt.ColumnName) Next Dt.Rows.Add(Dr) Dim CmdBuild As OleDbCommandBuilder = New OleDbCommandBuilder(Da) Next Da.Update(Ds, vNomeTabella) Ds.AcceptChanges() End Sub
Copyright © dotNetHell.it 2002-2025
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5