copy datarow – My Programming Notes

Tag Archives: copy datarow

C# || How To Copy DataTable DataRow From One DataRow To Another Using C#

May 13, 2021 admin No comments

The following is a module with functions which demonstrates how to copy a DataTable DataRow from one DataRow to another using C#.

The function demonstrated on this page is an extension method, which copies all matching columns from the source DataRow to the destination DataRow. If no matching column exists between the two rows, the data at that column is skipped. This allows to safely copy a single row from one DataTable to other.

1. Copy DataRow

The example below demonstrates the use of ‘Utils.Collections.Extensions.CopyTo‘ to copy all matching columns from a source row to a destination row.





		
		
			1. Copy DataRow
			
C#
			
			// Copy DataRow

using Utils.Collections;

// Declare the source datatable 
var table1 = new DataTable();
table1.Columns.Add("Name", typeof(string));

table1.Rows.Add("Kenneth");
table1.Rows.Add("Jennifer");
table1.Rows.Add("Lynn");
table1.Rows.Add("Sole");
table1.Rows.Add(System.DBNull.Value);

// Declare the destination datatable
var table2 = new DataTable();
table2.Columns.Add("Id", typeof(int));
table2.Columns.Add("Name", typeof(string));

for (var index = 0; index < table1.Rows.Count; ++index) {
    // Get the source row
    var rowSource = table1.Rows[index];

    // Get the destination row
    var rowDestination = table2.NewRow();

    // Do something with the destination row
    rowDestination["Id"] = index + 1;

    // Copy contents from source to destination
    rowSource.CopyTo(rowDestination);

    table2.Rows.Add(rowDestination);
}

// Display information from destination table
foreach (DataRow row in table2.Rows) {
    Console.WriteLine($"Id: {row["Id"]}, Name: {row["Name"]}");
}

// expected output:
/*
    Id: 1, Name: Kenneth
    Id: 2, Name: Jennifer
    Id: 3, Name: Lynn
    Id: 4, Name: Sole
    Id: 5, Name: 
*/
			
				
					
				
					1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
				
						// Copy DataRow
 
using Utils.Collections;
 
// Declare the source datatable 
var table1 = new DataTable();
table1.Columns.Add("Name", typeof(string));
 
table1.Rows.Add("Kenneth");
table1.Rows.Add("Jennifer");
table1.Rows.Add("Lynn");
table1.Rows.Add("Sole");
table1.Rows.Add(System.DBNull.Value);
 
// Declare the destination datatable
var table2 = new DataTable();
table2.Columns.Add("Id", typeof(int));
table2.Columns.Add("Name", typeof(string));
 
for (var index = 0; index < table1.Rows.Count; ++index) {
    // Get the source row
    var rowSource = table1.Rows[index];
 
    // Get the destination row
    var rowDestination = table2.NewRow();
 
    // Do something with the destination row
    rowDestination["Id"] = index + 1;
 
    // Copy contents from source to destination
    rowSource.CopyTo(rowDestination);
 
    table2.Rows.Add(rowDestination);
}
 
// Display information from destination table
foreach (DataRow row in table2.Rows) {
    Console.WriteLine($"Id: {row["Id"]}, Name: {row["Name"]}");
}
 
// expected output:
/*
    Id: 1, Name: Kenneth
    Id: 2, Name: Jennifer
    Id: 3, Name: Lynn
    Id: 4, Name: Sole
    Id: 5, Name: 
*/

2. Utils Namespace

The following is the Utils Namespace. Include this in your project to start using!





		
		
			Utils Namespace
			
C#
			
			// ============================================================================
//    Author: Kenneth Perkins
//    Date:   May 13, 2021
//    Taken From: http://programmingnotes.org/
//    File:  Utils.cs
//    Description: Handles general utility functions
// ============================================================================
using System;
using System.Data;

namespace Utils {
    namespace Collections {
        public static class Extensions {
            /// <summary>
            /// Copies all matching columns from the source row to the destination row
            /// </summary>
            /// <param name="source">The DataRow source</param>
            /// <param name="destination">The DataRow destination</param>
            public static void CopyTo(this DataRow source, DataRow destination) {
                foreach (DataColumn col in source.Table.Columns) {
                    if (destination.Table.Columns.Contains(col.ColumnName)) {
                        destination[col.ColumnName] = source[col.ColumnName];
                    }
                }
            }
        }
    }
}
			
				
					
				
					1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
				
						// ============================================================================
//    Author: Kenneth Perkins
//    Date:   May 13, 2021
//    Taken From: http://programmingnotes.org/
//    File:  Utils.cs
//    Description: Handles general utility functions
// ============================================================================
using System;
using System.Data;
 
