How to use StoredProcedureParameterCollection

Hi

I know this is a simple problem but I can't fix it. How can I use a StoredProcedureParameterCollection?

I try to do this but it doesn't work

StoredProcedureParameterCollection sppc = new StoredProcedureParameterCollection();

sppc.Add(new StoredProcedureParameter(storedProcedure, "@.GroupName", DataType.VarChar(50)));
sppc.Add(new StoredProcedureParameter(storedProcedure, "@.Active", DataType.Bit));
sppc.Add(new StoredProcedureParameter(storedProcedure, "@.GroupID", DataType.Int));

foreach (StoredProcedureParameter s in sppc)
{
storedProcedure.Parameters.Add(s);
}

Thanks

Jon

No worries it's sorted now

StoredProcedure storedProcedure = new StoredProcedure(database, spName);
StoredProcedureParameterCollection sppc = storedProcedure.Parameters;