• Главная
• System
• Data
• DataTable

C# Класс System.Data.DataTable

Показать файл Открыть проект Примеры использования класса

Защищенные свойства (Protected)

Свойство	Тип	Описание
fInitInProgress	bool

Private Properties

Свойство	Тип	Описание
AddDependentColumn	void
AddForeignKey	DataColumn
AddRecords	DataRow
AddRow	void
AddRow	void
AddUniqueKey	DataColumn
AddUniqueKey	DataColumn
CacheNestedParent	void
CascadeAll	void
CheckCascadingNamespaceConflict	void
CheckForClosureOnExpressionTables	bool
CheckForClosureOnExpressions	bool
CheckNamespaceValidityForNestedParentRelations	void
CheckNamespaceValidityForNestedRelations	void
CheckNotModifying	void
CheckPrimaryKey	void
Clear	void
Clone	DataTable
CloneHierarchy	DataTable
CloneTo	DataTable
CommitRow	void
Compare	int
Compare	int
ConvertToRowError	void
ConvertToRowState	DataRowState
CopyRow	void
CreateEmptyRow	DataRow
CreateInstance	DataTable
CreateRelationList	void
CreateTableList	void
DeleteRow	void
DeserializeConstraints	void
DeserializeDataTable	void
DeserializeExpressionColumns	void
DeserializeTableData	void
DeserializeTableSchema	void
DoRaiseNamespaceChange	void
EnableConstraints	void
EvaluateDependentExpressions	void
EvaluateDependentExpressions	void
EvaluateExpressions	void
EvaluateExpressions	void
EvaluateExpressions	void
FindByIndex	DataRow
FindByPrimaryKey	DataRow
FindMergeTarget	DataRow
FindNestedParentRelations	DataRelation[]
FindRow	DataRow
FormatSortString	string
FreeRecord	void
GetIndex	Index
GetIndex	Index
GetIndex	Index
GetInheritedNamespace	string
GetListeners	List
GetPropertyDescriptorCollection	PropertyDescriptorCollection
GetRowAndColumnErrors	void
GetSpecialHashCode	int
IListSource	IList
IXmlSerializable	XmlSchema
IXmlSerializable	void
IXmlSerializable	void
IncrementalCloneTo	DataTable
IndexOf	int
InsertRecordToIndexes	int[]
InsertRow	void
InsertRow	void
InsertRow	void
IsEmptyXml	bool
IsNamespaceInherited	bool
IsSuffix	bool
LoadRow	DataRow
MergeRow	DataRow
MoveToElement	bool
NewEmptyRow	DataRow
NewIndexDesc	IndexField[]
NewRecord	int
NewRecord	int
NewRecordFromArray	int
NewRow	DataRow
NewRowArray	DataRow[]
NewRowCreated	void
NewUninitializedRecord	int
NewUninitializedRow	DataRow
OnInitialized	void
OnRemoveColumnInternal	void
OnRowChanged	DataRowChangeEventArgs
OnRowChanging	DataRowChangeEventArgs
ParseSortString	IndexField[]
RaisePropertyChanging	void
RaiseRowChanged	DataRowChangeEventArgs
RaiseRowChanging	DataRowChangeEventArgs
RaiseRowChanging	DataRowChangeEventArgs
ReadEndElement	void
ReadXDRSchema	void
ReadXSDSchema	void
ReadXml	XmlReadMode
ReadXml	XmlReadMode
ReadXmlDiffgram	void
ReadXmlSchema	void
RecordChanged	void
RecordChanged	void
RecordStateChanged	void
RecordStateChanged	void
RemoveDependentColumn	void
RemoveRecordFromIndexes	int[]
RemoveRow	void
ResetCaseSensitive	void
ResetColumns	void
ResetConstraints	void
ResetIndexes	void
ResetInternalIndexes	void
ResetNamespace	void
ResetPrimaryKey	void
RestoreConstraint	void
RestoreIndexEvents	void
RestoreShadowIndexes	void
RollbackRow	void
SerializeConstraints	void
SerializeDataTable	void
SerializeExpressionColumns	void
SerializeTableData	void
SerializeTableSchema	void
SetCaseSensitiveValue	bool
SetDataRowWithLoadOption	void
SetDataSet	void
SetKeyValues	void
SetLocaleValue	bool
SetMergeRecords	void
SetNewRecord	void
SetNewRecordWorker	void
SetOldRecord	void
SetShadowIndexes	void
ShadowIndexCopy	void
ShouldSerializeCaseSensitive	bool
ShouldSerializeLocale	bool
ShouldSerializeNamespace	bool
ShouldSerializePrimaryKey	bool
SilentlySetValue	void
SuspendIndexEvents	void
UpdatePropertyDescriptorCollectionCache	void
UpdatingAdd	DataRow
UpdatingCurrent	bool

