How to copy data from one datatable to another datatable

Question

0.00/5 (No votes)

See more:

for (int i = 0; i < 5; i++)
            {
                DataTable tbl, tbl2;
                SqlDataAdapter adp = new SqlDataAdapter("Select ID, user ,Date, vehicle from booking where ID='100' and user='james'", con);
                tbl = new DataTable();
                adp.Fill(tbl);
            }

In tbl datatable the following data is generating every time. ie
ID user Date vehicle
100 james 02-02-2012 BMW

These above value will generate 5 times and i want to save all 5 records in another datatable ie tbl2.

Posted 10-May-12 0:59am

sahabiswarup

Add a Solution

2 solutions

Solution 1

SQL

INSERT INTO new_db.dbo.TableA
SELECT * FROM old_db.dbo.TableB

Posted 10-May-12 1:03am

Sudheer Nimmagadda

Comments

sahabiswarup 10-May-12 7:04am

how to implement these above query?

sahabiswarup 10-May-12 7:08am

In TableA there is only one record; Every time one row will add in TableB.
so that in TableB there are 5 records though there is only one record in TableA.

Unareshraju 10-May-12 7:14am

here we should create a TableA which consist of five column after that you can use above command

sahabiswarup 10-May-12 7:28am

i dont want to fix TableA row; every time TableA row value will be added on TableB new row.
I want to do like that.

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)

sahabiswarup · Accepted Answer · 2012-05-10T03:05:00

SqlDataAdapter da1 = new SqlDataAdapter("Select booking_id,user_id,convert(char,date_of_travel,103) as date_of_travel, no_of_vehicle,vehicle from booking where user_id='" + Session["a"] + "' and booking_id='" + Session["key"].ToString() + "'", con);
        DataTable dt1 = new DataTable();
        da1.Fill(dt1);
        if (dt1.Rows.Count > 0)
        {
            int loop;
            DataTable tbl;
            DataTable tbl2 = new DataTable();
            DataSet ds = new DataSet();
            ds.Tables.Add(new DataTable());
            ds.Tables[0].Columns.Add("ID", typeof(int));
            ds.Tables[0].Columns.Add("Tour_Code", typeof(int));
            ds.Tables[0].Columns.Add("Tour_Date", typeof(string));
            //ds.Tables[0].Columns.Add("No_Of_Vehicle", typeof(int));
            ds.Tables[0].Columns.Add("Vehicle", typeof(string));
            tbl2 = ds.Tables[0].Clone();
            loop = Convert.ToInt32(dt1.Rows[0][3].ToString());
            for (int i = 0; i < loop; i++)
            {
                SqlDataAdapter adp = new SqlDataAdapter("Select booking_id as ID,user_id as Tour_Code,convert(char,date_of_travel,103) as Tour_Date, vehicle as Vehicle from booking where user_id='" + Session["a"] + "' and booking_id='" + Session["key"].ToString() + "'", con);
                tbl = new DataTable();
                adp.Fill(tbl);

                foreach (DataRow dr in tbl.Rows)
                {
                    DataRow newRow = tbl2.NewRow();
                    newRow.ItemArray = dr.ItemArray;
                    tbl2.Rows.Add(newRow);
                }

            }
            grdveh.DataSource = tbl2;
            grdveh.DataBind();
        }