Precision Property (DbLoaderColumn)
Gets or sets the maximum number of digits used to represent the column value.
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.
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 Sub GetDataColumns(ByVal bigcommerceConnection As BigcommerceConnection)
bigcommerceConnection.Open()
Dim loader As BigcommerceLoader
loader = New BigcommerceLoader
loader.Connection = bigcommerceConnection
loader.TableName = "load_table"
Dim myColumn As BigcommerceLoaderColumn
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.BigcommerceType.ToString())
Console.WriteLine(myColumn.Size)
Console.WriteLine(myColumn.Scale)
Console.WriteLine(myColumn.Precision)
Console.WriteLine()
Next i
Finally
bigcommerceConnection.Close()
End Try
End Sub