Odtnhj

There is a database table. (MS Access)

On the basis of the table a tree is formed.

field ID - autoincrement (formed by the database).

Scenario:

1. User. Selects the node to copy;

2. User. Selects the node where to copy;

3. Program. Gets the string of the node to be copied;

4. Program. Copies the string "2 1 0 AA Node Level_2" and the associated strings as child lines (nodes) into the node "16 13 2 CC Node Level_2", which is specified as "recipient";

5. Program. Updates the database table based on changes to the DataTable.

Question.

How to programmatically “copy” and “insert” for a specific record of the table (DataTable) and its child nodes (rows) with any nesting of nodes?

The question means how to perform clause 3, clause 4?

As a result, additional records should appear in the source table.
ID // PrID // sorting // NodeName // field_1 // field_2 // field_3

18 16 0 AA Node Level_2

19 18 0 AAA Node Level_3

20 19 0 AAAA Node Level_4

21 19 1 AAAB Node Level_4

23 19 2 AAAC Node Level_4_Изм_3

Tree based on source table

public void connect()
 
 string catBD = @"c:testvisualStudiocsharp11.accdb";
 string conBD = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=0", catBD);

 OleDbConnection connection = new OleDbConnection(conBD);

 connection.Open();

 string query1 = "SELECT * FROM TableTreeView_12_0";
 OleDbCommand cmd1 = new OleDbCommand(query1, connection);


 dt = new DataTable();

 adapter = new OleDbDataAdapter(cmd1);
 cb = new OleDbCommandBuilder(adapter);

 adapter.Fill(dt);

 

Source table
ID // PrID // sorting // NodeName // field_1 // field_2 // field_3

1 0 0 A Node Level_1_изм_2

2 1 0 AA Node Level_2

3 2 0 AAA Node Level_3

4 3 0 AAAA Node Level_4

5 3 1 AAAB Node Level_4

6 3 2 AAAC Node Level_4_Изм_3

7 1 1 AB Node Level_2

8 1 2 AC Node Level_2

9 0 1 B Node Level_1

10 9 0 BA Node Level_2

11 9 1 BB Node Level_2

12 9 2 BC Node Level_2

13 0 2 C Node Level_1

14 13 0 CA Node Level_2

15 13 1 CB Node Level_2

16 13 2 CC Node Level_2

17 13 3 CD Node Level_2