GetColumnSQLName method

Returns the name of the column identified by the specified column ID.

Syntax
Visual Basic

Public Function GetColumnSQLName( _
   ByVal columnID As Integer _
) As String
C#

public string  GetColumnSQLName(
   int columnID
);
Parameters
  • columnID   ID of the column. The value must be in the range [0,ColumnCount-1].

Return value

The name of the column or a null reference (Nothing in Visual Basic) if the column has no name. If the column is aliased in the SQL query, the alias is returned.

Remarks

Note that in result sets, not all columns have names and not all column names are unique. If you are using aliases, the name of the column is the alias.

The GetColumnSQLName method differs from the GetColumnName in that for non-aliased, non-computed columns GetColumnSQLName always returns just the name of the column (without the table name as a prefix). While this behavior more closely resembles the behavior of other ADO.NET providers, it is more likely to produce non-unique names.

Column IDs and count may change during a schema upgrade. To correctly identify a column, access it by name or refresh the cached IDs and counts after a schema upgrade.

See also