IDbCommand.Parameters Property

Definition

Namespace:

System.Data

Assemblies:

netstandard.dll, System.Data.Common.dll

Gets the IDataParameterCollection.

C#

public System.Data.IDataParameterCollection Parameters { get; }

Property Value

IDataParameterCollection

The parameters of the SQL statement or stored procedure.

Examples

The following example creates an instance of the derived class, SqlCommand, and displays its parameters. In the example, the application passes a SqlConnection, a query string that is a Transact-SQL SELECT statement, and an array of SqlParameter objects.

C#

public void CreateSqlCommand(SqlConnection myConnection,
    string queryString, SqlParameter[] paramArray)
{
    SqlCommand command = new SqlCommand(queryString, myConnection);
    command.CommandText =
        "SELECT CustomerID, CompanyName FROM Customers "
        + "WHERE Country = @Country AND City = @City";
    command.Parameters.AddRange(paramArray);

    string message = "";
    for (int i = 0; i < command.Parameters.Count; i++)
    {
        message += command.Parameters[i].ToString() + "\n";
    }
    Console.WriteLine(message);
}

Applies to

See also

• IDataParameter