namespace Utils {
    namespace Collections {
        public static class Extensions {
            /// <summary>
            /// Copies all matching columns from the source row to the destination row
            /// </summary>
            /// <param name="source">The DataRow source</param>
            /// <param name="destination">The DataRow destination</param>
            public static void CopyTo(this DataRow source, DataRow destination) {
                foreach (DataColumn col in source.Table.Columns) {
                    if (destination.Table.Columns.Contains(col.ColumnName)) {
                        destination[col.ColumnName] = source[col.ColumnName];
                    }
                }
            }
        }
    }
}

3. More Examples

Below are more examples demonstrating the use of the ‘Utils‘ Namespace. Don’t forget to include the module when running the examples!





		
		
			More Examples
			
C#
			
			// ============================================================================
//    Author: Kenneth Perkins
//    Date:   May 13, 2021
//    Taken From: http://programmingnotes.org/
//    File:  Program.cs
//    Description: The following demonstrates the use of the Utils Namespace
// ============================================================================
using System;
using System.Diagnostics;
using Utils.Collections;
using System.Data;

public class Program {
    static void Main(string[] args) {
        try {
            // Declare the source datatable 
            var table1 = new DataTable();
            table1.Columns.Add("Name", typeof(string));

            table1.Rows.Add("Kenneth");
            table1.Rows.Add("Jennifer");
            table1.Rows.Add("Lynn");
            table1.Rows.Add("Sole");
            table1.Rows.Add(System.DBNull.Value);

            // Declare the destination datatable
            var table2 = new DataTable();
            table2.Columns.Add("Id", typeof(int));
            table2.Columns.Add("Name", typeof(string));

            for (var index = 0; index < table1.Rows.Count; ++index) {
                // Get the source row
                var rowSource = table1.Rows[index];

                // Get the destination row
                var rowDestination = table2.NewRow();

                // Do something with the destination row
                rowDestination["Id"] = index + 1;

                // Copy contents from source to destination
                rowSource.CopyTo(rowDestination);

                table2.Rows.Add(rowDestination);
            }

            // Display information from destination table
            foreach (DataRow row in table2.Rows) {
                Display($"Id: {row["Id"]}, Name: {row["Name"]}");
            }
        } catch (Exception ex) {
            Display(ex.ToString());
        } finally {
            Console.ReadLine();
        }
    }

    static void Display(string message) {
        Console.WriteLine(message);
        Debug.Print(message);
    }
}// http://programmingnotes.org/
			
				
					
				
					1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
				
						// ============================================================================
//    Author: Kenneth Perkins
//    Date:   May 13, 2021
//    Taken From: http://programmingnotes.org/
//    File:  Program.cs
//    Description: The following demonstrates the use of the Utils Namespace
// ============================================================================
using System;
using System.Diagnostics;
using Utils.Collections;
using System.Data;
 
public class Program {
    static void Main(string[] args) {
        try {
            // Declare the source datatable 
            var table1 = new DataTable();
            table1.Columns.Add("Name", typeof(string));
 
            table1.Rows.Add("Kenneth");
            table1.Rows.Add("Jennifer");
            table1.Rows.Add("Lynn");
            table1.Rows.Add("Sole");
            table1.Rows.Add(System.DBNull.Value);
 
            // Declare the destination datatable
            var table2 = new DataTable();
            table2.Columns.Add("Id", typeof(int));
            table2.Columns.Add("Name", typeof(string));
 
            for (var index = 0; index < table1.Rows.Count; ++index) {
                // Get the source row
                var rowSource = table1.Rows[index];
 
                // Get the destination row
                var rowDestination = table2.NewRow();
 
                // Do something with the destination row
                rowDestination["Id"] = index + 1;
 
                // Copy contents from source to destination
                rowSource.CopyTo(rowDestination);
 
                table2.Rows.Add(rowDestination);
            }
 
            // Display information from destination table
            foreach (DataRow row in table2.Rows) {
                Display($"Id: {row["Id"]}, Name: {row["Name"]}");
            }
        } catch (Exception ex) {
            Display(ex.ToString());
        } finally {
            Console.ReadLine();
        }
    }
 
    static void Display(string message) {
        Console.WriteLine(message);
        Debug.Print(message);
    }
}// http://programmingnotes.org/

QUICK NOTES:
The highlighted lines are sections of interest to look out for.

The code is heavily commented, so no further insight is necessary. If you have any questions, feel free to leave a comment below.

VB.NET || How To Copy DataTable DataRow From One DataRow To Another Using VB.NET

November 29, 2020 admin No comments

The following is a module with functions which demonstrates how to copy a DataTable DataRow from one DataRow to another using VB.NET.

