How to insert multiple datatable data into one datatable c#

Question

I have a function which will return multiple ItemIDs as

           for (int i = 0; i < dt.Rows.Count; i++)
            {
                ItemID = int.Parse(dt.Rows[i]["item_Id"].ToString());
                dtAtlr = prodctsDCCls.getItemIds(ItemID);
                //dtItems = dtAtlr.Copy();
            }

I want to keep on searching for all ItemIds from the same table and have to save all the data in one datatable.If I copy one datatable to another datatable, that is replacing the previous datatable. but I need all the data. Please anybody help me

It's not clear from your question what you have tried, what was the problem(was there an exception?) or what's the desired result. Provide a short(but complete) sample, you can replace your getItemIds with a foo-method that returns a DataTable. — Tim Schmelter
– Tim Schmelter, Commented Feb 19, 2013 at 10:13
Side-note: If item_Id is already an int use the strongly typed DataRow extension method Field(which also supports nullable types): item_Id = dt.Rows[i].Field<int>("item_Id"); — Tim Schmelter
– Tim Schmelter, Commented Feb 19, 2013 at 10:17
that is replacing the previous datatable. this is my problem sir — Learner
– Learner, Commented Feb 19, 2013 at 10:18
Iam doing dtItems=dtAtlr.Copy(); so dat it is replacing the previous data with the new data.. :) — Learner
– Learner, Commented Feb 19, 2013 at 10:21
Thanks you sir.. I tried dt.Clone and tried to copytodatatable method too with a foreach loop — Learner
– Learner, Commented Feb 19, 2013 at 10:23

Habib · Accepted Answer · 2013-02-19 10:11:48Z

1

Use DataTable.Merge to merge two data tables. So your code would be:

for (int i = 0; i < dt.Rows.Count; i++)
{
    ItemID = int.Parse(dt.Rows[i]["item_Id"].ToString());
    dtAtlr.Merge(prodctsDCCls.getItemIds(ItemID)); // For Merging
}

By using DataTable.Copy, your datatable dtAtlr will have the last returned DataTable against the ItemID

answered Feb 19, 2013 at 10:11

Habib

224k30 gold badges420 silver badges446 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Soner Gönül · Accepted Answer · 2013-02-19 10:13:36Z

1

You can check DataTable.Merge

Merge the specified DataTable with the current DataTable.

answered Feb 19, 2013 at 10:13

Soner Gönül

99.1k103 gold badges224 silver badges375 bronze badges

Collectives™ on Stack Overflow

How to insert multiple datatable data into one datatable c#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related