Advanced Search

Copia columnas de un datatable a otro (específicas)

/ Published in: Visual Basic
Save to your folder(s)
Copiando las columnas y la data que deseamos de un datatable a otro

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. 'Primero le copiamos la estructura del datatable 
  2. dtNuevo.Columns.Add(dtAntiguo.Columns(0).ColumnName) 'copia columna 0
  3. dtNuevo.Columns.Add(dtAntiguo.Columns(1).ColumnName) 'copia columna 1
  4.  
  5. 'Ahora copiamos la data del datatable a nuestras nuevas columnas
  6. Dim IdEmployee As String
  7. Dim nombreEmployee As String
  8.  
  9. For i As Integer = 0 To dtAntiguo.Rows.Count - 1
  10.     Dim j As Integer = dtNuevo.Rows.Count
  11.     IdEmployee= dtAntiguo.Rows(i)("idEmployee")
  12.     nombreEmployee= dtAntiguo.Rows(i)("nombreEmployee")
  13.     dtNuevo.Rows.Add(j)("idEmployee") = IdEmployee
  14.     dtNuevo.Rows(j)("nombreEmployee") = nombreEmployee
  15. Next

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.