Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

SqlParameter.SqlDbType Property

Definition

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

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Gets or sets the SqlDbType of the parameter.

public:
 property System::Data::SqlDbType SqlDbType { System::Data::SqlDbType get(); void set(System::Data::SqlDbType value); };
public System.Data.SqlDbType SqlDbType { get; set; }
[System.Data.DataSysDescription("SqlParameter_SqlDbType")]
public System.Data.SqlDbType SqlDbType { get; set; }
[System.Data.Common.DbProviderSpecificTypeProperty(true)]
public System.Data.SqlDbType SqlDbType { get; set; }
member this.SqlDbType : System.Data.SqlDbType with get, set
[<System.Data.DataSysDescription("SqlParameter_SqlDbType")>]
member this.SqlDbType : System.Data.SqlDbType with get, set
[<System.Data.Common.DbProviderSpecificTypeProperty(true)>]
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

See also

Feedback

Was this page helpful?