1. Copy DataRow

The example below demonstrates the use of ‘Utils.Collections.CopyTo‘ to copy all matching columns from a source row to a destination row.





		
		
			1. Copy DataRow
			
Visual Basic .NET
			
			' Copy DataRow

Imports Utils.Collections

' Declare the source datatable 
Dim table1 = New DataTable
table1.Columns.Add("Name", GetType(String))

table1.Rows.Add("Kenneth")
table1.Rows.Add("Jennifer")
table1.Rows.Add("Lynn")
table1.Rows.Add("Sole")
table1.Rows.Add(System.DBNull.Value)

' Declare the destination datatable
Dim table2 = New DataTable
table2.Columns.Add("Id", GetType(Integer))
table2.Columns.Add("Name", GetType(String))

For index = 0 To table1.Rows.Count - 1
    ' Get the source row
    Dim rowSource = table1.Rows(index)

    ' Get the destination row
    Dim rowDestination = table2.NewRow

    ' Do something with the destination row
    rowDestination("Id") = index + 1

    ' Copy contents from source to destination
    rowSource.CopyTo(rowDestination)

    table2.Rows.Add(rowDestination)
Next

' Display information from destination table
For Each row As DataRow In table2.Rows
    Debug.Print($"Id: {row("Id")}, Name: {row("Name")}")
Next

' expected output:
'    Id: 1, Name: Kenneth
'    Id: 2, Name: Jennifer
'    Id: 3, Name: Lynn
'    Id: 4, Name: Sole
'    Id: 5, Name: 
			
				
					
				
					1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
				
						' Copy DataRow
 
Imports Utils.Collections
 
' Declare the source datatable 
Dim table1 = New DataTable
table1.Columns.Add("Name", GetType(String))
 
table1.Rows.Add("Kenneth")
table1.Rows.Add("Jennifer")
table1.Rows.Add("Lynn")
table1.Rows.Add("Sole")
table1.Rows.Add(System.DBNull.Value)
 
' Declare the destination datatable
Dim table2 = New DataTable
table2.Columns.Add("Id", GetType(Integer))
table2.Columns.Add("Name", GetType(String))
 
For index = 0 To table1.Rows.Count - 1
    ' Get the source row
    Dim rowSource = table1.Rows(index)
 
    ' Get the destination row
    Dim rowDestination = table2.NewRow
 
    ' Do something with the destination row
    rowDestination("Id") = index + 1
 
    ' Copy contents from source to destination
    rowSource.CopyTo(rowDestination)
 
    table2.Rows.Add(rowDestination)
Next
 
' Display information from destination table
For Each row As DataRow In table2.Rows
    Debug.Print($"Id: {row("Id")}, Name: {row("Name")}")
Next
 
' expected output:
'    Id: 1, Name: Kenneth
'    Id: 2, Name: Jennifer
'    Id: 3, Name: Lynn
'    Id: 4, Name: Sole
'    Id: 5, Name:

2. Utils Namespace

The following is the Utils Namespace. Include this in your project to start using!





		
		
			Utils Namespace
			
Visual Basic .NET
			
			' ============================================================================
'    Author: Kenneth Perkins
'    Date:   Nov 29, 2020
'    Taken From: http://programmingnotes.org/
'    File: Utils.vb
'    Description: Handles general utility functions
' ============================================================================
Option Strict On
Option Explicit On

Namespace Global.Utils
    Namespace Collections
        Public Module modCollections
            ''' <summary>
            ''' Copies all matching columns from the source row to the destination row
            ''' </summary>
            ''' <param name="source">The DataRow source</param>
            ''' <param name="destination">The DataRow destination</param> 
            <Runtime.CompilerServices.Extension()>
            Public Sub CopyTo(source As DataRow, destination As DataRow)
                For Each col As DataColumn In source.Table.Columns
                    If destination.Table.Columns.Contains(col.ColumnName) Then
                        destination(col.ColumnName) = source(col.ColumnName)
                    End If
                Next
            End Sub
        End Module
    End Namespace
End Namespace ' http://programmingnotes.org/
			
				
					
				
					1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
				
						' ============================================================================
'    Author: Kenneth Perkins
'    Date:   Nov 29, 2020
'    Taken From: http://programmingnotes.org/
'    File: Utils.vb
'    Description: Handles general utility functions
' ============================================================================
Option Strict On
Option Explicit On
 
Namespace Global.Utils
    Namespace Collections
        Public Module modCollections
            ''' <summary>
            ''' Copies all matching columns from the source row to the destination row
            ''' </summary>
            ''' <param name="source">The DataRow source</param>
            ''' <param name="destination">The DataRow destination</param> 
            <Runtime.CompilerServices.Extension()>
            Public Sub CopyTo(source As DataRow, destination As DataRow)
                For Each col As DataColumn In source.Table.Columns
                    If destination.Table.Columns.Contains(col.ColumnName) Then
                        destination(col.ColumnName) = source(col.ColumnName)
                    End If
                Next
            End Sub
        End Module
    End Namespace
