Result of a Select query into another table

Question

In Windows form application, I want to add The Result of a Select SQL Query into another table.

• The input pid (textBox1.text) is a integer no.
• When running this application, I am getting the message "Product Added" but actually its not.

• This the code behind the button click, I think the SQL query is wrong somewhere. please help

    private void button1_Click(object sender, EventArgs e)
    {
  
    SqlConnection con = new SqlConnection("Data Source=HOME;Initial   
                             Catalog=Test;Integrated Security=True");
    con.Open();
    SqlCommand cmd = new SqlCommand("insert into list (pname, pprice)
    (select pname, pprice from products where pid='" +textBox1.Text+"')", con);
          MessageBox.Show("Product Added");
    con.Close();
    }
  

Answer 1

  private void button1_Click(object sender, EventArgs e)
  {
  SqlDataAdapter SDA = new SqlDataAdapter();
  DataTable dt = new DataTable();
  SqlConnection con = new SqlConnection("Data Source=HOME;Initial   
                           Catalog=Test;Integrated Security=True");
  
  SqlCommand cmd = new SqlCommand("insert into list (pname, pprice)
  select pname, pprice from products where pid='" +textBox1.Text+"'", con);
  con.Open();
  SDA.SelectCommand = cmd;
  SDA.Fill(dt);
  con.Close();
  MessageBox.Show("Product Added");
  
  }

You made following mistakes in your code

1 : you open connection before creating of sqlcommand object

2: you did not write code to execute the query properly

3: you also put parenthesis before the select statement

Note: Make Sure textBox1.Text is not null or empty also you should use paramterize query