The variable name '@logo' has already been declared. c#

The variable name '@logo' has already been declared. Variable names must be unique within a query batch or stored procedure. in windows form c#

cmd = new SqlCommand("insert into cmpny_dtl(c_name,adrs,c_phone,,logo ,state_id ) values(@c_name,@adrs,@c_phone,@state_id )", con);
con.Open();
cmd.Parameters.AddWithValue("@c_name", CmpnyName_txt.Text);
cmd.Parameters.AddWithValue("@adrs", Adrs_txt.Text);
cmd.Parameters.AddWithValue("@c_phone", CmpnyPhone_txt.Text);
cmd.Parameters.AddWithValue("@logo", "@logo");
cmd.Parameters.AddWithValue("@state_id", STATE_comboBox.SelectedValue);
if (pictureBox1.Image != null)
{
MemoryStream ms = new MemoryStream();
pictureBox1.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
byte[] photo = ms.ToArray();
cmd.Parameters.AddWithValue("@logo", photo);
}
else
{
cmd.Parameters.AddWithValue("@logo", (pictureBox1.Image == null) ? (object)DBNull.Value : pictureBox1.Image).SqlDbType = SqlDbType.Image;
}
int k = cmd.ExecuteNonQuery();
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Record Inserted Successfully");

you are passing same parameter two times that is why you got this error

cmd = new SqlCommand("insert into cmpny_dtl(c_name,adrs,c_phone,,logo ,state_id ) values(@c_name,@adrs,@c_phone,@state_id )", con);
con.Open();
cmd.Parameters.AddWithValue("@c_name", CmpnyName_txt.Text);
cmd.Parameters.AddWithValue("@adrs", Adrs_txt.Text);
cmd.Parameters.AddWithValue("@c_phone", CmpnyPhone_txt.Text);
cmd.Parameters.AddWithValue("@logo", "@logo"); //delete this line
cmd.Parameters.AddWithValue("@state_id", STATE_comboBox.SelectedValue);
if (pictureBox1.Image != null)
{
MemoryStream ms = new MemoryStream();
pictureBox1.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
byte[] photo = ms.ToArray();
cmd.Parameters.AddWithValue("@logo", photo);
}
else
{
cmd.Parameters.AddWithValue("@logo", DBNull.Value);
}
int k = cmd.ExecuteNonQuery();
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Record Inserted Successfully");

3 Replies

Know the answer? Post it — somebody with the same question will find it here.