SqlParameter.SqlDbType Property
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); };C#
public System.Data.SqlDbType SqlDbType { get; set; }C#
[System.Data.DataSysDescription("SqlParameter_SqlDbType")]
public System.Data.SqlDbType SqlDbType { get; set; }C#
[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, setPublic Property SqlDbType As SqlDbTypeOne of the SqlDbType values. The default is NVarChar.
- Attributes
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.
| Product | Versions |
|---|---|
| .NET | Core 1.0, Core 1.1, 6 (package-provided), 7 (package-provided), 8 (package-provided), 9 (package-provided), 10 (package-provided) |
| .NET Framework | 1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1 |
| .NET Standard | 2.0 (package-provided) |
Collaborate with us on GitHub
The source for this content can be found on GitHub, where you can also create and review issues and pull requests. For more information, see our contributor guide.
.NET feedback
.NET is an open source project. Select a link to provide feedback: