SqlParameter Constructor ()


Initializes a new instance of the SqlParameter class.

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

public SqlParameter()

The following example creates a SqlParameter and sets some of its properties.

private static void AddSqlParameter(SqlCommand command)
    SqlParameter parameter = new SqlParameter();
    parameter.ParameterName = "@Description";
    parameter.IsNullable = true;
    parameter.SqlDbType = SqlDbType.VarChar;
    parameter.Direction = ParameterDirection.Output;
    parameter.Size = 88;


.NET Framework
Available since 1.1
Return to top