dotConnect for SQL Server Documentation
Devart.Common Namespace / DbLoaderColumn Class / Scale Property
Example

In This Topic
    Scale Property (DbLoaderColumn)
    In This Topic
    Gets or sets the number of decimal places to which column value is resolved.
    Syntax
    'Declaration
     
    Public Property Scale As Integer
    public int Scale {get; set;}

    Property Value

    The number of decimal places to which column value is resolved. The default value is 0.
    Remarks
    Use Scale property to set the scale of number columns.
    Example
    public void GetDataColumns(SqlConnection myConnection)
    {
      
      myConnection.Open();
      SqlLoader loader = new SqlLoader();
      loader.Connection = myConnection;
      loader.TableName = "load_table";
      SqlLoaderColumn myColumn;
      try
      {
        loader.CreateColumns();
        for (int i = 0; i < loader.Columns.Count; i++)
        {
          myColumn = loader.Columns[i];
          Console.WriteLine(myColumn.Name);
          Console.WriteLine(myColumn.SqlType.ToString());
          Console.WriteLine(myColumn.Size);
          Console.WriteLine(myColumn.Scale);
          Console.WriteLine(myColumn.Precision);
          Console.WriteLine();
        }
       }
      finally
      {
        myConnection.Close();
      }
    }
    public void GetDataColumns(SqlConnection myConnection)
    {
      
      myConnection.Open();
      SqlLoader loader = new SqlLoader();
      loader.Connection = myConnection;
      loader.TableName = "load_table";
      SqlLoaderColumn myColumn;
      try
      {
        loader.CreateColumns();
        for (int i = 0; i < loader.Columns.Count; i++)
        {
          myColumn = loader.Columns[i];
          Console.WriteLine(myColumn.Name);
          Console.WriteLine(myColumn.SqlType.ToString());
          Console.WriteLine(myColumn.Size);
          Console.WriteLine(myColumn.Scale);
          Console.WriteLine(myColumn.Precision);
          Console.WriteLine();
        }
       }
      finally
      {
        myConnection.Close();
      }
    }
    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