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

Scale Property (DbLoaderColumn)
Gets or sets the number of decimal places to which column value is resolved.
Syntax
'Declaration
 
Public Property Scale As Integer
 

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(BigcommerceConnection bigcommerceConnection)
{
  
  bigcommerceConnection.Open();
  BigcommerceLoader loader = new BigcommerceLoader();
  loader.Connection = bigcommerceConnection;
  loader.TableName = "load_table";
  BigcommerceLoaderColumn myColumn;
  try
  {
    loader.CreateColumns();
    for (int i = 0; i < loader.Columns.Count; i++)
    {
      myColumn = loader.Columns[i];
      Console.WriteLine(myColumn.Name);
      Console.WriteLine(myColumn.BigcommerceType.ToString());
      Console.WriteLine(myColumn.Size);
      Console.WriteLine(myColumn.Scale);
      Console.WriteLine(myColumn.Precision);
      Console.WriteLine();
    }
   }
  finally
  {
    bigcommerceConnection.Close();
  }
}
public void GetDataColumns(BigcommerceConnection bigcommerceConnection)
{
  
  bigcommerceConnection.Open();
  BigcommerceLoader loader = new BigcommerceLoader();
  loader.Connection = bigcommerceConnection;
  loader.TableName = "load_table";
  BigcommerceLoaderColumn myColumn;
  try
  {
    loader.CreateColumns();
    for (int i = 0; i < loader.Columns.Count; i++)
    {
      myColumn = loader.Columns[i];
      Console.WriteLine(myColumn.Name);
      Console.WriteLine(myColumn.BigcommerceType.ToString());
      Console.WriteLine(myColumn.Size);
      Console.WriteLine(myColumn.Scale);
      Console.WriteLine(myColumn.Precision);
      Console.WriteLine();
    }
   }
  finally
  {
    bigcommerceConnection.Close();
  }
}
See Also