System.Data.SqlClient.SqlParameter

SqlParameter

public sealed class SqlParameter : DbParameter

Represents a parameter to a SqlCommand and optionally its mapping to DataSet columns. This class cannot be inherited. For more information on parameters, see Configuring Parameters and Parameter Data Types.

public SqlCompareOptions CompareInfo { get; set; }

Gets or sets the CompareInfo object that defines how string comparisons should be performed for this parameter.

public int LocaleId { get; set; }

Gets or sets the locale identifier that determines conventions and language for a particular region.

public int Offset { get; set; }

Gets or sets the offset to the Value property.

public byte Precision { get; set; }

Gets or sets the maximum number of digits used to represent the Value property.

public byte Scale { get; set; }

Gets or sets the number of decimal places to which Value is resolved.

public SqlDbType SqlDbType { get; set; }

Gets or sets the SqlDbType of the parameter.

public object SqlValue { get; set; }

Gets or sets the value of the parameter as an SQL type.

public string TypeName { get; set; }

Gets or sets the type name for a table-valued parameter.

public string XmlSchemaCollectionDatabase { get; set; }

Gets the name of the database where the schema collection for this XML instance is located.

public string XmlSchemaCollectionName { get; set; }

Gets the name of the schema collection for this XML instance.

public string XmlSchemaCollectionOwningSchema { get; set; }

The owning relational schema where the schema collection for this XML instance is located.

public SqlParameter()

Initializes a new instance of the SqlParameter class.

public SqlParameter(string parameterName, SqlDbType dbType)

Initializes a new instance of the SqlParameter class that uses the parameter name and the data type.

public SqlParameter(string parameterName, SqlDbType dbType, int size)

Initializes a new instance of the SqlParameter class that uses the parameter name, the SqlDbType, and the size.

public SqlParameter(string parameterName, SqlDbType dbType, int size, string sourceColumn)

Initializes a new instance of the SqlParameter class that uses the parameter name, the SqlDbType, the size, and the source column name.

public SqlParameter(string parameterName, object value)

Initializes a new instance of the SqlParameter class that uses the parameter name and a value of the new SqlParameter.

public void ResetSqlDbType()

Resets the type associated with this SqlParameter.