Parameters Property

IDbCommand.Parameters Property

Namespace:   System.Data
Assembly:  System.Data (in System.Data.dll)

IDataParameterCollection Parameters { get; }

Property Value

Type: System.Data.IDataParameterCollection

The parameters of the SQL statement or stored procedure.

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.

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";    

    for (int j=0; j<paramArray.Length; j++)
        command.Parameters.Add(paramArray[j]) ;

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

.NET Framework
Available since 1.1
Return to top
© 2015 Microsoft