我想要SQL查询从一个表中检索数据并将其存储在另一个表中 [英] I want sql query for retrieving data from one table and store it in another table

问题描述

我想要做的是点击按钮我希望将一些表中的一些选定数据存储到其他表中

What i am trying to do is on button click i want to store some selected data from one table into other table

推荐答案

SELECT *
INTO carcopy2 ////this is table where you will insert
FROM carcopy;/////this is from whre you are retrieving

protected void Button1_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection("connection string");
            con.Open();
            SqlCommand cmd = new SqlCommand("select * from Users where UserID='"+Session["userid"].ToString()+"'",con);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(dt);
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                SqlCommand cmd2 = new SqlCommand("insert into AppliedUsers values('" + dt.Rows[0][0].ToString() + "','" + dt.Rows[0][1].ToString() + "',......) ", con);
                cmd2.ExecuteNonQuery();
            }
            con.Close();
        }

这篇关于我想要SQL查询从一个表中检索数据并将其存储在另一个表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！