SqlParameterCollection Methods (System.Data.SqlClient)

This page is specific to

Microsoft Visual Studio 2008/.NET Framework 3.5

Other versions are also available for the following:

.NET Framework Class Library

SqlParameterCollection Methods

The SqlParameterCollection type exposes the following members.

Methods

	Name	Description
	Add	Overloaded. Adds a SqlParameter to the SqlParameterCollection.
	AddRange	Overloaded. Adds elements to the end of the SqlParameterCollection.
	AddWithValue	Adds a value to the end of the SqlParameterCollection.
	Clear	Removes all the SqlParameter objects from the SqlParameterCollection. (Overrides DbParameterCollection..::.Clear()()().)
	Contains	Overloaded. Determines whether the specified object is in this SqlParameterCollection.
	CopyTo	Overloaded. Copies all the elements of the current SqlParameterCollection to the specified object.
	CreateObjRef	Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from MarshalByRefObject.)
	Equals	Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
	Finalize	Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (Inherited from Object.)
	GetEnumerator	Returns an enumerator that iterates through the SqlParameterCollection. (Overrides DbParameterCollection..::.GetEnumerator()()().)
	GetHashCode	Serves as a hash function for a particular type. (Inherited from Object.)
	GetLifetimeService	Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
	GetParameter	Overloaded. Gets the DbParameter with the specified property value.
	GetType	Gets the Type of the current instance. (Inherited from Object.)
	IndexOf	Overloaded. Gets the location of the specified SqlParameter within the collection.
	InitializeLifetimeService	Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
	Insert	Overloaded. Inserts a SqlParameter object into the SqlParameterCollection.
	MemberwiseClone	Overloaded.
	Remove	Overloaded. Removes the specified SqlParameter from the collection.
	RemoveAt	Overloaded. Removes the SqlParameter object from the SqlParameterCollection at the specified index.
	SetParameter	Overloaded. Sets the specified parameter to the specified value.
	ToString	Returns a String that represents the current Object. (Inherited from Object.)

Top

Extension Methods

	Name	Description
	Cast	Converts the elements of an IEnumerable to the specified type. (Defined by Enumerable.)
	OfType	Filters the elements of an IEnumerable based on a specified type. (Defined by Enumerable.)

Top

Reference

SqlParameterCollection Class

System.Data.SqlClient Namespace