Multimobile Development: Building Applications for any Smartphone
HomeDiscussionsNamespacesFrameworkContactBlog
System.Data.DataTable Class
Information   Base Types   Related Resources

Represents one table of in-memory data.

  • Namespace: System.Data
  • Assembly: System.Data.dll

    		•
    System.ComponentModel.MarshalByValueComponent
    System.Runtime.Serialization.ISerializable
    System.IDisposable
    System.IServiceProvider
    System.ComponentModel.IComponent
    System.ComponentModel.ISupportInitialize
    System.ComponentModel.IListSource
  		• View this type on MSDN
  		• Search for this type on MSDN using MSDN's own search engine
  		• Google for this type - all Web
  		• Google for this type - MSDN only
    Articles (347)Discussions (6212)MembersRotor
    Public Constructors
    public DataTable()(No summary available.)
    public DataTable(System.String)(No summary available.)
    public DataTable(System.String,System.String)(No summary available.)
     
    Public Properties
    public System.Boolean CaseSensitive(No summary available.)
    public System.Data.DataRelationCollection ChildRelations(No summary available.)
    public System.Data.DataColumnCollection Columns(No summary available.)
    public System.Data.ConstraintCollection Constraints(No summary available.)
    public System.ComponentModel.IContainer Container(No summary available.)
    public System.Data.DataSet DataSet(No summary available.)
    public System.Data.DataView DefaultView(No summary available.)
    public System.Boolean DesignMode(No summary available.)
    public System.String DisplayExpression(No summary available.)
    public System.Data.PropertyCollection ExtendedProperties(No summary available.)
    public System.Boolean HasErrors(No summary available.)
    public System.Boolean IsInitialized(No summary available.)
    public System.Globalization.CultureInfo Locale(No summary available.)
    public System.Int32 MinimumCapacity(No summary available.)
    public System.String Namespace(No summary available.)
    public System.Data.DataRelationCollection ParentRelations(No summary available.)
    public System.String Prefix(No summary available.)
    public System.Data.DataColumn[][] PrimaryKey(No summary available.)
    public System.Data.SerializationFormat RemotingFormat(No summary available.)
    public System.Data.DataRowCollection Rows(No summary available.)
    public System.ComponentModel.ISite Site(No summary available.)
    public System.String TableName(No summary available.)
     
    Public Methods
    public void AcceptChanges()(No summary available.)
    public void BeginInit()(No summary available.)
    public void BeginLoadData()(No summary available.)
    public void Clear()(No summary available.)
    public System.Data.DataTable Clone()(No summary available.)
    public System.Object Compute(System.String,System.String)(No summary available.)
    public System.Data.DataTable Copy()(No summary available.)
    public System.Data.DataTableReader CreateDataReader()(No summary available.)
    public void Dispose()(No summary available.)
    public void EndInit()(No summary available.)
    public void EndLoadData()(No summary available.)
    public System.Boolean Equals(System.Object)(No summary available.)
    public System.Data.DataTable GetChanges()(No summary available.)
    public System.Data.DataTable GetChanges(System.Data.DataRowState)(No summary available.)
    public static System.Xml.Schema.XmlSchemaComplexType GetDataTableSchema(System.Xml.Schema.XmlSchemaSet)(No summary available.)
    public System.Data.DataRow[][] GetErrors()(No summary available.)
    public System.Int32 GetHashCode()(No summary available.)
    public void GetObjectData(System.Runtime.Serialization.SerializationInfo,System.Runtime.Serialization.StreamingContext)(No summary available.)
    public System.Object GetService(System.Type)(No summary available.)
    public System.Type GetType()(No summary available.)
    public void ImportRow(System.Data.DataRow)(No summary available.)
    public void Load(System.Data.IDataReader)(No summary available.)
    public void Load(System.Data.IDataReader,System.Data.LoadOption)(No summary available.)
    public void Load(System.Data.IDataReader,System.Data.LoadOption,System.Data.FillErrorEventHandler)(No summary available.)
    public System.Data.DataRow LoadDataRow(System.Object[][],System.Boolean)(No summary available.)
    public System.Data.DataRow LoadDataRow(System.Object[][],System.Data.LoadOption)(No summary available.)
    public void Merge(System.Data.DataTable)(No summary available.)
    public void Merge(System.Data.DataTable,System.Boolean)(No summary available.)
    public void Merge(System.Data.DataTable,System.Boolean,System.Data.MissingSchemaAction)(No summary available.)
    public System.Data.DataRow NewRow()(No summary available.)
    public System.Data.XmlReadMode ReadXml(System.IO.Stream)(No summary available.)
    public System.Data.XmlReadMode ReadXml(System.IO.TextReader)(No summary available.)
    public System.Data.XmlReadMode ReadXml(System.String)(No summary available.)
    public System.Data.XmlReadMode ReadXml(System.Xml.XmlReader)(No summary available.)
    public void ReadXmlSchema(System.IO.Stream)(No summary available.)
    public void ReadXmlSchema(System.IO.TextReader)(No summary available.)
    public void ReadXmlSchema(System.String)(No summary available.)
    public void ReadXmlSchema(System.Xml.XmlReader)(No summary available.)
    public void RejectChanges()(No summary available.)
    public void Reset()(No summary available.)
    public System.Data.DataRow[][] Select()(No summary available.)
    public System.Data.DataRow[][] Select(System.String)(No summary available.)
    public System.Data.DataRow[][] Select(System.String,System.String)(No summary available.)
    public System.Data.DataRow[][] Select(System.String,System.String,System.Data.DataViewRowState)(No summary available.)
    public System.String ToString()(No summary available.)
    public void WriteXml(System.Xml.XmlWriter,System.Boolean)(No summary available.)
    public void WriteXml(System.String)(No summary available.)
    public void WriteXml(System.String,System.Boolean)(No summary available.)
    public void WriteXml(System.IO.Stream,System.Data.XmlWriteMode)(No summary available.)
    public void WriteXml(System.IO.Stream,System.Data.XmlWriteMode,System.Boolean)(No summary available.)
    public void WriteXml(System.IO.TextWriter,System.Data.XmlWriteMode)(No summary available.)
    public void WriteXml(System.IO.TextWriter,System.Data.XmlWriteMode,System.Boolean)(No summary available.)
    public void WriteXml(System.Xml.XmlWriter,System.Data.XmlWriteMode)(No summary available.)
    public void WriteXml(System.Xml.XmlWriter,System.Data.XmlWriteMode,System.Boolean)(No summary available.)
    public void WriteXml(System.String,System.Data.XmlWriteMode)(No summary available.)
    public void WriteXml(System.String,System.Data.XmlWriteMode,System.Boolean)(No summary available.)
    public void WriteXml(System.IO.Stream)(No summary available.)
    public void WriteXml(System.IO.Stream,System.Boolean)(No summary available.)
    public void WriteXml(System.IO.TextWriter)(No summary available.)
    public void WriteXml(System.IO.TextWriter,System.Boolean)(No summary available.)
    public void WriteXml(System.Xml.XmlWriter)(No summary available.)
    public void WriteXmlSchema(System.IO.Stream)(No summary available.)
    public void WriteXmlSchema(System.IO.Stream,System.Boolean)(No summary available.)
    public void WriteXmlSchema(System.IO.TextWriter)(No summary available.)
    public void WriteXmlSchema(System.IO.TextWriter,System.Boolean)(No summary available.)
    public void WriteXmlSchema(System.Xml.XmlWriter)(No summary available.)
    public void WriteXmlSchema(System.Xml.XmlWriter,System.Boolean)(No summary available.)
    public void WriteXmlSchema(System.String)(No summary available.)
    public void WriteXmlSchema(System.String,System.Boolean)(No summary available.)
     
    Public Events
    public void ColumnChanged()(No summary available.)
    public void ColumnChanging()(No summary available.)
    public void Disposed()(No summary available.)
    public void Initialized()(No summary available.)
    public void PropertyChanging()(No summary available.)
    public void RowChanged()(No summary available.)
    public void RowChanging()(No summary available.)
    public void RowDeleted()(No summary available.)
    public void RowDeleting()(No summary available.)
    public void TableCleared()(No summary available.)
    public void TableClearing()(No summary available.)
    public void TableNewRow()(No summary available.)
     
    Protected Constructors
    protected DataTable(System.Runtime.Serialization.SerializationInfo,System.Runtime.Serialization.StreamingContext)(No summary available.)
     
    Protected Fields
    protected System.Data.DataColumn _colUnique(No summary available.)
    protected System.Data.IndexField[][] _primaryIndex(No summary available.)
    protected System.Boolean _suspendEnforceConstraints(No summary available.)
    protected System.Data.DataRelationCollection childRelationsCollection(No summary available.)
    protected System.Data.DataColumnCollection columnCollection(No summary available.)
    protected System.Data.DataExpression displayExpression(No summary available.)
    protected System.String encodedTableName(No summary available.)
    protected System.Data.PropertyCollection extendedProperties(No summary available.)
    protected System.Boolean fInLoadDiffgram(No summary available.)
    protected System.Boolean fNestedInDataset(No summary available.)
    protected System.Threading.ReaderWriterLock indexesLock(No summary available.)
    protected System.Decimal maxOccurs(No summary available.)
    protected System.Decimal minOccurs(No summary available.)
    protected System.Int32 nextRowID(No summary available.)
    protected System.Data.DataRelationCollection parentRelationsCollection(No summary available.)
    protected System.Data.UniqueConstraint primaryKey(No summary available.)
    protected System.Data.RecordManager recordManager(No summary available.)
    protected System.Boolean repeatableElement(No summary available.)
    protected System.Data.DataRowCollection rowCollection(No summary available.)
    protected System.Collections.Hashtable rowDiffId(No summary available.)
    protected System.String tableNamespace(No summary available.)
    protected System.Boolean textOnly(No summary available.)
    protected System.Int32 ukColumnPositionForInference(No summary available.)
    protected System.Data.DataColumn xmlText(No summary available.)
    protected static System.Data.DataColumn[][] zeroColumns(No summary available.)
    protected static System.Data.IndexField[][] zeroIndexField(No summary available.)
    protected static System.Data.DataRow[][] zeroRows(No summary available.)
     
    Protected Properties
    protected System.Boolean AreIndexEventsSuspended(No summary available.)
    protected System.String DisplayExpressionInternal(No summary available.)
    protected System.Int32 ElementColumnCount(No summary available.)
    protected System.String EncodedTableName(No summary available.)
    protected System.Boolean EnforceConstraints(No summary available.)
    protected System.ComponentModel.EventHandlerList Events(No summary available.)
    protected System.IFormatProvider FormatProvider(No summary available.)
    protected System.Decimal MaxOccurs(No summary available.)
    protected System.Boolean MergingData(No summary available.)
    protected System.Decimal MinOccurs(No summary available.)
    protected System.Boolean NeedColumnChangeEvents(No summary available.)
    protected System.Data.DataRelation[][] NestedParentRelations(No summary available.)
    protected System.Int32 NestedParentsCount(No summary available.)
    protected System.Int32 ObjectID(No summary available.)
    protected System.Int32 RecordCapacity(No summary available.)
    protected System.Collections.Hashtable RowDiffId(No summary available.)
    protected System.Boolean SchemaLoading(No summary available.)
    protected System.Boolean SelfNested(No summary available.)
    protected System.Boolean SuspendEnforceConstraints(No summary available.)
    protected System.Xml.XmlQualifiedName TypeName(No summary available.)
    protected System.Int32 UKColumnPositionForInference(No summary available.)
    protected System.Data.DataColumn XmlText(No summary available.)
     
    Protected Methods
    protected void AddDependentColumn(System.Data.DataColumn)(No summary available.)
    protected System.Data.DataColumn AddForeignKey(System.Data.DataColumn)(No summary available.)
    protected System.Data.DataRow AddRecords(System.Int32,System.Int32)(No summary available.)
    protected void AddRow(System.Data.DataRow)(No summary available.)
    protected void AddRow(System.Data.DataRow,System.Int32)(No summary available.)
    protected System.Data.DataColumn AddUniqueKey(System.Int32)(No summary available.)
    protected System.Data.DataColumn AddUniqueKey()(No summary available.)
    protected void CacheNestedParent()(No summary available.)
    protected void CascadeAll(System.Data.DataRow,System.Data.DataRowAction)(No summary available.)
    protected void CheckCascadingNamespaceConflict(System.String)(No summary available.)
    protected void CheckNamespaceValidityForNestedParentRelations(System.String,System.Data.DataTable)(No summary available.)
    protected void CheckNamespaceValidityForNestedRelations(System.String)(No summary available.)
    protected void CheckNotModifying(System.Data.DataRow)(No summary available.)
    protected void Clear(System.Boolean)(No summary available.)
    protected System.Data.DataTable Clone(System.Data.DataSet)(No summary available.)
    protected void CommitRow(System.Data.DataRow)(No summary available.)
    protected System.Int32 Compare(System.String,System.String)(No summary available.)
    protected void CopyRow(System.Data.DataTable,System.Data.DataRow)(No summary available.)
    protected System.Data.DataRow CreateEmptyRow()(No summary available.)
    protected System.Data.DataTable CreateInstance()(No summary available.)
    protected void DeleteRow(System.Data.DataRow)(No summary available.)
    protected void DeserializeConstraints(System.Runtime.Serialization.SerializationInfo,System.Runtime.Serialization.StreamingContext,System.Int32,System.Boolean)(No summary available.)
    protected void DeserializeDataTable(System.Runtime.Serialization.SerializationInfo,System.Runtime.Serialization.StreamingContext,System.Boolean,System.Data.SerializationFormat)(No summary available.)
    protected void DeserializeExpressionColumns(System.Runtime.Serialization.SerializationInfo,System.Runtime.Serialization.StreamingContext,System.Int32)(No summary available.)
    protected void DeserializeTableData(System.Runtime.Serialization.SerializationInfo,System.Runtime.Serialization.StreamingContext,System.Int32)(No summary available.)
    protected void DeserializeTableSchema(System.Runtime.Serialization.SerializationInfo,System.Runtime.Serialization.StreamingContext,System.Boolean)(No summary available.)
    protected void Dispose(System.Boolean)(No summary available.)
    protected void DoRaiseNamespaceChange()(No summary available.)
    protected void EnableConstraints()(No summary available.)
    protected void Finalize()(No summary available.)
    protected System.Data.DataRow FindByIndex(System.Data.Index,System.Object[][])(No summary available.)
    protected System.Data.DataRow FindByPrimaryKey(System.Object[][])(No summary available.)
    protected System.Data.DataRow FindByPrimaryKey(System.Object)(No summary available.)
    protected System.Data.DataRow FindMergeTarget(System.Data.DataRow,System.Data.DataKey,System.Data.Index)(No summary available.)
    protected System.String FormatSortString(System.Data.IndexField[][])(No summary available.)
    protected void FreeRecord(System.Int32&&)(No summary available.)
    protected System.Data.Index GetIndex(System.Data.IndexField[][])(No summary available.)
    protected System.Data.Index GetIndex(System.String,System.Data.DataViewRowState,System.Data.IFilter)(No summary available.)
    protected System.Data.Index GetIndex(System.Data.IndexField[][],System.Data.DataViewRowState,System.Data.IFilter)(No summary available.)
    protected System.ComponentModel.PropertyDescriptorCollection GetPropertyDescriptorCollection(System.Attribute[][])(No summary available.)
    protected void GetRowAndColumnErrors(System.Int32,System.Collections.Hashtable,System.Collections.Hashtable)(No summary available.)
    protected System.Type GetRowType()(No summary available.)
    protected System.Xml.Schema.XmlSchema GetSchema()(No summary available.)
    protected System.Int32 GetSpecialHashCode(System.String)(No summary available.)
    protected System.Int32 IndexOf(System.String,System.String)(No summary available.)
    protected System.Int32[][] InsertRecordToIndexes(System.Data.DataRow,System.Data.DataRowVersion)(No summary available.)
    protected void InsertRow(System.Data.DataRow,System.Int32,System.Int32)(No summary available.)
    protected void InsertRow(System.Data.DataRow,System.Int32,System.Int32,System.Boolean)(No summary available.)
    protected void InsertRow(System.Data.DataRow,System.Int32)(No summary available.)
    protected System.Boolean IsNamespaceInherited()(No summary available.)
    protected System.Boolean IsSuffix(System.String,System.String)(No summary available.)
    protected System.Object MemberwiseClone()(No summary available.)
    protected System.Data.DataRow MergeRow(System.Data.DataRow,System.Data.DataRow,System.Boolean,System.Data.Index)(No summary available.)
    protected System.Boolean MoveToElement(System.Xml.XmlReader,System.Int32)(No summary available.)
    protected System.Data.DataRow NewEmptyRow()(No summary available.)
    protected System.Int32 NewRecord()(No summary available.)
    protected System.Int32 NewRecord(System.Int32)(No summary available.)
    protected System.Int32 NewRecordFromArray(System.Object[][])(No summary available.)
    protected System.Data.DataRow NewRow(System.Int32)(No summary available.)
    protected System.Data.DataRow NewRowFromBuilder(System.Data.DataRowBuilder)(No summary available.)
    protected System.Int32 NewUninitializedRecord()(No summary available.)
    protected void OnPropertyChanging(System.ComponentModel.PropertyChangedEventArgs)(No summary available.)
    protected void OnRemoveColumn(System.Data.DataColumn)(No summary available.)
    protected void OnRemoveColumnInternal(System.Data.DataColumn)(No summary available.)
    protected void OnRowChanged(System.Data.DataRowChangeEventArgs)(No summary available.)
    protected void OnRowChanging(System.Data.DataRowChangeEventArgs)(No summary available.)
    protected void OnRowDeleted(System.Data.DataRowChangeEventArgs)(No summary available.)
    protected void OnRowDeleting(System.Data.DataRowChangeEventArgs)(No summary available.)
    protected void OnTableCleared(System.Data.DataTableClearEventArgs)(No summary available.)
    protected void OnTableClearing(System.Data.DataTableClearEventArgs)(No summary available.)
    protected void OnTableNewRow(System.Data.DataTableNewRowEventArgs)(No summary available.)
    protected System.Data.IndexField[][] ParseSortString(System.String)(No summary available.)
    protected void RaisePropertyChanging(System.String)(No summary available.)
    protected void ReadEndElement(System.Xml.XmlReader)(No summary available.)
    protected void ReadXDRSchema(System.Xml.XmlReader)(No summary available.)
    protected System.Data.XmlReadMode ReadXml(System.Xml.XmlReader,System.Boolean)(No summary available.)
    protected System.Data.XmlReadMode ReadXml(System.Xml.XmlReader,System.Data.XmlReadMode,System.Boolean)(No summary available.)
    protected void ReadXmlSchema(System.Xml.XmlReader,System.Boolean)(No summary available.)
    protected void ReadXmlSerializable(System.Xml.XmlReader)(No summary available.)
    protected void ReadXSDSchema(System.Xml.XmlReader,System.Boolean)(No summary available.)
    protected void RecordChanged(System.Int32)(No summary available.)
    protected void RecordChanged(System.Int32[][],System.Int32[][])(No summary available.)
    protected void RecordStateChanged(System.Int32,System.Data.DataViewRowState,System.Data.DataViewRowState)(No summary available.)
    protected void RecordStateChanged(System.Int32,System.Data.DataViewRowState,System.Data.DataViewRowState,System.Int32,System.Data.DataViewRowState,System.Data.DataViewRowState)(No summary available.)
    protected void RemoveDependentColumn(System.Data.DataColumn)(No summary available.)
    protected System.Int32[][] RemoveRecordFromIndexes(System.Data.DataRow,System.Data.DataRowVersion)(No summary available.)
    protected void RemoveRow(System.Data.DataRow,System.Boolean)(No summary available.)
    protected void ResetIndexes()(No summary available.)
    protected void ResetInternalIndexes(System.Data.DataColumn)(No summary available.)
    protected void RestoreIndexEvents(System.Boolean)(No summary available.)
    protected void RollbackRow(System.Data.DataRow)(No summary available.)
    protected void SerializeConstraints(System.Runtime.Serialization.SerializationInfo,System.Runtime.Serialization.StreamingContext,System.Int32,System.Boolean)(No summary available.)
    protected void SerializeExpressionColumns(System.Runtime.Serialization.SerializationInfo,System.Runtime.Serialization.StreamingContext,System.Int32)(No summary available.)
    protected void SerializeTableData(System.Runtime.Serialization.SerializationInfo,System.Runtime.Serialization.StreamingContext,System.Int32)(No summary available.)
    protected void SerializeTableSchema(System.Runtime.Serialization.SerializationInfo,System.Runtime.Serialization.StreamingContext,System.Boolean)(No summary available.)
    protected System.Boolean SetCaseSensitiveValue(System.Boolean,System.Boolean,System.Boolean)(No summary available.)
    protected void SetDataSet(System.Data.DataSet)(No summary available.)
    protected void SetKeyValues(System.Data.DataKey,System.Object[][],System.Int32)(No summary available.)
    protected System.Boolean SetLocaleValue(System.Globalization.CultureInfo,System.Boolean,System.Boolean)(No summary available.)
    protected void SetNewRecord(System.Data.DataRow,System.Int32,System.Data.DataRowAction,System.Boolean,System.Boolean)(No summary available.)
    protected void SetOldRecord(System.Data.DataRow,System.Int32)(No summary available.)
    protected void ShadowIndexCopy()(No summary available.)
    protected System.Boolean ShouldSerializeCaseSensitive()(No summary available.)
    protected System.Boolean ShouldSerializeLocale()(No summary available.)
    protected void SilentlySetValue(System.Data.DataRow,System.Data.DataColumn,System.Data.DataRowVersion,System.Object)(No summary available.)
    protected void SuspendIndexEvents()(No summary available.)
    protected void UpdatePropertyDescriptorCollectionCache()(No summary available.)
    protected System.Data.DataRow UpdatingAdd(System.Object[][])(No summary available.)
    protected System.Boolean UpdatingCurrent(System.Data.DataRow,System.Data.DataRowAction)(No summary available.)
     
    View private members on this type
    Ad
    BootFX
    Reliable and powerful .NET application framework.
    iOS, Android and Windows Phone Development Training and Consultancy
    Hosted by RackSRV Communications
     
    Multimobile Development: Building Applications for any Smartphone
    Copyright © AMX Software Ltd 2008-2010. Portions copyright © Matthew Baxter-Reynolds 2001-2010. All rights reserved.
    Contact Us - Terms of Use - Privacy Policy - 4.0.30129.1734