meta data ?

[Lloyd Dupont]

if you call
ExecuteReader(CommandBehavior cb)

your command behavior could be KeyInfo , SchemaOnly , how to you acess these
information ?

how do you query them ?

I'm puzzled ...

any sample ?

 

[David Sceppa]

Lloyd,

To access this schema information, call
DataReader.GetSchemaTable. The method returns a DataTable of
schema information about your resultset. The DataTable contains
columns like ColumnName, DataType, BaseColumnName, IsKey, etc.
Each row in the DataTable corresponds to a column in your
resultset.

The easiest way to examine this schema information is to
bind a DataGrid to the resulting DataTable.

I hope this information proves helpful.

David Sceppa
Microsoft
This posting is provided "AS IS" with no warranties,
and confers no rights. You assume all risk for your use.
© 2003 Microsoft Corporation. All rights reserved.