Import data one table to another table using Forloop

Question

0.00/5 (No votes)

See more:

Good Evening all of us

I have the access database.
On the database there are two tables. Then I want to import data from one table to another table

I am writing this code but it has taken error

C#

foreach (DataRow dr in sourceTable.Rows)
{
    destinationTable.ImportRow(dr);
}


////////////////////


foreach (DataRow dr in sourceTable.Rows)
{
    r = destinationTable.NewRow;
    r("Name") = dr["Name"];
    r("City") = dr["City"];
    r("Cost") = dr["Cost"];
    destinationTable.Rows.Add(r);
}

so can u give me guidance in for loop condition

[edit]pre tag for C# code added. Spelling mistakes corrected - PES[/edit]

Posted 1-Mar-12 1:56am

anilksrk

Updated 1-Mar-12 2:49am

ProEnggSoft

v2

Add a Solution

Comments

Oshtri Deka 1-Mar-12 9:39am

Syntax errors!
To get row's field via indexer only square ([]) brackets work.
r("Name") wrong!
r["Name"] correct.

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ProEnggSoft · Answer 1 · 2012-03-01T02:40:00

In the source table, if any modification is done the RowState of the data row will be Modified state. Due to this the RowState of the imported row cannot be set to Added state. Hence, you have to first call AcceptChanges method on the source table and then import the rows as follows

C#

sourceTable.AcceptChanges();
foreach (DataRow dr in sourceTable.Rows)
{
    destinationTable.ImportRow(dr);
    //Set the row state of the newly row added row to Added state.
    destinationTable.Rows(destinationTable.Rows.Count - 1).SetAdded();
}

You may accept and vote one of the solutions which solved your problem, otherwise please post your queries.

Oshtri Deka · Answer 2 · 2012-03-01T04:12:00

Solution 3

Why don't you try with Merge() method. No loops and I guess you don't have great schema difference between tables.

C#

//
destinationTable.Merge(sourcetable);
//

Posted 1-Mar-12 4:12am

Oshtri Deka

ralphlee1 · Answer 3 · 2012-03-01T19:32:00

two tables in the same database..um
how about running SQL-Script in access?

C#

string sqlscript = @"
Insert into destTable(FieldA,FieldB,FieldC)
Select FieldA,FieldB,FieldD
from SourceTable";

cmd.CommandText=sqlscript;
cmd.ExecuteNonQuery();

http://office.microsoft.com/en-us/access-help/insert-into-statement-HA001231488.aspx[^]

bluesathish · Answer 4 · 2012-03-01T02:11:00

Solution 1

Dear anilksrk,
Try the following,

C#

foreach(datarow dr in sourcetable.rows)
{
destinationTable.rows.add(dr);
destinationTable.AcceptChanges();
}

Regards,
Bluesathish

Posted 1-Mar-12 2:11am

bluesathish

Comments

ProEnggSoft 1-Mar-12 8:44am

If AcceptChanges method is called on destinationTable, then the RowState of the data rows will be set to Unchanged state, so that when the data is to be saved to the database the data will not be added to the database on the disk.

Import data one table to another table using Forloop

4 solutions

Solution 2

Solution 3

Solution 4

Solution 1

Add your solution here

Preview 0