Read from one DB table and it to another ASP.NET using foreach statement

Question

I am trying to read datas from one database table and then add it to another table. This is my example and code.

This is the table I am reading from: enter image description here

And this is the table when I save it:

enter image description here

This is the code I use:

protected void Button1_Click(object sender, EventArgs e)
    {
        var db = Database.Open("ConnectionString");
        var FJSCR = db.Query("SELECT * FROM [SALESAGENT]");

        foreach (var item in FJSCR)
        {
            Label1.Text += item.CODE;
            //Label1.Text += "<hr/>";

            try
            {
                SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
                con .Open();
                string FJ = "EXEC sp_msforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT all'";
                FJ = "insert into MAG(COD) VALUES (@COD)";
                SqlCommand kom = new SqlCommand(FJ, con);
                kom.Parameters.AddWithValue("@COD", Label1.Text);
                kom.ExecuteNonQuery();

            }
            catch (Exception ex)
            {
                Response.Write("Error " + ex.ToString());
            }
        }  
    }

Any help? Thank You!

@user2767299 , I want to add the datas from the first picture to another table which is the second picture. — aldoblack
– aldoblack, Commented Jul 12, 2014 at 4:59
@Grant Winney , Nope, just as-is. I want this way. This is the way I was requested to do. — aldoblack
– aldoblack, Commented Jul 12, 2014 at 5:02

Grant Winney · Accepted Answer · 2014-07-12 05:20:18Z

2

If you just straight away COPY the data from one table to another, no need to use label in between.

just change ;

kom.Parameters.AddWithValue("@COD", Label1.Text);

To

kom.Parameters.AddWithValue("@COD", item.CODE);

OR

If you want to use LABEL then GET New record value in label every time, Do not APPEND;

In that case, replace;

 Label1.Text += item.CODE;

TO

 Label1.Text = item.CODE;

Hope this is what you are looking for..!!!

edited Jul 12, 2014 at 5:20

Grant Winney

66.6k13 gold badges120 silver badges167 bronze badges

answered Jul 12, 2014 at 5:07

H. Mahida

2,3761 gold badge14 silver badges23 bronze badges

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

1 Comment

aldoblack Over a year ago

Tried the first one. It worked. Thanks a lot. You saved me. :D

Collectives™ on Stack Overflow

Read from one DB table and it to another ASP.NET using foreach statement

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related