Открытые методы

Метод	Описание
AcceptChanges ( ) : void	Commits all the changes made to this table since the last time was called.
BeginInit ( ) : void
BeginLoadData ( ) : void
Clear ( ) : void	Clears the table of all data.
Clone ( ) : DataTable
Compute ( string expression, string filter ) : object	Computes the given expression on the current rows that pass the filter criteria.
Copy ( ) : DataTable
CreateDataReader ( ) : DataTableReader
DataTable ( ) : System.Collections	Initializes a new instance of the class with no arguments.
DataTable ( string tableName ) : System.Collections	Intitalizes a new instance of the class with the specified table name.
DataTable ( string tableName, string tableNamespace ) : System.Collections
EndInit ( ) : void
EndLoadData ( ) : void
GetChanges ( ) : DataTable
GetChanges ( DataRowState rowStates ) : DataTable
GetDataTableSchema ( XmlSchemaSet schemaSet ) : XmlSchemaComplexType
GetErrors ( ) : DataRow[]	Returns an array of objects that contain errors.
GetObjectData ( SerializationInfo info, StreamingContext context ) : void
ImportRow ( DataRow row ) : void
Load ( IDataReader reader ) : void
Load ( IDataReader reader, LoadOption loadOption ) : void
Load ( IDataReader reader, LoadOption loadOption, FillErrorEventHandler errorHandler ) : void
LoadDataRow ( object values, LoadOption loadOption ) : DataRow	Finds and updates a specific row. If no matching row is found, a new row is created using the given values.
LoadDataRow ( object values, bool fAcceptChanges ) : DataRow	Finds and updates a specific row. If no matching row is found, a new row is created using the given values.
Merge ( DataTable table ) : void
Merge ( DataTable table, bool preserveChanges ) : void
Merge ( DataTable table, bool preserveChanges, MissingSchemaAction missingSchemaAction ) : void
NewRow ( ) : DataRow	Creates a new with the same schema as the table.
ReadXml ( Stream stream ) : XmlReadMode
ReadXml ( TextReader reader ) : XmlReadMode
ReadXml ( XmlReader reader ) : XmlReadMode
ReadXml ( string fileName ) : XmlReadMode
ReadXmlSchema ( Stream stream ) : void
ReadXmlSchema ( TextReader reader ) : void
ReadXmlSchema ( XmlReader reader ) : void
ReadXmlSchema ( string fileName ) : void
RejectChanges ( ) : void	Rolls back all changes that have been made to the table since it was loaded, or the last time was called.
Reset ( ) : void
Select ( ) : DataRow[]	Returns an array of all objects.
Select ( string filterExpression ) : DataRow[]	Returns an array of all objects that match the filter criteria in order of primary key (or lacking one, order of addition.)
Select ( string filterExpression, string sort ) : DataRow[]	Returns an array of all objects that match the filter criteria, in the the specified sort order.
Select ( string filterExpression, string sort, DataViewRowState recordStates ) : DataRow[]	Returns an array of all objects that match the filter in the order of the sort, that match the specified state.
ToString ( ) : string	Returns the and , if there is one as a concatenated string.
WriteXml ( Stream stream ) : void
WriteXml ( Stream stream, XmlWriteMode mode ) : void
WriteXml ( Stream stream, XmlWriteMode mode, bool writeHierarchy ) : void
WriteXml ( Stream stream, bool writeHierarchy ) : void
WriteXml ( TextWriter writer ) : void
WriteXml ( TextWriter writer, XmlWriteMode mode ) : void
WriteXml ( TextWriter writer, XmlWriteMode mode, bool writeHierarchy ) : void
WriteXml ( TextWriter writer, bool writeHierarchy ) : void
WriteXml ( XmlWriter writer ) : void
WriteXml ( XmlWriter writer, XmlWriteMode mode ) : void
WriteXml ( XmlWriter writer, XmlWriteMode mode, bool writeHierarchy ) : void
WriteXml ( XmlWriter writer, bool writeHierarchy ) : void
WriteXml ( string fileName ) : void
WriteXml ( string fileName, XmlWriteMode mode ) : void
WriteXml ( string fileName, XmlWriteMode mode, bool writeHierarchy ) : void
WriteXml ( string fileName, bool writeHierarchy ) : void
WriteXmlSchema ( Stream stream ) : void
WriteXmlSchema ( Stream stream, bool writeHierarchy ) : void
WriteXmlSchema ( TextWriter writer ) : void
WriteXmlSchema ( TextWriter writer, bool writeHierarchy ) : void
WriteXmlSchema ( XmlWriter writer ) : void
WriteXmlSchema ( XmlWriter writer, bool writeHierarchy ) : void
WriteXmlSchema ( string fileName ) : void
WriteXmlSchema ( string fileName, bool writeHierarchy ) : void

