Procedure Or Function 'SubscribeToNewsletters' Expects Parameter '@emailAddress', Which Was Not Supplied.

Hi i have been trying to insert some values selected in a checkbox list into the database, however it is giving me the following error "Procedure or Function 'SubscribeToNewsletters' expects parameter '@emailAddress', which was not supplied. "public void Page_Load(object sender, EventArgs e) -- on page load the checkbox list is populated through stored procedure (stream_NewsletterTypes)

{

try

{SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["streamConnectionString"].ConnectionString);

SqlCommand command = new SqlCommand("stream_NewsletterTypes", conn); command.CommandType = CommandType.StoredProcedure;

command.Connection.Open();SqlDataReader datareader = command.ExecuteReader();

AlertList.DataSource = datareader;AlertList.DataTextField = "newsletterName";

AlertList.DataBind();

command.Connection.Close();

command.Connection.Dispose();

}catch (Exception ex)

{throw new Exception("Exception. " + ex.Message);

}

}

 protected void Btn_Subscribe_Click(object sender, EventArgs e) when the button is clicked, the values should be sent to the database

{SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["streamConnectionString"].ConnectionString);

SqlCommand command = new SqlCommand("stream_NewsletterTypes", conn);command.CommandType = CommandType.StoredProcedure;for (int i = 0; i < AlertList.Items.Count; i++)

{if (AlertList.Items[i].Selected)

{

command.Parameters.AddWithValue("firstName", txtFirstName.Text);command.Parameters.AddWithValue("surname", txtSurname.Text);

command.Parameters.AddWithValue("emailAddress", txtEmail.Text);command.Parameters.AddWithValue("newsletterID", AlertList.Items[i].Value);

}

}

try

{

conn.Open();

command.ExecuteNonQuery();

}catch (Exception ex)

{throw new Exception("Exception adding account. " + ex.Message);

}

finally

{

conn.Close();

}

}

 

And my stored procedure;ALTER PROCEDURE [dbo].[SubscribeToNewsletters]

@emailAddress VARCHAR(250),

@firstName VARCHAR(250),

@surname VARCHAR(250),

@newsletterID INT,@userID INT OUTPUT

AS

INSERT INTO ThinkUsers (emailAddress, firstName, surname)

VALUES

(@emailAddress, @firstName, @surname)

Select @userID = @@Identity -- this is the ID created in the TheUserTable

-- when you make that first insert, the database

-- will generate the next ID value in that table

INSERT INTO SubscribedNewsletters (userID, newsletterID)

VALUES

(@userID, @newsletterID)