SqlParameter.SqlDbType Property

  • Reference

Definition

Namespace:
Microsoft.Data.SqlClient
Assembly:
Microsoft.Data.SqlClient.dll
Package:
Microsoft.Data.SqlClient v1.0.19269.1
Package:
Microsoft.Data.SqlClient v1.1.4
Package:
Microsoft.Data.SqlClient v2.0.1
Package:
Microsoft.Data.SqlClient v2.1.4
Package:
Microsoft.Data.SqlClient v3.0.1
Package:
Microsoft.Data.SqlClient v3.1.0
Package:
Microsoft.Data.SqlClient v4.0.1
Package:
Microsoft.Data.SqlClient v4.1.0
Package:
Microsoft.Data.SqlClient v5.0.0
Package:
Microsoft.Data.SqlClient v5.1.0
Package:
Microsoft.Data.SqlClient v5.2.0

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

SqlDbType

One of the SqlDbType values. The default is NVarChar.

Attributes
DbProviderSpecificTypePropertyAttribute

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