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

Name Property (DbLoaderColumn)
Gets or sets the name of the DbLoaderColumn.
Syntax
'Declaration
 
Public Property Name As String
 

Property Value

The name of the DbLoaderColumn. The default value is an empty string ("").
Remarks
Every DbLoaderColumn object corresponds to one of the table fields with the same name as its Name property.
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();
  }
}
See Also