Solved

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

Posted on 2011-09-16
9
322 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
C# XML Get Values 4 35
vb.net background worker crossthread 11 30
ASP.NET data base connection 35 43
Stop Git from being my repository 1 26
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…

726 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