Let me make sure I understand your question, you have a sqlcommand with 4 parameters and you want to create the command once and use it multiple times with the paramters changing each time? You can do this. You can change the parameter.Value each time you call the sp. Something like this:
oCmd.Paramters("@address").Value = address
oCmd.executenonquery
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question