dotConnect for SQL Server Documentation
Devart.Common Namespace / DbLoaderColumn Class / ToString Method
Example

In This Topic
    ToString Method (DbLoaderColumn)
    In This Topic
    Returns the name of the DbLoaderColumn.
    Syntax
    'Declaration
     
    Public Overrides Function ToString() As String
    public override string ToString()

    Return Value

    The name of the DbLoaderColumn.
    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