The ULDataReader.GetSchemaTable method and ULDataReader.Schema property allow you to retrieve information about a result set, such as column names, total number of columns, column scales, column sizes, and column SQL types.
The following example demonstrates how to use the ULDataReader.Schema and ResultSet.Schema properties to display schema information in a command prompt.
for ( int i = 0; i < MyResultSet.Schema.GetColumnCount(); i++ ) { System.Console.WriteLine( MyResultSet.Schema.GetColumnName(i) + " " + MyResultSet.Schema.GetColumnSQLType(i) ); } |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |