Solved

How to copy from one  datable to another in Vb.net

Posted on 2011-09-16
9
320 Views
Last Modified: 2012-05-12
I need to copy one datatable (dt) to another datatble (dt2), dataset or Data view in VB.NET.
  and I want to skip first  first row  in dt, and copy rest of the rows in dt2.
0
Comment
Question by:Ammar Iqbal
9 Comments
 
LVL 16

Accepted Solution

by:
disrupt earned 167 total points
ID: 36549588
0
 
LVL 1

Author Comment

by:Ammar Iqbal
ID: 36549601
This thing I know, but i do not want to copy all data. I need to skip first row  , and copy rest of the rows
0
 
LVL 16

Expert Comment

by:disrupt
ID: 36549602
in the copy you can delete the first row as so:

http://msdn.microsoft.com/en-us/library/feh3ed13(v=VS.100).aspx
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
LVL 16

Expert Comment

by:disrupt
ID: 36549632
You can either delete the first row using example above  or use LINQ to manipulate the data in the datatable as so:

http://dotnetarchitect.wordpress.com/2009/03/18/using-linq-to-manipulate-data-in-datasetdatatable/
0
 
LVL 1

Author Comment

by:Ammar Iqbal
ID: 36549637
i am using .NET framework 2.0, and linq is not included in it
0
 
LVL 16

Expert Comment

by:disrupt
ID: 36549665
you should be able to still remove the first row...using the other example...
0
 
LVL 16

Expert Comment

by:disrupt
ID: 36549666
0
 
LVL 15

Assisted Solution

by:x77
x77 earned 166 total points
ID: 36549813
Use ImportRow For each Row you can copy:

    Dim Rows = T1.Select
    For N = 1 To Rows.Length - 1
        t2.ImportRow(Rows(N))
    Next

This copy not deleted rows (T1.Select), skiping First row.

Note that you can Filter or Sort using Select.
Note that this method also copy RowState (DataRowVersion.Current and DataRowVersion.Original)
0
 

Assisted Solution

by:soniczoo
soniczoo earned 167 total points
ID: 36552371

Dim dt2 As DataTable = dt.Clone()
dt2.Rows.RemoveAt(0)
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question