SqlParameter.SqlDbType Property

Definition

Gets or sets the SqlDbType of the parameter.

public:
 property System::Data::SqlDbType SqlDbType { System::Data::SqlDbType get(); void set(System::Data::SqlDbType value); };
[System.Data.Common.DbProviderSpecificTypeProperty(true)]
public System.Data.SqlDbType SqlDbType { get; set; }
public System.Data.SqlDbType SqlDbType { get; set; }
[<System.Data.Common.DbProviderSpecificTypeProperty(true)>]
member this.SqlDbType : System.Data.SqlDbType with get, set
member this.SqlDbType : System.Data.SqlDbType with get, set
Public Property SqlDbType As SqlDbType

Property Value

One of the SqlDbType values. The default is NVarChar.

Attributes

Remarks

The SqlDbType and DbType are linked. Therefore, setting the DbType changes the SqlDbType to a supporting SqlDbType.

For a list of the supported data types, see the appropriate SqlDbType member. For more information, see DataAdapter Parameters.

For information about streaming, see SqlClient Streaming Support.

Applies to