This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Download Microsoft Edge
More info about Internet Explorer and Microsoft Edge
public:
virtual property System::Object ^ Value { System::Object ^ get(); void set(System::Object ^ value); };
public:
property System::Object ^ Value { System::Object ^ get(); void set(System::Object ^ value); };
public override object Value { get; set; }
[System.ComponentModel.TypeConverter(typeof(System.ComponentModel.StringConverter))]
[System.Data.DataSysDescription("DataParameter_Value")]
public object Value { get; set; }
[System.ComponentModel.TypeConverter(typeof(System.ComponentModel.StringConverter))]
public override object Value { get; set; }
member this.Value : obj with get, set
[<System.ComponentModel.TypeConverter(typeof(System.ComponentModel.StringConverter))>]
[<System.Data.DataSysDescription("DataParameter_Value")>]
member this.Value : obj with get, set
[<System.ComponentModel.TypeConverter(typeof(System.ComponentModel.StringConverter))>]
member this.Value : obj with get, set
Public Overrides Property Value As Object
Public Property Value As Object
Property Value
The following example creates a
SqlParameter
and sets some of its properties.
static void CreateSqlParameterVersion()
SqlParameter parameter = new SqlParameter("Description", SqlDbType.VarChar, 88);
parameter.Value = "garden hose";
Private Sub CreateSqlParameterVersion()
Dim parameter As New SqlParameter("Description", SqlDbType.VarChar, 88)
parameter.Value = "garden hose"
End Sub
Remarks
For input parameters, the value is bound to the
SqlCommand
that is sent to the server. For output and return value parameters, the value is set on completion of the
SqlCommand
and after the
SqlDataReader
is closed.
This property can be set to
null
or
DBNull.Value
. Use
DBNull.Value
to send a NULL value as the value of the parameter. Use
null
or do not set
Value
to use the default value for the parameter.
An exception is thrown if non-Unicode XML data is passed as a string.
If the application specifies the database type, the bound value is converted to that type when the provider sends the data to the server. The provider tries to convert any type of value if it supports the
IConvertible
interface. Conversion errors may result if the specified type is not compatible with the value.
Both the
DbType
and
SqlDbType
properties can be inferred by setting the Value.
The
Value
property is overwritten by
SqlDataAdapter.UpdateCommand
.
For information about streaming, see
SqlClient Streaming Support
.
SQL Server Data Types and ADO.NET
Commands and Parameters (ADO.NET)
DataAdapter Parameters (ADO.NET)
Using the .NET Framework Data Provider for SQL Server
ADO.NET Overview
