Precision Property (DbLoaderColumn)

In This Topic

Gets or sets the maximum number of digits used to represent the column value.

Syntax

Visual Basic
C#

'Declaration
 
Public Overridable Property Precision As Integer

public virtual int Precision {get; set;}

Property Value

The maximum number of digits used to represent the column value. The default value is 0.

Remarks

Use Precision property to set the precision of number columns.

Example

csharp

public void GetDataColumns(MagentoConnection adobe commerceConnection)
{
  
  adobe commerceConnection.Open();
  MagentoLoader loader = new MagentoLoader();
  loader.Connection = adobe commerceConnection;
  loader.TableName = "load_table";
  MagentoLoaderColumn myColumn;
  try
  {
    loader.CreateColumns();
    for (int i = 0; i < loader.Columns.Count; i++)
    {
      myColumn = loader.Columns[i];
      Console.WriteLine(myColumn.Name);
      Console.WriteLine(myColumn.MagentoType.ToString());
      Console.WriteLine(myColumn.Size);
      Console.WriteLine(myColumn.Scale);
      Console.WriteLine(myColumn.Precision);
      Console.WriteLine();
    }
   }
  finally
  {
    adobe commerceConnection.Close();
  }
}

Visual Basic

Public Sub GetDataColumns(ByVal adobe commerceConnection As MagentoConnection)
  adobe commerceConnection.Open()
  Dim loader As MagentoLoader
  loader = New MagentoLoader
  loader.Connection = adobe commerceConnection
  loader.TableName = "load_table"
  Dim myColumn As MagentoLoaderColumn
  Try
    loader.CreateColumns()
    Dim i As Integer
    For i = 0 To loader.Columns.Count - 1
      myColumn = loader.Columns(i)
      Console.WriteLine(myColumn.Name)
      Console.WriteLine(myColumn.MagentoType.ToString())
      Console.WriteLine(myColumn.Size)
      Console.WriteLine(myColumn.Scale)
      Console.WriteLine(myColumn.Precision)
      Console.WriteLine()
    Next i
  Finally
    adobe commerceConnection.Close()
  End Try
End Sub

Reference

DbLoaderColumn Class
DbLoaderColumn Members

Send Feedback