Export (0) Print
Expand All

SqlParameterCollection Methods

The SqlParameterCollection type exposes the following members.

  NameDescription
Public method Add(Object) Adds the specified SqlParameter object to the SqlParameterCollection. (Overrides DbParameterCollection.Add(Object).)
Public method Add(SqlParameter) Adds the specified SqlParameter object to the SqlParameterCollection.
Public method Add(String, SqlDbType) Adds a SqlParameter to the SqlParameterCollection given the parameter name and the data type.
Public method Add(String, Object) Obsolete. Adds the specified SqlParameter object to the SqlParameterCollection.
Public method Add(String, SqlDbType, Int32) Adds a SqlParameter to the SqlParameterCollection, given the specified parameter name, SqlDbType and size.
Public method Add(String, SqlDbType, Int32, String) Adds a SqlParameter to the SqlParameterCollection with the parameter name, the data type, and the column length.
Public method AddRange(Array) Adds an array of values to the end of the SqlParameterCollection. (Overrides DbParameterCollection.AddRange(Array).)
Public method AddRange(SqlParameter[]) Adds an array of SqlParameter values to the end of the SqlParameterCollection.
Public method AddWithValue Adds a value to the end of the SqlParameterCollection.
Public method Clear Removes all the SqlParameter objects from the SqlParameterCollection. (Overrides DbParameterCollection.Clear().)
Public method Contains(Object) Determines whether the specified Object is in this SqlParameterCollection. (Overrides DbParameterCollection.Contains(Object).)
Public method Contains(SqlParameter) Determines whether the specified SqlParameter is in this SqlParameterCollection.
Public method Contains(String) Determines whether the specified parameter name is in this SqlParameterCollection. (Overrides DbParameterCollection.Contains(String).)
Public method CopyTo(Array, Int32) Copies all the elements of the current SqlParameterCollection to the specified one-dimensional Array starting at the specified destination Array index. (Overrides DbParameterCollection.CopyTo(Array, Int32).)
Public method CopyTo(SqlParameter[], Int32) Copies all the elements of the current SqlParameterCollection to the specified SqlParameterCollection starting at the specified destination index.
Public method 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.)
Public method Equals(Object) Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
Protected method Finalize Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
Public method GetEnumerator Returns an enumerator that iterates through the SqlParameterCollection. (Overrides DbParameterCollection.GetEnumerator().)
Public method GetHashCode Serves as a hash function for a particular type. (Inherited from Object.)
Public method GetLifetimeService Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
Protected method GetParameter(Int32) Returns the DbParameter object at the specified index in the collection. (Inherited from DbParameterCollection.)
Protected method GetParameter(String) Returns DbParameter the object with the specified name. (Inherited from DbParameterCollection.)
Public method GetType Gets the Type of the current instance. (Inherited from Object.)
Public method IndexOf(Object) Gets the location of the specified Object within the collection. (Overrides DbParameterCollection.IndexOf(Object).)
Public method IndexOf(SqlParameter) Gets the location of the specified SqlParameter within the collection.
Public method IndexOf(String) Gets the location of the specified SqlParameter with the specified name. (Overrides DbParameterCollection.IndexOf(String).)
Public method InitializeLifetimeService Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
Public method Insert(Int32, SqlParameter) Inserts a SqlParameter object into the SqlParameterCollection at the specified index.
Public method Insert(Int32, Object) Inserts an Object into the SqlParameterCollection at the specified index. (Overrides DbParameterCollection.Insert(Int32, Object).)
Protected method MemberwiseClone() Creates a shallow copy of the current Object. (Inherited from Object.)
Protected method MemberwiseClone(Boolean) Creates a shallow copy of the current MarshalByRefObject object. (Inherited from MarshalByRefObject.)
Public method Remove(Object) Removes the specified SqlParameter from the collection. (Overrides DbParameterCollection.Remove(Object).)
Public method Remove(SqlParameter) Removes the specified SqlParameter from the collection.
Public method RemoveAt(Int32) Removes the SqlParameter from the SqlParameterCollection at the specified index. (Overrides DbParameterCollection.RemoveAt(Int32).)
Public method RemoveAt(String) Removes the SqlParameter from the SqlParameterCollection at the specified parameter name. (Overrides DbParameterCollection.RemoveAt(String).)
Protected method SetParameter(Int32, DbParameter) Sets the DbParameter object at the specified index to a new value. (Inherited from DbParameterCollection.)
Protected method SetParameter(String, DbParameter) Sets the DbParameter object with the specified name to a new value. (Inherited from DbParameterCollection.)
Public method ToString Returns a string that represents the current object. (Inherited from Object.)
Top

Community Additions

ADD
Show:
© 2014 Microsoft