Ole |
DataSet that knows how to retrieve a schema (tables, columns, views,
sprocs, constraints, relations) based on a connection string.
Inheritance HierarchySystemObject
System.ComponentModelMarshalByValueComponent
System.DataDataSet
Altaxo.DataConnectionOleDbSchema
System.ComponentModelMarshalByValueComponent
System.DataDataSet
Altaxo.DataConnectionOleDbSchema
Namespace: Altaxo.DataConnection
Assembly: AltaxoBase (in AltaxoBase.dll) Version: 4.8.3179.0 (4.8.3179.0)
SyntaxC#
public class OleDbSchema : DataSet
The OleDbSchema type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | OleDbSchema | Initializes a new instance of the OleDbSchema class |
Properties| Name | Description | |
|---|---|---|
 | CaseSensitive | Gets or sets a value indicating whether string comparisons within DataTable objects are case-sensitive. (Inherited from DataSet) |
| ConnectionString | Gets or sets the connection string used to fill this schema. |
| Container | Gets the container for the component. (Inherited from MarshalByValueComponent) |
| DataSetName | Gets or sets the name of the current DataSet. (Inherited from DataSet) |
| DefaultViewManager | Gets a custom view of the data contained in the DataSet to allow filtering, searching, and navigating using a custom DataViewManager. (Inherited from DataSet) |
| DesignMode | Gets a value indicating whether the component is currently in design mode. (Inherited from MarshalByValueComponent) |
| EnforceConstraints | Gets or sets a value indicating whether constraint rules are followed when attempting any update operation. (Inherited from DataSet) |
 | Events | Gets the list of event handlers that are attached to this component. (Inherited from MarshalByValueComponent) |
| ExtendedProperties | Gets the collection of customized user information associated with the DataSet. (Inherited from DataSet) |
| HasErrors | Gets a value indicating whether there are errors in any of the DataTable objects within this DataSet. (Inherited from DataSet) |
| IsInitialized | Gets a value that indicates whether the DataSet is initialized. (Inherited from DataSet) |
| Locale | Gets or sets the locale information used to compare strings within the table. (Inherited from DataSet) |
| Namespace | Gets or sets the namespace of the DataSet. (Inherited from DataSet) |
| Prefix | Gets or sets an XML prefix that aliases the namespace of the DataSet. (Inherited from DataSet) |
| Relations | Gets the collection of relations that link tables and allow navigation from parent tables to child tables. (Inherited from DataSet) |
| RemotingFormat | Gets or sets a SerializationFormat for the DataSet used during remoting. (Inherited from DataSet) |
| SchemaSerializationMode | Gets or sets a SchemaSerializationMode for a DataSet. (Inherited from DataSet) |
| Site | Gets or sets an ISite for the DataSet. (Inherited from DataSet) |
| Tables | Gets the collection of tables contained in the DataSet. (Inherited from DataSet) |
Methods| Name | Description | |
|---|---|---|
| AcceptChanges | Commits all the changes made to this DataSet since it was loaded or since the last time AcceptChanges was called. (Inherited from DataSet) |
| BeginInit | Begins the initialization of a DataSet that is used on a form or used by another component. The initialization occurs at run time. (Inherited from DataSet) |
 | BracketName | Encloses a name in square brackets. |
| Clear | Clears the DataSet of any data by removing all rows in all tables. (Inherited from DataSet) |
| Clone | Copies the structure of the DataSet, including all DataTable schemas, relations, and constraints. Does not copy any data. (Inherited from DataSet) |
| Copy | Copies both the structure and data for this DataSet. (Inherited from DataSet) |
| CreateDataReader | Returns a DataTableReader with one result set per DataTable, in the same sequence as the tables appear in the Tables collection. (Inherited from DataSet) |
| CreateDataReader(DataTable) | Returns a DataTableReader with one result set per DataTable. (Inherited from DataSet) |
 | DetermineSchemaSerializationMode(XmlReader) | Determines the SchemaSerializationMode for a DataSet. (Inherited from DataSet) |
