How do I copy data from table into another table?

both tables are having same no of columns and datatypes....What i did is---
"INSERT INTO Subject_Table SELECT * FROM Temp_Subject_Table WHERE Stud_Name='@Stud_Name'"..
but not working..
My Code Segment
protected void StudReg_Button_Click(object sender, EventArgs e)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
con.Open();
SqlTransaction tran = con.BeginTransaction();
try
{

SqlCommand cmd = new SqlCommand();
cmd.Transaction = tran;
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "INSERT INTO SUBJECTS_TBL SELECT * FROM TEMP_SUBJECT_TBL WHERE Stud_Name='@Stud_Name'";
cmd.Parameters.Add("@Stud_Name", System.Data.SqlDbType.VarChar).Value = this.Session["Stud_Name"].ToString().ToUpper();
cmd.CommandText = "DELETE FROM TEMP_SUBJECT_TBL WHERE Stud_Name='@Del_Stud_Name'";
cmd.Parameters.Add("@Del_Stud_Name", System.Data.SqlDbType.VarChar).Value = this.Session["Stud_Name"].ToString().ToUpper();
cmd.ExecuteNonQuery();
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
string error_message = ex.Message;
Response.Write("<script LANGUAGE='JavaScript'>alert('" + error_message + "')</script>");
}
finally
{
con.Close();
}
}

}

It's just deleting not inserting............

Thanks for you help but CommandText is not wrong....
I just forget to perform cmd.ExecuteNonQuery() after adding parameter for "INSERT INTO SELECT" query...
Now it's working fine...
Thank you......