End Namespace ' http://programmingnotes.org/

3. More Examples

Below are more examples demonstrating the use of the ‘Utils‘ Namespace. Don’t forget to include the module when running the examples!





		
		
			More Examples
			
Visual Basic .NET
			
			' ============================================================================
'    Author: Kenneth Perkins
'    Date:   Nov 29, 2020
'    Taken From: http://programmingnotes.org/
'    File: Program.vb
'    Description: The following demonstrates the use of the Utils Namespace
' ============================================================================
Option Strict On
Option Explicit On
Imports System
Imports Utils.Collections

Public Module Program
    Sub Main(args As String())
        Try
            ' Declare the source datatable 
            Dim table1 = New DataTable
            table1.Columns.Add("Name", GetType(String))

            table1.Rows.Add("Kenneth")
            table1.Rows.Add("Jennifer")
            table1.Rows.Add("Lynn")
            table1.Rows.Add("Sole")
            table1.Rows.Add(System.DBNull.Value)

            ' Declare the destination datatable
            Dim table2 = New DataTable
            table2.Columns.Add("Id", GetType(Integer))
            table2.Columns.Add("Name", GetType(String))

            For index = 0 To table1.Rows.Count - 1
                ' Get the source row
                Dim rowSource = table1.Rows(index)

                ' Get the destination row
                Dim rowDestination = table2.NewRow

                ' Do something with the destination row
                rowDestination("Id") = index + 1

                ' Copy contents from source to destination
                rowSource.CopyTo(rowDestination)

                table2.Rows.Add(rowDestination)
            Next

            ' Display information from destination table
            For Each row As DataRow In table2.Rows
                Display($"Id: {row("Id")}, Name: {row("Name")}")
            Next
        Catch ex As Exception
            Display(ex.ToString)
        Finally
            Console.ReadLine()
        End Try
    End Sub

    Public Sub Display(message As String)
        Console.WriteLine(message)
        Debug.Print(message)
    End Sub
End Module ' http://programmingnotes.org/
			
				
					
				
					1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
				
						' ============================================================================
'    Author: Kenneth Perkins
'    Date:   Nov 29, 2020
'    Taken From: http://programmingnotes.org/
'    File: Program.vb
'    Description: The following demonstrates the use of the Utils Namespace
' ============================================================================
Option Strict On
Option Explicit On
Imports System
Imports Utils.Collections
 
Public Module Program
    Sub Main(args As String())
        Try
            ' Declare the source datatable 
            Dim table1 = New DataTable
            table1.Columns.Add("Name", GetType(String))
 
            table1.Rows.Add("Kenneth")
            table1.Rows.Add("Jennifer")
            table1.Rows.Add("Lynn")
            table1.Rows.Add("Sole")
            table1.Rows.Add(System.DBNull.Value)
 
            ' Declare the destination datatable
            Dim table2 = New DataTable
            table2.Columns.Add("Id", GetType(Integer))
            table2.Columns.Add("Name", GetType(String))
 
            For index = 0 To table1.Rows.Count - 1
                ' Get the source row
                Dim rowSource = table1.Rows(index)
 
                ' Get the destination row
                Dim rowDestination = table2.NewRow
 
                ' Do something with the destination row
                rowDestination("Id") = index + 1
 
                ' Copy contents from source to destination
                rowSource.CopyTo(rowDestination)
 
                table2.Rows.Add(rowDestination)
            Next
 
            ' Display information from destination table
            For Each row As DataRow In table2.Rows
                Display($"Id: {row("Id")}, Name: {row("Name")}")
            Next
        Catch ex As Exception
            Display(ex.ToString)
        Finally
            Console.ReadLine()
        End Try
    End Sub
 
    Public Sub Display(message As String)
        Console.WriteLine(message)
        Debug.Print(message)
    End Sub
End Module ' http://programmingnotes.org/

QUICK NOTES:
The highlighted lines are sections of interest to look out for.

The code is heavily commented, so no further insight is necessary. If you have any questions, feel free to leave a comment below.

Tag Archives: copy datarow

C# || How To Copy DataTable DataRow From One DataRow To Another Using C#

VB.NET || How To Copy DataTable DataRow From One DataRow To Another Using VB.NET

Search

Compile Your Code Now

Translate Page

Popular Pages

Recent

Archives

Categories