Защищенные методы

Метод	Описание
DataTable ( SerializationInfo info, StreamingContext context ) : System.Collections
GetRowType ( ) : Type	Gets the row type.
GetSchema ( ) : XmlSchema
NewRowFromBuilder ( DataRowBuilder builder ) : DataRow
OnColumnChanged ( DataColumnChangeEventArgs e ) : void
OnColumnChanging ( DataColumnChangeEventArgs e ) : void
OnPropertyChanging ( PropertyChangedEventArgs pcevent ) : void
OnRemoveColumn ( DataColumn column ) : void	Notifies the that a is being removed.
OnRowChanged ( DataRowChangeEventArgs e ) : void	Raises the event.
OnRowChanging ( DataRowChangeEventArgs e ) : void	Raises the event.
OnRowDeleted ( DataRowChangeEventArgs e ) : void	Raises the event.
OnRowDeleting ( DataRowChangeEventArgs e ) : void	Raises the event.
OnTableCleared ( DataTableClearEventArgs e ) : void
OnTableClearing ( DataTableClearEventArgs e ) : void
OnTableNewRow ( DataTableNewRowEventArgs e ) : void
ReadXmlSerializable ( XmlReader reader ) : void

Приватные методы

Метод	Описание
AddDependentColumn ( DataColumn expressionColumn ) : void
AddForeignKey ( DataColumn parentKey ) : DataColumn
AddRecords ( int oldRecord, int newRecord ) : DataRow
AddRow ( DataRow row ) : void
AddRow ( DataRow row, int proposedID ) : void
AddUniqueKey ( ) : DataColumn
AddUniqueKey ( int position ) : DataColumn
CacheNestedParent ( ) : void
CascadeAll ( DataRow row, DataRowAction action ) : void
CheckCascadingNamespaceConflict ( string realNamespace ) : void
CheckForClosureOnExpressionTables ( List tableList ) : bool
CheckForClosureOnExpressions ( DataTable dt, bool writeHierarchy ) : bool
CheckNamespaceValidityForNestedParentRelations ( string ns, DataTable parentTable ) : void
CheckNamespaceValidityForNestedRelations ( string realNamespace ) : void
CheckNotModifying ( DataRow row ) : void
CheckPrimaryKey ( ) : void
Clear ( bool clearAll ) : void
Clone ( DataSet cloneDS ) : DataTable
CloneHierarchy ( DataTable sourceTable, DataSet ds, Hashtable visitedMap ) : DataTable
CloneTo ( DataTable clone, DataSet cloneDS, bool skipExpressionColumns ) : DataTable
CommitRow ( DataRow row ) : void
Compare ( string s1, string s2 ) : int
Compare ( string s1, string s2, CompareInfo comparer ) : int
ConvertToRowError ( int rowIndex, Hashtable rowErrors, Hashtable colErrors ) : void
ConvertToRowState ( BitArray bitStates, int bitIndex ) : DataRowState
CopyRow ( DataTable table, DataRow row ) : void
CreateEmptyRow ( ) : DataRow
CreateInstance ( ) : DataTable
CreateRelationList ( List tableList, List relationList ) : void
CreateTableList ( DataTable currentTable, List tableList ) : void
DeleteRow ( DataRow row ) : void
DeserializeConstraints ( SerializationInfo info, StreamingContext context, int serIndex, bool allConstraints ) : void
DeserializeDataTable ( SerializationInfo info, StreamingContext context, bool isSingleTable, SerializationFormat remotingFormat ) : void
DeserializeExpressionColumns ( SerializationInfo info, StreamingContext context, int serIndex ) : void
DeserializeTableData ( SerializationInfo info, StreamingContext context, int serIndex ) : void
DeserializeTableSchema ( SerializationInfo info, StreamingContext context, bool isSingleTable ) : void
DoRaiseNamespaceChange ( ) : void
EnableConstraints ( ) : void
EvaluateDependentExpressions ( DataColumn column ) : void
EvaluateDependentExpressions ( List columns, DataRow row, DataRowVersion version, List cachedRows ) : void
EvaluateExpressions ( ) : void
EvaluateExpressions ( DataColumn column ) : void
EvaluateExpressions ( DataRow row, DataRowAction action, List cachedRows ) : void
FindByIndex ( Index ndx, object key ) : DataRow
FindByPrimaryKey ( object values ) : DataRow
FindMergeTarget ( DataRow row, DataKey key, Index ndx ) : DataRow
FindNestedParentRelations ( ) : DataRelation[]
FindRow ( DataKey key, object values ) : DataRow
FormatSortString ( IndexField indexDesc ) : string
FreeRecord ( int &record ) : void
GetIndex ( IndexField indexDesc ) : Index
GetIndex ( IndexField indexDesc, DataViewRowState recordStates, IFilter rowFilter ) : Index
GetIndex ( string sort, DataViewRowState recordStates, IFilter rowFilter ) : Index
GetInheritedNamespace ( List visitedTables ) : string
GetListeners ( ) : List
GetPropertyDescriptorCollection ( Attribute attributes ) : PropertyDescriptorCollection	Retrieves an array of properties that the given component instance provides. This may differ from the set of properties the class provides. If the component is sited, the site may add or remove additional properties. The returned array of properties will be filtered by the given set of attributes.
GetRowAndColumnErrors ( int rowIndex, Hashtable rowErrors, Hashtable colErrors ) : void
GetSpecialHashCode ( string name ) : int
IListSource ( ) : IList
IXmlSerializable ( ) : XmlSchema
IXmlSerializable ( XmlReader reader ) : void
IXmlSerializable ( XmlWriter writer ) : void
IncrementalCloneTo ( DataTable sourceTable, DataTable targetTable ) : DataTable
IndexOf ( string s1, string s2 ) : int
InsertRecordToIndexes ( DataRow row, DataRowVersion version ) : int[]
InsertRow ( DataRow row, int proposedID, int pos ) : void
InsertRow ( DataRow row, long proposedID ) : void
InsertRow ( DataRow row, long proposedID, int pos, bool fireEvent ) : void
IsEmptyXml ( XmlReader reader ) : bool
IsNamespaceInherited ( ) : bool
IsSuffix ( string s1, string s2 ) : bool
LoadRow ( object values, LoadOption loadOption, Index searchIndex ) : DataRow
MergeRow ( DataRow row, DataRow targetRow, bool preserveChanges, Index idxSearch ) : DataRow
MoveToElement ( XmlReader reader, int depth ) : bool
NewEmptyRow ( ) : DataRow
NewIndexDesc ( DataKey key ) : IndexField[]
NewRecord ( ) : int
NewRecord ( int sourceRecord ) : int
NewRecordFromArray ( object value ) : int
NewRow ( int record ) : DataRow
NewRowArray ( int size ) : DataRow[]
NewRowCreated ( DataRow row ) : void
NewUninitializedRecord ( ) : int
NewUninitializedRow ( ) : DataRow
OnInitialized ( ) : void
OnRemoveColumnInternal ( DataColumn column ) : void
OnRowChanged ( DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction ) : DataRowChangeEventArgs
OnRowChanging ( DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction ) : DataRowChangeEventArgs
ParseSortString ( string sortString ) : IndexField[]
RaisePropertyChanging ( string name ) : void
RaiseRowChanged ( DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction ) : DataRowChangeEventArgs
RaiseRowChanging ( DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction ) : DataRowChangeEventArgs
RaiseRowChanging ( DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction, bool fireEvent ) : DataRowChangeEventArgs
ReadEndElement ( XmlReader reader ) : void
ReadXDRSchema ( XmlReader reader ) : void
ReadXSDSchema ( XmlReader reader, bool denyResolving ) : void
ReadXml ( XmlReader reader, XmlReadMode mode, bool denyResolving ) : XmlReadMode
ReadXml ( XmlReader reader, bool denyResolving ) : XmlReadMode
ReadXmlDiffgram ( XmlReader reader ) : void
ReadXmlSchema ( XmlReader reader, bool denyResolving ) : void
RecordChanged ( int record ) : void
RecordChanged ( int oldIndex, int newIndex ) : void
RecordStateChanged ( int record, DataViewRowState oldState, DataViewRowState newState ) : void
RecordStateChanged ( int record1, DataViewRowState oldState1, DataViewRowState newState1, int record2, DataViewRowState oldState2, DataViewRowState newState2 ) : void
RemoveDependentColumn ( DataColumn expressionColumn ) : void
RemoveRecordFromIndexes ( DataRow row, DataRowVersion version ) : int[]
RemoveRow ( DataRow row, bool check ) : void
ResetCaseSensitive ( ) : void
ResetColumns ( ) : void
ResetConstraints ( ) : void	Resets the property to its default state.
ResetIndexes ( ) : void
ResetInternalIndexes ( DataColumn column ) : void
ResetNamespace ( ) : void	Resets the property to its default state.
ResetPrimaryKey ( ) : void	Resets the property to its default state.
RestoreConstraint ( bool originalEnforceConstraint ) : void
RestoreIndexEvents ( bool forceReset ) : void
RestoreShadowIndexes ( ) : void
RollbackRow ( DataRow row ) : void
SerializeConstraints ( SerializationInfo info, StreamingContext context, int serIndex, bool allConstraints ) : void
SerializeDataTable ( SerializationInfo info, StreamingContext context, bool isSingleTable, SerializationFormat remotingFormat ) : void
SerializeExpressionColumns ( SerializationInfo info, StreamingContext context, int serIndex ) : void
SerializeTableData ( SerializationInfo info, StreamingContext context, int serIndex ) : void
SerializeTableSchema ( SerializationInfo info, StreamingContext context, bool isSingleTable ) : void
SetCaseSensitiveValue ( bool isCaseSensitive, bool userSet, bool resetIndexes ) : bool
SetDataRowWithLoadOption ( DataRow dataRow, int recordNo, LoadOption loadOption, bool checkReadOnly ) : void
SetDataSet ( DataSet dataSet ) : void	Internal method for setting the DataSet pointer.
SetKeyValues ( DataKey key, object keyValues, int record ) : void
SetLocaleValue ( CultureInfo culture, bool userSet, bool resetIndexes ) : bool
SetMergeRecords ( DataRow row, int newRecord, int oldRecord, DataRowAction action ) : void
SetNewRecord ( DataRow row, int proposedRecord, DataRowAction action = DataRowAction.Change, bool isInMerge = false, bool fireEvent = true, bool suppressEnsurePropertyChanged = false ) : void
SetNewRecordWorker ( DataRow row, int proposedRecord, DataRowAction action, bool isInMerge, bool suppressEnsurePropertyChanged, int position, bool fireEvent, Exception &deferredException ) : void
SetOldRecord ( DataRow row, int proposedRecord ) : void
SetShadowIndexes ( ) : void
ShadowIndexCopy ( ) : void
ShouldSerializeCaseSensitive ( ) : bool
ShouldSerializeLocale ( ) : bool
ShouldSerializeNamespace ( ) : bool	Indicates whether the property should be persisted.
ShouldSerializePrimaryKey ( ) : bool	Indicates whether the property should be persisted.
SilentlySetValue ( DataRow dr, DataColumn dc, DataRowVersion version, object newValue ) : void
SuspendIndexEvents ( ) : void
UpdatePropertyDescriptorCollectionCache ( ) : void
UpdatingAdd ( object values ) : DataRow
UpdatingCurrent ( DataRow row, DataRowAction action ) : bool

Описание методов

Описание свойств