dotConnect for SQL Server Documentation
Devart.Data.SqlServer Namespace / SqlParameter Class / DbType Property
Example

In This Topic
    DbType Property
    In This Topic
    Gets or sets the System.Data.DbType of the parameter.
    Syntax
    'Declaration
     
    Public Overrides Property DbType As DbType
    public override DbType DbType {get; set;}

    Property Value

    One of the System.Data.DbType values. The default value is System.String.
    Remarks
    The SqlType and DbType are linked. Therefore, setting the changes the SqlType to a supporting SqlType.

    For a list of the supported data types, see the appropriate SqlType member.

    Example
    The following example creates a SqlParameter and sets some of its properties, including the DbType property.
    public void CreateSqlParameter()
    {
      SqlParameter myParameter = new SqlParameter();
      myParameter.ParameterName = "DName";
      myParameter.DbType = DbType.String;
      myParameter.Direction = ParameterDirection.Output;
      myParameter.Size = 15;
    }
    Public Sub CreateSqlParameter()
      Dim myParameter As New SqlParameter()
      myParameter.ParameterName = "DName"
      myParameter.DbType = DbType.String
      myParameter.Direction = ParameterDirection.Output
      myParameter.Size = 15
    End Sub
    Requirements

    Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also