Redigera

SqlParameter Class

Definition

Namespace:
System.Data.SqlClient
Assembly:
System.Data.SqlClient.dll
Source:
System.Data.SqlClient.notsupported.cs

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 ref class SqlParameter sealed : System::Data::Common::DbParameter
public sealed class SqlParameter : System.Data.Common.DbParameter
type SqlParameter = class
    inherit DbParameter
Public NotInheritable Class SqlParameter
Inherits DbParameter
Inheritance
Object
DbParameter
SqlParameter

Examples

The following example creates multiple instances of SqlParameter through the SqlParameterCollection collection within the SqlDataAdapter. These parameters are used to select data from the data source and put the data in the DataSet. This example assumes that a DataSet and a SqlDataAdapter have already been created by using the appropriate schema, commands, and connection. For more information and additional examples on using parameters, see Retrieving and Modifying Data in ADO.NET and Configuring Parameters and Parameter Data Types.

public void AddSqlParameters()
{
// ...
// create categoriesDataSet and categoriesAdapter
// ...

  categoriesAdapter.SelectCommand.Parameters.Add(
    "@CategoryName", SqlDbType.VarChar, 80).Value = "toasters";
  categoriesAdapter.SelectCommand.Parameters.Add(
    "@SerialNum", SqlDbType.Int).Value = 239;
  categoriesAdapter.Fill(categoriesDataSet);
}

Public Sub AddSqlParameters()
    ' ...
    ' create categoriesDataSet and categoriesAdapter
    ' ...
    categoriesAdapter.SelectCommand.Parameters.Add( _
        "@CategoryName", SqlDbType.VarChar, 80).Value = "toasters"
    categoriesAdapter.SelectCommand.Parameters.Add( _
        "@SerialNum", SqlDbType.Int).Value = 239
    
    categoriesAdapter.Fill(categoriesDataSet)
End Sub

Remarks

Parameter names are not case sensitive.

Note

Nameless, also called ordinal, parameters are not supported by the .NET Framework Data Provider for SQL Server.

For more information, along with additional sample code demonstrating how to use parameters, see Commands and Parameters.

Constructors

Name Description
SqlParameter()

Initializes a new instance of the SqlParameter class.
SqlParameter(String, Object)

Initializes a new instance of the SqlParameter class that uses the parameter name and a value of the new SqlParameter.
SqlParameter(String, SqlDbType, Int32, String)

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

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

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

Properties

Name Description
CompareInfo

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

Gets or sets the SqlDbType of the parameter.
Direction

Gets or sets a value that indicates whether the parameter is input-only, output-only, bidirectional, or a stored procedure return value parameter.
IsNullable

Gets or sets a value that indicates whether the parameter accepts null values. IsNullable is not used to validate the parameter's value and will not prevent sending or receiving a null value when executing a command.
LocaleId

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

Gets or sets the offset to the Value property.
ParameterName

Gets or sets the name of the SqlParameter.
Precision

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

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

Gets or sets the maximum size, in bytes, of the data within the column.
SourceColumn

Gets or sets the name of the source column mapped to the DataSet and used for loading or returning the Value.
SourceColumnNullMapping

Gets or sets a value that indicates whether the source column is nullable. This allows SqlCommandBuilder to correctly generate Update statements for nullable columns.
SqlDbType

Gets or sets the SqlDbType of the parameter.
SqlValue

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

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

Gets or sets the value of the parameter.
XmlSchemaCollectionDatabase

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

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

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

Methods

Name Description
Equals(Object)

Determines whether the specified object is equal to the current object.

(Inherited from Object)
GetHashCode()

Serves as the default hash function.

(Inherited from Object)
GetType()

Gets the Type of the current instance.

(Inherited from Object)
MemberwiseClone()

Creates a shallow copy of the current Object.

(Inherited from Object)
ResetDbType()

Resets the type associated with this SqlParameter.
ResetSqlDbType()

Resets the type associated with this SqlParameter.
ToString()

Gets a string that contains the ParameterName.

Explicit Interface Implementations

Name Description
IDataParameter.SourceVersion

Gets or sets the DataRowVersion to use when loading Value.

(Inherited from DbParameter)
IDbDataParameter.Precision

Indicates the precision of numeric parameters.

(Inherited from DbParameter)
IDbDataParameter.Scale

For a description of this member, see Scale.

(Inherited from DbParameter)

Applies to

See also