c# reusing parameters

marric


I have a select statement which requires numerous parameters.
here is a snippet.

SqlCommand cmd = new SqlCommand("SELECT this from MyTable WHERE Answer1 = @Att 1AND Answer2 = @Att2 AND Answer3 = @Att3", connection)

my parameters are added as follows.

SqlParameter Att1 = new SqlParameter("@Att1", SqlDbType.VarChar, 50);
Att1.Value = Attributes1;
cmd.Parameters.Add(Att1);

and so on...

What I would like to do is be able to remove a parameter and re-run the SELECT statement if the number of entries retrieved is less than 5 (or any number)

I tried just having a new Sql command like this.

SqlCommand cmd2 = new SqlCommand("SELECT this from MyTable WHERE Answer1 = @Att 1AND Answer2 = @Att2, connection)

and then did this..

cmd2.Parameters.Add(Att1);

but it didn't work.

Is there a way to do this so I don't have to keep copying the whole parameter command

Thank you in advance for your help. And please be gentle, I'm very new to this.

Jens K. Suessmeyer


YOu will have to remove the parameter from the first collections before using it in the second command.

cmd.Parameters.Remove(param);

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

marric

sometimes it's too simple.

thanks.