Procedure or function ... has too many arguments specified.

[speranza]

i have multiple checkboxes on my form.i am trying to add them with stored procedure but it gives me Procedure or function konut_ekle has too many arguments specified

protected void Button1_Click1(object sender, EventArgs e)
    {
 
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString);
        SqlCommand cmd;
        con.Open();
        string cmdstr = "konut_ekle";
        cmd = new SqlCommand(cmdstr, con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@kategori", TextBox1.Text);
        cmd.Parameters.AddWithValue("@tip", TextBox2.Text);
        cmd.Parameters.AddWithValue("@il", TextBox3.Text);
        cmd.Parameters.AddWithValue("@ilce", TextBox4.Text);
        cmd.Parameters.AddWithValue("@semt", TextBox5.Text);
        cmd.Parameters.AddWithValue("@fiyat", TextBox7.Text);
        for (int i = 0; i < CheckBoxList1.Items.Count; i++)
        {
            if (CheckBoxList1.Items[i].Selected)
            {
                cmd.Parameters.AddWithValue("@ozellik", CheckBoxList1.Items[i].Value);
            }
        }
        cmd.ExecuteNonQuery();
        cmd.Dispose();
        con.Close();
    }protected void Button1_Click1(object sender, EventArgs e)
    {
 
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString);
        SqlCommand cmd;
        con.Open();
        string cmdstr = "konut_ekle";
        cmd = new SqlCommand(cmdstr, con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@kategori", TextBox1.Text);
        cmd.Parameters.AddWithValue("@tip", TextBox2.Text);
        cmd.Parameters.AddWithValue("@il", TextBox3.Text);
        cmd.Parameters.AddWithValue("@ilce", TextBox4.Text);
        cmd.Parameters.AddWithValue("@semt", TextBox5.Text);
        cmd.Parameters.AddWithValue("@fiyat", TextBox7.Text);
        for (int i = 0; i < CheckBoxList1.Items.Count; i++)
        {
            if (CheckBoxList1.Items[i].Selected)
            {
                cmd.Parameters.AddWithValue("@ozellik", CheckBoxList1.Items[i].Value);
            }
        }
        cmd.ExecuteNonQuery();
        cmd.Dispose();
        con.Close();
    }
 
 

 
ALTER PROCEDURE konut_ekle
@kategori varchar(50),
@tip varchar(50),
@il varchar(50),
@ilce varchar(50),
@semt varchar(50),
@fiyat varchar(50),
@ozellik varchar(50)
AS
 
 
SET NOCOUNT ON
 
 
 
    insert into ilan (kategori,tip,il,ilce,semt)
    values (@kategori,@tip,@il,@ilce,@semt)
 
    declare @ilanid varchar(50)
 
    set @ilanid = scope_identity()
 
    insert into konut(ilanid,fiyat) values (@ilanid,@fiyat)
 
    insert into ozellikler(ilanid,ozellik) values (@ilanid,@ozellik)
 
    RETURNALTER PROCEDURE konut_ekle
@kategori varchar(50),
@tip varchar(50),
@il varchar(50),
@ilce varchar(50),
@semt varchar(50),
@fiyat varchar(50),
@ozellik varchar(50)
AS
 
 
SET NOCOUNT ON
 
 
 
    insert into ilan (kategori,tip,il,ilce,semt)
    values (@kategori,@tip,@il,@ilce,@semt)
 
    declare @ilanid varchar(50)
 
    set @ilanid = scope_identity()
 
    insert into konut(ilanid,fiyat) values (@ilanid,@fiyat)
 
    insert into ozellikler(ilanid,ozellik) values (@ilanid,@ozellik)
 
    RETURN
 

[Plater]

You are trying to add multiple parameters with the same name. Pretty sure you cannot do that.