| DetermineSchemaSerializationMode(SerializationInfo, StreamingContext) | Determines the SchemaSerializationMode for a DataSet. (Inherited from DataSet) |
| Dispose | Releases all resources used by the MarshalByValueComponent. (Inherited from MarshalByValueComponent) |
| Dispose(Boolean) | Releases the unmanaged resources used by the MarshalByValueComponent and optionally releases the managed resources. (Inherited from MarshalByValueComponent) |
| EndInit | Ends the initialization of a DataSet that is used on a form or used by another component. The initialization occurs at run time. (Inherited from DataSet) |
| Equals | Determines whether the specified object is equal to the current object. (Inherited from Object) |
| Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from MarshalByValueComponent) |
| GetChanges | Gets a copy of the DataSet that contains all changes made to it since it was loaded or since AcceptChanges was last called. (Inherited from DataSet) |
| GetChanges(DataRowState) | Gets a copy of the DataSet containing all changes made to it since it was last loaded, or since AcceptChanges was called, filtered by DataRowState. (Inherited from DataSet) |
| GetFullTableName | Gets the full table name (e.g. 'dbo.[Order Details]). |
| GetHashCode | Serves as the default hash function. (Inherited from Object) |
| GetObjectData | Populates a serialization information object with the data needed to serialize the DataSet. (Inherited from DataSet) |
| GetOleDbType | Translates an Access parameter type (in PARAMETERS clause) into an OleDbType. |
| GetSchema | Gets a OleDbSchema that contains the schema for a given connection string. |
| GetSchemaSerializable | Returns a serializable XmlSchema instance. (Inherited from DataSet) |
| GetSelectStatement | Gets a select statement that can be used to retrieve data from a given table, view, or stored procedure. |
| GetSerializationData | Deserializes the table data from the binary or XML stream. (Inherited from DataSet) |
| GetService | Gets the implementer of the IServiceProvider. (Inherited from MarshalByValueComponent) |
| GetTableParameters | Gets the parameters required by a stored procedure. |
| GetTableType | Gets the table's underlying type (Table, View, or Stored Procedure). |
| GetType | Gets the Type of the current instance. (Inherited from Object) |
| GetType(OleDbType) | Translates an OleDbType into a .NET type. |
| GetXml | Returns the XML representation of the data stored in the DataSet. (Inherited from DataSet) |
| GetXmlSchema | Returns the XML Schema for the XML representation of the data stored in the DataSet. (Inherited from DataSet) |
| HasChanges | Gets a value indicating whether the DataSet has changes, including new, deleted, or modified rows. (Inherited from DataSet) |
| HasChanges(DataRowState) | Gets a value indicating whether the DataSet has changes, including new, deleted, or modified rows, filtered by DataRowState. (Inherited from DataSet) |
| InferXmlSchema(Stream, String) | Applies the XML schema from the specified Stream to the DataSet. (Inherited from DataSet) |
| InferXmlSchema(String, String) | Applies the XML schema from the specified file to the DataSet. (Inherited from DataSet) |
| InferXmlSchema(TextReader, String) | Applies the XML schema from the specified TextReader to the DataSet. (Inherited from DataSet) |
| InferXmlSchema(XmlReader, String) | Applies the XML schema from the specified XmlReader to the DataSet. (Inherited from DataSet) |
| InitializeDerivedDataSet | Deserialize all of the tables data of the DataSet from the binary or XML stream. (Inherited from DataSet) |
| IsBinarySerialized | Inspects the format of the serialized representation of the DataSet. (Inherited from DataSet) |
| IsDateTime | Checks whether a given type is of type DateTime |
| IsNumeric | Checks whether a given type is numeric. |
| Load(IDataReader, LoadOption, DataTable) | Fills a DataSet with values from a data source using the supplied IDataReader, using an array of DataTable instances to supply the schema and namespace information. (Inherited from DataSet) |
| Load(IDataReader, LoadOption, String) | Fills a DataSet with values from a data source using the supplied IDataReader, using an array of strings to supply the names for the tables within the DataSet. (Inherited from DataSet) |
| Load(IDataReader, LoadOption, FillErrorEventHandler, DataTable) | Fills a DataSet with values from a data source using the supplied IDataReader, using an array of DataTable instances to supply the schema and namespace information. (Inherited from DataSet) |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object) |
| Merge(DataRow) | Merges an array of DataRow objects into the current DataSet. (Inherited from DataSet) |
| Merge(DataSet) | Merges a specified DataSet and its schema into the current DataSet. (Inherited from DataSet) |
| Merge(DataTable) | Merges a specified DataTable and its schema into the current DataSet. (Inherited from DataSet) |
| Merge(DataSet, Boolean) | Merges a specified DataSet and its schema into the current DataSet, preserving or discarding any changes in this DataSet according to the given argument. (Inherited from DataSet) |
| Merge(DataRow, Boolean, MissingSchemaAction) | Merges an array of DataRow objects into the current DataSet, preserving or discarding changes in the DataSet and handling an incompatible schema according to the given arguments. (Inherited from DataSet) |
| Merge(DataSet, Boolean, MissingSchemaAction) | Merges a specified DataSet and its schema with the current DataSet, preserving or discarding changes in the current DataSet and handling an incompatible schema according to the given arguments. (Inherited from DataSet) |
| Merge(DataTable, Boolean, MissingSchemaAction) | Merges a specified DataTable and its schema into the current DataSet, preserving or discarding changes in the DataSet and handling an incompatible schema according to the given arguments. (Inherited from DataSet) |
| OnPropertyChanging | Raises the OnPropertyChanging(PropertyChangedEventArgs) event. (Inherited from DataSet) |
| OnRemoveRelation | Occurs when a DataRelation object is removed from a DataTable. (Inherited from DataSet) |
| OnRemoveTable | Occurs when a DataTable is removed from a DataSet. (Inherited from DataSet) |
| RaisePropertyChanging | Sends a notification that the specified DataSet property is about to change. (Inherited from DataSet) |
| ReadXml(Stream) | Reads XML schema and data into the DataSet using the specified Stream. (Inherited from DataSet) |
| ReadXml(String) | Reads XML schema and data into the DataSet using the specified file. (Inherited from DataSet) |
| ReadXml(TextReader) | Reads XML schema and data into the DataSet using the specified TextReader. (Inherited from DataSet) |
| ReadXml(XmlReader) | Reads XML schema and data into the DataSet using the specified XmlReader. (Inherited from DataSet) |
| ReadXml(Stream, XmlReadMode) | Reads XML schema and data into the DataSet using the specified Stream and XmlReadMode. (Inherited from DataSet) |
| ReadXml(String, XmlReadMode) | Reads XML schema and data into the DataSet using the specified file and XmlReadMode. (Inherited from DataSet) |
| ReadXml(TextReader, XmlReadMode) | Reads XML schema and data into the DataSet using the specified TextReader and XmlReadMode. (Inherited from DataSet) |
| ReadXml(XmlReader, XmlReadMode) | Reads XML schema and data into the DataSet using the specified XmlReader and XmlReadMode. (Inherited from DataSet) |
| ReadXmlSchema(Stream) | Reads the XML schema from the specified Stream into the DataSet. (Inherited from DataSet) |
| ReadXmlSchema(String) | Reads the XML schema from the specified file into the DataSet. (Inherited from DataSet) |
| ReadXmlSchema(TextReader) | Reads the XML schema from the specified TextReader into the DataSet. (Inherited from DataSet) |
| ReadXmlSchema(XmlReader) | Reads the XML schema from the specified XmlReader into the DataSet. (Inherited from DataSet) |
| ReadXmlSerializable | Ignores attributes and returns an empty DataSet. (Inherited from DataSet) |
| RejectChanges | Rolls back all the changes made to the DataSet since it was created, or since the last time AcceptChanges was called. (Inherited from DataSet) |
| Reset | Clears all tables and removes all relations, foreign constraints, and tables from the DataSet. Subclasses should override Reset to restore a DataSet to its original state. (Inherited from DataSet) |
| ShouldSerializeRelations | Gets a value indicating whether Relations property should be persisted. (Inherited from DataSet) |
| ShouldSerializeTables | Gets a value indicating whether Tables property should be persisted. (Inherited from DataSet) |
| ToString | Returns a String containing the name of the Component, if any. This method should not be overridden. (Inherited from MarshalByValueComponent) |
| WriteXml(Stream) | Writes the current data for the DataSet using the specified Stream. (Inherited from DataSet) |
| WriteXml(String) | Writes the current data for the DataSet to the specified file. (Inherited from DataSet) |
| WriteXml(TextWriter) | Writes the current data for the DataSet using the specified TextWriter. (Inherited from DataSet) |
| WriteXml(XmlWriter) | Writes the current data for the DataSet to the specified XmlWriter. (Inherited from DataSet) |
| WriteXml(Stream, XmlWriteMode) | Writes the current data, and optionally the schema, for the DataSet using the specified Stream and XmlWriteMode. To write the schema, set the value for the mode parameter to WriteSchema. (Inherited from DataSet) |
| WriteXml(String, XmlWriteMode) | Writes the current data, and optionally the schema, for the DataSet to the specified file using the specified XmlWriteMode. To write the schema, set the value for the mode parameter to WriteSchema. (Inherited from DataSet) |
| WriteXml(TextWriter, XmlWriteMode) | Writes the current data, and optionally the schema, for the DataSet using the specified TextWriter and XmlWriteMode. To write the schema, set the value for the mode parameter to WriteSchema. (Inherited from DataSet) |
| WriteXml(XmlWriter, XmlWriteMode) | Writes the current data, and optionally the schema, for the DataSet using the specified XmlWriter and XmlWriteMode. To write the schema, set the value for the mode parameter to WriteSchema. (Inherited from DataSet) |
| WriteXmlSchema(Stream) | Writes the DataSet structure as an XML schema to the specified Stream object. (Inherited from DataSet) |
| WriteXmlSchema(String) | Writes the DataSet structure as an XML schema to a file. (Inherited from DataSet) |
| WriteXmlSchema(TextWriter) | Writes the DataSet structure as an XML schema to the specified TextWriter object. (Inherited from DataSet) |
| WriteXmlSchema(XmlWriter) | Writes the DataSet structure as an XML schema to an XmlWriter object. (Inherited from DataSet) |
| WriteXmlSchema(Stream, ConverterType, String) | Writes the DataSet structure as an XML schema to the specified Stream object. (Inherited from DataSet) |
| WriteXmlSchema(String, ConverterType, String) | Writes the DataSet structure as an XML schema to a file. (Inherited from DataSet) |
| WriteXmlSchema(TextWriter, ConverterType, String) | Writes the DataSet structure as an XML schema to the specified TextWriter. (Inherited from DataSet) |
| WriteXmlSchema(XmlWriter, ConverterType, String) | Writes the DataSet structure as an XML schema to the specified XmlWriter. (Inherited from DataSet) |
Events| Name | Description | |
|---|---|---|
 | Disposed | Adds an event handler to listen to the Disposed event on the component. (Inherited from MarshalByValueComponent) |
| Initialized | Occurs after the DataSet is initialized. (Inherited from DataSet) |
| MergeFailed | Occurs when a target and source DataRow have the same primary key value, and EnforceConstraints is set to true. (Inherited from DataSet) |
See Also