can I "reuse" a sqlcommand object?

[stucker79]

I would like to declare one sqlcommand object in a module that I can use across my project. Is there a way to "clear" a sqlcommand object so that I can use it again for a different stored procedure?

 

[RiverGuy]

Just change its properties.

 

[stucker79]

It seems to be cached or something, I change it's properties but it throws and error "too many arguments specified". if i change it to a different sqlcommand object it works fine...

 

[ThatRickGuy]

you may need to clear the .parameters collection.

-Rick

----------------------

http://www.ringdev.com

 

[RiverGuy]

I don't know what you mean.

Command1.CommandType = CommandType.StoredProcedure
Command1.Connection = MyConnection
Command1.CommandText = "some_sp"
Command1.Parameters.Add("@Param1", 100)

---------------------------------------

Command1.Parameters.Clear
Command1.CommandType = CommandType.Text
Command1.Connection = MyConnection
Command1.CommandText = "SELECT Something FROM Something"

should work fine.

 

[stucker79]

Thanks ThatRickGuy, that was it.