System.Data.SqlClient.SqlParameterCollection

SqlParameterCollection

public sealed class SqlParameterCollection : DbParameterCollection

Represents a collection of parameters associated with a SqlCommand and their respective mappings to columns in a DataSet. This class cannot be inherited.

public SqlParameter this[int index] { get; set; }

Gets the SqlParameter at the specified index.

public SqlParameter this[string parameterName] { get; set; }

Gets the SqlParameter with the specified name.

public SqlParameter Add(SqlParameter value)

Adds the specified SqlParameter object to the SqlParameterCollection.

public SqlParameter Add(string parameterName, SqlDbType sqlDbType)

Adds a SqlParameter to the SqlParameterCollection given the parameter name and the data type.

public SqlParameter Add(string parameterName, SqlDbType sqlDbType, int size)

Adds a SqlParameter to the SqlParameterCollection, given the specified parameter name, SqlDbType and size.

public void AddRange(SqlParameter[] values)

Adds an array of SqlParameter values to the end of the SqlParameterCollection.

public SqlParameter AddWithValue(string parameterName, object value)

Adds a value to the end of the SqlParameterCollection.

public bool Contains(SqlParameter value)

Determines whether the specified SqlParameter is in this SqlParameterCollection.

public void CopyTo(SqlParameter[] array, int index)

Copies all the elements of the current SqlParameterCollection to the specified SqlParameterCollection starting at the specified destination index.

public int IndexOf(SqlParameter value)

Gets the location of the specified SqlParameter within the collection.

public void Insert(int index, SqlParameter value)

Inserts a SqlParameter object into the SqlParameterCollection at the specified index.

public void Remove(SqlParameter value)

Removes the specified SqlParameter from the collection.