Repeated sqlparameter's values not allowed. How to resolv?

Hi,

How can I write correctly codes that values are repeated in the segond piece of codes? Why I am asking this question? Just because there are some parameters's values underlined (showing that some values are repeated). But its the real column's name.

For example these two pieces codes are into the same button:

First piece:

conn = new SqlConnection("Data Source = (LocalDB)\\MSSQLLocalDB; AttachDbFilename=C:\\x\\WindowsFormsApplication1\\App_datas\\test.mdf;Integrated Security = True;Integrated Security = True");
comm = new SqlCommand();
if (conn.State != ConnectionState.Open)
conn.Open();
SqlCommand comm = new SqlCommand();
comm1.Connection = conn;
SqlParameter date = new SqlParameter("@date", SqlDbType.VarChar);
SqlParameter name = new SqlParameter("@name", SqlDbType.VarChar);
comm1.Parameters.Add(date);
comm1.Parameters.Add(name);
date.Value = dtDate.Text;
name.Value = txtName.Text;
comm.Connection = conn;
comm.CommandText = "insert into accounting ([date],[name])values(@date,@name)";
{
if (MessageBox.Show("Are you sure to save?", "", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
try
{
comm.ExecuteNonQuery();
}
finally
{
conn.Close();
}

Second piece:

// Its underline where its colored in red
conn = new SqlConnection("Data Source = (LocalDB)\\MSSQLLocalDB; AttachDbFilename=C:\\x\\WindowsFormsApplication1\\App_datas\\test.mdf;Integrated Security = True;Integrated Security = True");
comm = new SqlCommand();
if (conn.State != ConnectionState.Open)
conn.Open();
SqlCommand comm = new SqlCommand();
comm1.Connection = conn;
SqlParameter date = new SqlParameter("@date", SqlDbType.VarChar); //here
SqlParameter name = new SqlParameter("@name", SqlDbType.VarChar); // here
comm1.Parameters.Add(date);
comm1.Parameters.Add(name);
date.Value = dtDate.Text;
name.Value = txtName.Text;
comm.Connection = conn;
comm.CommandText = "insert into accounting ([date],[name])values(@date,@name)";
{
if (MessageBox.Show("Are you sure to save?", "", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
try
{
comm.ExecuteNonQuery();
}
finally
{
conn.Close();
}

3 Replies

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

Israel6y ago
Hi Jignesh,
Its little bit complex explaining why. But in one word I am developing a accounting application that some specifics operations should be saved in that way. As you saw I could not write ALL this scenario here otherwise its would make "confusion". Any way its important. Thank you.
0
Jignesh Kumar6y ago
Hi Israel,

You are using same name for two times thats why it is giving this error. One more thing why you need these two insert query in same button click.
Please provide more details on your sceaniro why you want this way.
0
Amit Gupta6y ago
1. Use datetime datatype instead of varchar in date field 2. Use SqlParameter array type and just use add or remove from the array like SqlParameters.Remove(paramName).
0

Repeated sqlparameter's values not allowed. How to resolv?

Hi Jignesh,