Precision Property (DbLoaderColumn)

In This Topic

Syntax
Remarks
Example
Requirements
See Also

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

Syntax

Visual Basic
C#

public virtual int Precision {get; set;}

'Declaration
 
Public Overridable Property Precision As Integer

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 magentoConnection)
{
  
  magentoConnection.Open();
  MagentoLoader loader = new MagentoLoader();
  loader.Connection = magentoConnection;
  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
  {
    magentoConnection.Close();
  }
}

Visual Basic

Public Sub GetDataColumns(ByVal magentoConnection As MagentoConnection)
  magentoConnection.Open()
  Dim loader As MagentoLoader
  loader = New MagentoLoader
  loader.Connection = magentoConnection
  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
    magentoConnection.Close()
  End Try
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

Reference

DbLoaderColumn Class
DbLoaderColumn Members

Send Feedback