Databases Reference
In-Depth Information
}
//Close the DataReader.
reader.Close();
//Close the connection.
con.Close();
As a result, we receive the following data. First, we obtain metadata about the columns in
the resultset:
Schema Information about resultset
ColumnName:[Measures].[Store Cost]
ColumnOrdinal:0
ColumnSize:0
NumericPrecision:0
NumericScale:0
DataType:System.Object
ProviderType:System.Object
IsLong:False
AllowDBNull:True
IsReadOnly:True
IsRowVersion:False
IsUnique:False
IsKeyColumn:False
IsAutoIncrement:False
BaseSchemaName:
BaseCatalogName:
BaseTableName:
BaseColumnName:
ColumnName:[Measures].[Store Sales]
ColumnOrdinal:1
ColumnSize:0
NumericPrecision:0
NumericScale:0
DataType:System.Object
ProviderType:System.Object
IsLong:False
AllowDBNull:True
IsReadOnly:True
IsRowVersion:False
IsUnique:False
IsKeyColumn:False
IsAutoIncrement:False
Search WWH ::




Custom Search