Problem With SqlException

 

Hi,

 I get an error as I try to insert to SQL server using a stored procedure:

"Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression."

For some reason the stored procedure inserts every row twice. Does anyone know what could be wrong?

 Thanks in advance!

string sCN = ConfigurationManager.ConnectionStrings["AdminConnectionString"].ConnectionString;

SqlConnection sqlConnection1 = new SqlConnection(sCN);System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();

cmd.CommandType = System.Data.CommandType.Text;string strTemp = (Session["activityID"]).ToString();if (strTemp != "")

{

string sql2 = Session["txtFirstName"].ToString();string sql3 = Session["txtLastName"].ToString();

string sql4 = Session["txtStreetAddress"].ToString();string sql6 = Session["txtPostalAddress"].ToString();

string sql7 = Session["txtTelephoneHome"].ToString();

string sql10 = Session["txtEmail"].ToString();

string sql13 = Session["txtAppartmentNo"].ToString();

 cmd.Parameters.AddWithValue("@mbrFirstName", sql2);

cmd.Parameters.AddWithValue("@mbrLastName", sql3);cmd.Parameters.AddWithValue("@mbrStreetAddress", sql4); cmd.Parameters.AddWithValue("@mbrPostalAddress", sql6);

cmd.Parameters.AddWithValue("@mbrTelephoneHome", sql7);

cmd.Parameters.AddWithValue("@mbrEmail", sql10);



Int32 rowsAffected;cmd.CommandText = "insert_member";cmd.CommandType = CommandType.StoredProcedure;

cmd.Connection = sqlConnection1;

sqlConnection1.Open();

rowsAffected = cmd.ExecuteNonQuery();

sqlConnection1.Close();