DataTableReader.cs source code in C# .NET

Source code for the .NET framework in C#

                        

Code:

/ 4.0 / 4.0 / DEVDIV_TFS / Dev10 / Releases / RTMRel / ndp / fx / src / Data / System / Data / DataTableReader.cs / 1305376 / DataTableReader.cs

                            //------------------------------------------------------------------------------ 
// 
//     Copyright (c) Microsoft Corporation.  All rights reserved.
// 
// [....] 
// [....]
// [....] 
//----------------------------------------------------------------------------- 

namespace System.Data { 
    using System;
    using System.Data.Common;
    using System.Data.SqlTypes;
    using System.Collections; 
    using System.ComponentModel;
 
    public sealed class DataTableReader : DbDataReader  { 

        private readonly DataTable[] tables = null; 
        private bool isOpen = true;
        private DataTable schemaTable = null;

        private int tableCounter = -1; 
        private int rowCounter = -1;
        private DataTable currentDataTable = null; 
        private DataRow currentDataRow = null; 

        private bool hasRows= true; 
        private bool reachEORows = false;
        private bool currentRowRemoved = false;
        private bool schemaIsChanged = false;
        private bool started = false; 
        private bool readerIsInvalid = false;
        private DataTableReaderListener listener = null; 
        private bool tableCleared = false; 

       public  DataTableReader(DataTable dataTable) { 
            if (dataTable == null)
                throw ExceptionBuilder.ArgumentNull("DataTable");
            tables = new DataTable[1] {dataTable};
 
            init();
//            schemaTable = GetSchemaTableFromDataTable(currentDataTable); 
        } 

        public  DataTableReader(DataTable [] dataTables) { 
           if (dataTables == null)
                throw ExceptionBuilder.ArgumentNull("DataTable");

           if (dataTables.Length == 0) 
               throw ExceptionBuilder.DataTableReaderArgumentIsEmpty();
 
 
           tables = new DataTable[dataTables.Length];
           for (int i = 0; i < dataTables.Length ; i++) { 
               if (dataTables[i] == null)
                   throw ExceptionBuilder.ArgumentNull("DataTable");
               tables[i] = dataTables[i];
           } 

           init(); 
//           schemaTable = GetSchemaTableFromDataTable(currentDataTable); 
        }
 
        private bool ReaderIsInvalid {
            get {
                return readerIsInvalid;
            } 
            set {
                if (readerIsInvalid == value) 
                    return; 
                readerIsInvalid = value;
                if (readerIsInvalid && listener != null) { 
                    listener.CleanUp();
                }
            }
        } 

        private bool IsSchemaChanged { 
            get { 
                return schemaIsChanged;
            } 
            set {
                if (!value || schemaIsChanged == value) //once it is set to false; should not change unless in init() or NextResult()
                    return;
                schemaIsChanged  = value; 
                if (listener != null) {
                    listener.CleanUp(); 
                } 
            }
        } 

        internal DataTable CurrentDataTable {
            get {
                return currentDataTable; 
            }
        } 
 
        private void init() {
            tableCounter = 0; 
            reachEORows = false;
            schemaIsChanged = false;
            currentDataTable = tables[tableCounter];
            hasRows = (currentDataTable.Rows.Count > 0); 
            ReaderIsInvalid = false;
 
// we need to listen to current tables event so create a listener, it will listen to events and call us back. 
            listener = new DataTableReaderListener(this);
        } 


        override public void Close() {
            if (!isOpen) 
                return;
// no need to listen to events after close 
            if (listener != null) 
                listener.CleanUp();
 
            listener = null;
            schemaTable = null;

            isOpen = false; 
        }
 
        override public DataTable GetSchemaTable(){ 
            ValidateOpen("GetSchemaTable");
            ValidateReader(); 

// each time, we just get schema table of current table for once, no need to recreate each time, if schema is changed, reader is already
// is invalid
            if (schemaTable == null) 
                schemaTable = GetSchemaTableFromDataTable(currentDataTable);
 
            return schemaTable; 
        }
 
        override public bool  NextResult() {
// next result set; reset everything
            ValidateOpen("NextResult");
 
            if ((tableCounter ==  tables.Length -1))
                return false; 
 
           currentDataTable = tables[++tableCounter];
 
           if (listener != null)
                listener.UpdataTable(currentDataTable); // it will unsubscribe from preveous tables events and subscribe to new table's events

           schemaTable = null; 
           rowCounter = -1;
           currentRowRemoved = false; 
           reachEORows = false; 
           schemaIsChanged = false;
           started = false; 
           ReaderIsInvalid = false;
           tableCleared = false;

            hasRows = (currentDataTable.Rows.Count > 0); 

           return true; 
        } 

        override public bool Read() { 

/*            else if (tableCleared) {
                return false;
                throw  ExceptionBuilder.EmptyDataTableReader(currentDataTable.TableName); 
            }
  */ 
            if (!started) { 
                started = true;
            } 
            /*else {
                ValidateRow(rowCounter);
            }*/
 
            ValidateOpen("Read");
 
            ValidateReader(); 

 
            if(reachEORows) {
                return false;
            }
 
            if (rowCounter >=  currentDataTable.Rows.Count  -1 ) {
                reachEORows = true; 
                if (listener != null) 
                    listener.CleanUp();
               return false; 
            }

            rowCounter ++;
            ValidateRow(rowCounter); 
            currentDataRow = currentDataTable.Rows[rowCounter];
 
            while (currentDataRow.RowState == DataRowState.Deleted) { 
                rowCounter++;
                if (rowCounter ==  currentDataTable.Rows.Count) { 
                    reachEORows = true;
                    if (listener != null)
                        listener.CleanUp();
                    return false; 
                }
                ValidateRow(rowCounter); 
                currentDataRow = currentDataTable.Rows[rowCounter]; 
            }
            if (currentRowRemoved) 
                currentRowRemoved = false;

            return true;
        } 

        override public int Depth { 
           get { 
               ValidateOpen("Depth");
               ValidateReader(); 
               return 0;
           }
        }
 
        override public bool IsClosed {
            get { 
                return (!isOpen); 
            }
        } 

        override public int RecordsAffected {
            get {
                ValidateReader(); 
                return 0;
            } 
        } 

        override public bool HasRows { 
            get {
                ValidateOpen("HasRows");
                ValidateReader();
                return hasRows; 
            }
        } 
 
        override public object this[int ordinal] {
            get { 
                ValidateOpen("Item");
                ValidateReader();
                if ((currentDataRow == null) || (currentDataRow.RowState == DataRowState.Deleted)) {
                    ReaderIsInvalid = true; 
                    throw  ExceptionBuilder.InvalidDataTableReader(currentDataTable.TableName);
                } 
                try { 
                    return currentDataRow[ordinal];
                } 
                catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                    ExceptionBuilder.TraceExceptionWithoutRethrow(e);
                    throw ExceptionBuilder.ArgumentOutOfRange("ordinal");
                } 
            }
        } 
 
        override public object this[string name] {
            get { 
                ValidateOpen("Item");
                ValidateReader();
                if ((currentDataRow == null) || (currentDataRow.RowState == DataRowState.Deleted)) {
                    ReaderIsInvalid = true; 
                    throw  ExceptionBuilder.InvalidDataTableReader(currentDataTable.TableName);
                } 
                return currentDataRow[name]; 
            }
        } 

        override public Int32 FieldCount {
            get {
                ValidateOpen("FieldCount"); 
                ValidateReader();
                return currentDataTable.Columns.Count; 
            } 
        }
 
        override public Type GetProviderSpecificFieldType(int ordinal) {
            ValidateOpen("GetProviderSpecificFieldType");
            ValidateReader();
            return GetFieldType(ordinal); 
        }
 
        override public Object GetProviderSpecificValue(int ordinal) { 
            ValidateOpen("GetProviderSpecificValue");
            ValidateReader(); 
            return GetValue(ordinal);
        }

        override  public int GetProviderSpecificValues(object[] values) { 
            ValidateOpen("GetProviderSpecificValues");
            ValidateReader(); 
            return GetValues(values); 
        }
 
        override public  bool GetBoolean (int ordinal) {
            ValidateState("GetBoolean");
            ValidateReader();
            try { 
                return (bool) currentDataRow[ordinal];
            } 
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection 
                ExceptionBuilder.TraceExceptionWithoutRethrow(e);
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal"); 
            }
        }

        override public  byte GetByte (int ordinal) { 
            ValidateState("GetByte");
            ValidateReader(); 
            try { 
                return (byte) currentDataRow[ordinal];
            } 
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e);
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal");
            } 
        }
 
       override public long GetBytes(int ordinal, long dataIndex, byte[] buffer, int bufferIndex, int length) { 
            ValidateState("GetBytes");
            ValidateReader(); 
            byte[] tempBuffer;
            try {
                tempBuffer = (byte[]) currentDataRow[ordinal];
            } 
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e); 
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal"); 
            }
            if (buffer == null) { 
                return tempBuffer.Length;
            }
            int srcIndex = (int) dataIndex;
            int byteCount = Math.Min(tempBuffer.Length - srcIndex, length); 
            if (srcIndex < 0) {
                throw ADP.InvalidSourceBufferIndex(tempBuffer.Length, srcIndex, "dataIndex"); 
            } 
            else if ((bufferIndex < 0) || (bufferIndex > 0 && bufferIndex >= buffer.Length)) {
                throw ADP.InvalidDestinationBufferIndex(buffer.Length, bufferIndex, "bufferIndex"); 
            }

            if (0 < byteCount) {
                Array.Copy(tempBuffer, dataIndex, buffer, bufferIndex, byteCount); 
            }
            else if (length < 0) { 
                throw ADP.InvalidDataLength(length); 
            }
            else { 
                byteCount = 0;
            }
            return byteCount;
 
        }
 
        override public  char GetChar (int ordinal) { 
            ValidateState("GetChar");
            ValidateReader(); 
            try {
                return (char) currentDataRow[ordinal];
            }
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection 
                ExceptionBuilder.TraceExceptionWithoutRethrow(e);
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal"); 
            } 
        }
 
       override public long GetChars(int ordinal, long dataIndex, char[] buffer, int bufferIndex, int length) {
            ValidateState("GetChars");
            ValidateReader();
            char[] tempBuffer; 
            try {
                tempBuffer = (char[]) currentDataRow[ordinal]; 
            } 
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e); 
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal");
            }

            if (buffer == null) { 
                return tempBuffer.Length;
            } 
 
            int srcIndex = (int) dataIndex;
            int charCount = Math.Min(tempBuffer.Length - srcIndex, length); 
            if (srcIndex < 0) {
                throw ADP.InvalidSourceBufferIndex(tempBuffer.Length, srcIndex, "dataIndex");
            }
            else if ((bufferIndex < 0) || (bufferIndex > 0 && bufferIndex >= buffer.Length)) { 
                throw ADP.InvalidDestinationBufferIndex(buffer.Length, bufferIndex, "bufferIndex");
            } 
 
            if (0 < charCount) {
                Array.Copy(tempBuffer, dataIndex, buffer, bufferIndex, charCount); 
            }
            else if (length < 0) {
                throw ADP.InvalidDataLength(length);
            } 
            else {
                charCount = 0; 
            } 
            return charCount;
        } 

        override public  String GetDataTypeName (int ordinal) {
            ValidateOpen("GetDataTypeName");
            ValidateReader(); 
            return ((Type)GetFieldType(ordinal)).Name;
        } 
 
        override public  DateTime GetDateTime (int ordinal) {
            ValidateState("GetDateTime"); 
            ValidateReader();
            try {
                return (DateTime) currentDataRow[ordinal];
            } 
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e); 
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal"); 
            }
        } 

        override public  Decimal GetDecimal (int ordinal) {
            ValidateState("GetDecimal");
            ValidateReader(); 
            try {
                return (Decimal) currentDataRow[ordinal]; 
            } 
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e); 
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal");
            }
        }
 
        override public  Double GetDouble (int ordinal) {
            ValidateState("GetDouble"); 
            ValidateReader(); 
            try {
                return (double) currentDataRow[ordinal]; 
            }
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e);
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal"); 
            }
        } 
 
        override public  Type GetFieldType (int ordinal) {
            ValidateOpen("GetFieldType"); 
            ValidateReader();
            try {
                return (currentDataTable.Columns[ordinal].DataType);
            } 
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e); 
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal"); 
            }
        } 

        override public  Single GetFloat (int ordinal) {
            ValidateState("GetFloat");
            ValidateReader(); 
            try {
                return (Single) currentDataRow[ordinal]; 
            } 
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e); 
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal");
            }
        }
 
        override public  Guid GetGuid (int ordinal) {
            ValidateState("GetGuid"); 
            ValidateReader(); 
            try {
                return (Guid) currentDataRow[ordinal]; 
            }
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e);
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal"); 
            }
        } 
 
        override public  Int16 GetInt16 (int ordinal) {
            ValidateState("GetInt16"); 
            ValidateReader();
            try {
                return (Int16) currentDataRow[ordinal];
            } 
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e); 
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal"); 
            }
        } 

        override public Int32 GetInt32 (int ordinal) {
            ValidateState("GetInt32");
            ValidateReader(); 
            try {
                return (Int32) currentDataRow[ordinal]; 
            } 
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e); 
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal");
            }
        }
 
        override public  Int64 GetInt64 (int ordinal) {
            ValidateState("GetInt64"); 
            ValidateReader(); 
            try {
                return (Int64) currentDataRow[ordinal]; 
            }
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e);
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal"); 
            }
        } 
 
        override public  String GetName (int ordinal) {
            ValidateOpen("GetName"); 
            ValidateReader();
            try {
                return (currentDataTable.Columns[ordinal].ColumnName);
            } 
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e); 
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal"); 
            }
        } 

        override public  Int32 GetOrdinal (string name) {
            ValidateOpen("GetOrdinal");
            ValidateReader(); 
            DataColumn dc = currentDataTable.Columns[name];
 
            if (dc != null) { 
                return dc.Ordinal;// WebData 113248
            } 
            else{
                throw ExceptionBuilder.ColumnNotInTheTable(name, currentDataTable.TableName);
            }
        } 

        override public  string GetString (int ordinal) { 
            ValidateState("GetString"); 
            ValidateReader();
            try { 
                return (string) currentDataRow[ordinal];
            }
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e); 
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal");
            } 
        } 

 
        override public  object GetValue (int ordinal) {
            ValidateState("GetValue");
            ValidateReader();
            try { 
                return currentDataRow[ordinal];
            } 
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection 
                ExceptionBuilder.TraceExceptionWithoutRethrow(e);
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal"); 
            }
        }

        override public  Int32 GetValues (object[] values) { 
            ValidateState("GetValues");
            ValidateReader(); 
 
            if (values ==null)
                throw ExceptionBuilder.ArgumentNull("values"); 

            Array.Copy(currentDataRow.ItemArray, values,  currentDataRow.ItemArray.Length > values.Length ? values.Length : currentDataRow.ItemArray.Length);
            return (currentDataRow.ItemArray.Length > values.Length ? values.Length : currentDataRow.ItemArray.Length);
        } 
        override public bool IsDBNull (int ordinal) {
            ValidateState("IsDBNull"); 
            ValidateReader(); 
            try {
                return (currentDataRow.IsNull(ordinal)); 
            }
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e);
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal"); 
            }
        } 
 
// IEnumerable
        override public IEnumerator GetEnumerator() { 
            ValidateOpen("GetEnumerator");
            return new DbEnumerator((IDataReader)this);
        }
 
        static internal DataTable GetSchemaTableFromDataTable(DataTable table) {
            if (table == null) { 
                throw ExceptionBuilder.ArgumentNull("DataTable"); 
            }
 
            DataTable tempSchemaTable = new DataTable("SchemaTable");
            tempSchemaTable.Locale = System.Globalization.CultureInfo.InvariantCulture;

            DataColumn ColumnName          = new DataColumn(SchemaTableColumn.ColumnName,          typeof(System.String)); 
            DataColumn ColumnOrdinal       = new DataColumn(SchemaTableColumn.ColumnOrdinal,       typeof(System.Int32));
            DataColumn ColumnSize          = new DataColumn(SchemaTableColumn.ColumnSize,          typeof(System.Int32)); 
            DataColumn NumericPrecision    = new DataColumn(SchemaTableColumn.NumericPrecision,    typeof(System.Int16)); 
            DataColumn NumericScale        = new DataColumn(SchemaTableColumn.NumericScale,        typeof(System.Int16));
            DataColumn DataType            = new DataColumn(SchemaTableColumn.DataType,            typeof(System.Type)); 
            DataColumn ProviderType        = new DataColumn(SchemaTableColumn.ProviderType,        typeof(System.Int32));
            DataColumn IsLong              = new DataColumn(SchemaTableColumn.IsLong,              typeof(System.Boolean));
            DataColumn AllowDBNull         = new DataColumn(SchemaTableColumn.AllowDBNull,         typeof(System.Boolean));
            DataColumn IsReadOnly          = new DataColumn(SchemaTableOptionalColumn.IsReadOnly,   typeof(System.Boolean)); 
            DataColumn IsRowVersion        = new DataColumn(SchemaTableOptionalColumn.IsRowVersion, typeof(System.Boolean));
            DataColumn IsUnique            = new DataColumn(SchemaTableColumn.IsUnique,            typeof(System.Boolean)); 
            DataColumn IsKeyColumn         = new DataColumn(SchemaTableColumn.IsKey,               typeof(System.Boolean)); 
            DataColumn IsAutoIncrement     = new DataColumn(SchemaTableOptionalColumn.IsAutoIncrement,     typeof(System.Boolean));
            DataColumn BaseSchemaName      = new DataColumn(SchemaTableColumn.BaseSchemaName,      typeof(System.String)); 
            DataColumn BaseCatalogName     = new DataColumn(SchemaTableOptionalColumn.BaseCatalogName,     typeof(System.String));
            DataColumn BaseTableName       = new DataColumn(SchemaTableColumn.BaseTableName,       typeof(System.String));
            DataColumn BaseColumnName      = new DataColumn(SchemaTableColumn.BaseColumnName,      typeof(System.String));
            DataColumn AutoIncrementSeed   = new DataColumn(SchemaTableOptionalColumn.AutoIncrementSeed,   typeof(System.Int64)); 
            DataColumn AutoIncrementStep   = new DataColumn(SchemaTableOptionalColumn.AutoIncrementStep,   typeof(System.Int64));
            DataColumn DefaultValue        = new DataColumn(SchemaTableOptionalColumn.DefaultValue,        typeof(System.Object)); 
            DataColumn Expression          = new DataColumn(SchemaTableOptionalColumn.Expression,          typeof(System.String)); 
            DataColumn ColumnMapping       = new DataColumn(SchemaTableOptionalColumn.ColumnMapping,       typeof(System.Data.MappingType));
            DataColumn BaseTableNamespace  = new DataColumn(SchemaTableOptionalColumn.BaseTableNamespace,  typeof(System.String)); 
            DataColumn BaseColumnNamespace = new DataColumn(SchemaTableOptionalColumn.BaseColumnNamespace, typeof(System.String));

           ColumnSize.DefaultValue = -1;
 
           if (table.DataSet != null)
               BaseCatalogName.DefaultValue =  table.DataSet.DataSetName; 
 
           BaseTableName.DefaultValue = table.TableName;
           BaseTableNamespace.DefaultValue = table.Namespace; 
           IsRowVersion.DefaultValue = false;
           IsLong.DefaultValue = false;
           IsReadOnly.DefaultValue = false;
           IsKeyColumn.DefaultValue = false; 
           IsAutoIncrement.DefaultValue = false;
           AutoIncrementSeed.DefaultValue = 0; 
           AutoIncrementStep.DefaultValue = 1; 

 
           tempSchemaTable.Columns.Add(ColumnName);
           tempSchemaTable.Columns.Add(ColumnOrdinal);
           tempSchemaTable.Columns.Add(ColumnSize);
           tempSchemaTable.Columns.Add(NumericPrecision); 
           tempSchemaTable.Columns.Add(NumericScale);
           tempSchemaTable.Columns.Add(DataType); 
           tempSchemaTable.Columns.Add(ProviderType); 
           tempSchemaTable.Columns.Add(IsLong);
           tempSchemaTable.Columns.Add(AllowDBNull); 
           tempSchemaTable.Columns.Add(IsReadOnly);
           tempSchemaTable.Columns.Add(IsRowVersion);
           tempSchemaTable.Columns.Add(IsUnique);
           tempSchemaTable.Columns.Add(IsKeyColumn); 
           tempSchemaTable.Columns.Add(IsAutoIncrement);
           tempSchemaTable.Columns.Add(BaseCatalogName); 
           tempSchemaTable.Columns.Add(BaseSchemaName); 
           // specific to datatablereader
           tempSchemaTable.Columns.Add(BaseTableName); 
           tempSchemaTable.Columns.Add(BaseColumnName);
           tempSchemaTable.Columns.Add(AutoIncrementSeed);
           tempSchemaTable.Columns.Add(AutoIncrementStep);
           tempSchemaTable.Columns.Add(DefaultValue); 
           tempSchemaTable.Columns.Add(Expression);
           tempSchemaTable.Columns.Add(ColumnMapping); 
           tempSchemaTable.Columns.Add(BaseTableNamespace); 
           tempSchemaTable.Columns.Add(BaseColumnNamespace);
 
           foreach (DataColumn dc in table.Columns) {
               DataRow dr = tempSchemaTable.NewRow();

               dr[ColumnName] = dc.ColumnName; 
               dr[ColumnOrdinal] = dc.Ordinal;
               dr[DataType] = dc.DataType; 
 
               if (dc.DataType == typeof(string)) {
                   dr[ColumnSize] = dc.MaxLength; 
               }

               dr[AllowDBNull] = dc.AllowDBNull;
               dr[IsReadOnly] = dc.ReadOnly; 
               dr[IsUnique] = dc.Unique;
 
               if (dc.AutoIncrement) { 
                   dr[IsAutoIncrement] = true;
                   dr[AutoIncrementSeed] = dc.AutoIncrementSeed; 
                   dr[AutoIncrementStep] = dc.AutoIncrementStep;
               }

               if (dc.DefaultValue != DBNull.Value) 
                   dr[DefaultValue] =  dc.DefaultValue;
 
               if (dc.Expression.Length  != 0)  { 
                   bool hasExternalDependency = false;
                   DataColumn[] dependency = dc.DataExpression.GetDependency(); 
                   for (int j = 0; j < dependency.Length; j++) {
                       if (dependency[j].Table != table) {
                           hasExternalDependency = true;
                           break; 
                       }
                   } 
                   if (!hasExternalDependency) 
                       dr[Expression] =  dc.Expression;
               } 

               dr[ColumnMapping] =  dc.ColumnMapping;
               dr[BaseColumnName] = dc.ColumnName;
               dr[BaseColumnNamespace] = dc.Namespace; 

               tempSchemaTable.Rows.Add(dr); 
           } 

           foreach(DataColumn key in table.PrimaryKey) { 
               tempSchemaTable.Rows[key.Ordinal][IsKeyColumn] = true;
           }

 
               tempSchemaTable.AcceptChanges();
 
           return tempSchemaTable; 
        }
 
        private void ValidateOpen(string caller) {
           if (!isOpen)
               throw ADP.DataReaderClosed(caller);
       } 

       private void ValidateReader() { 
           if (ReaderIsInvalid) 
               throw  ExceptionBuilder.InvalidDataTableReader(currentDataTable.TableName);
 
           if (IsSchemaChanged) {
               throw  ExceptionBuilder.DataTableReaderSchemaIsInvalid(currentDataTable.TableName); // may be we can use better error message!
           }
 
       }
 
       private void ValidateState(string caller) { 
           ValidateOpen(caller);
           if (tableCleared) { 
               throw  ExceptionBuilder.EmptyDataTableReader(currentDataTable.TableName);
           }
           // see if without any event raising, if our curent row has some changes!if so reader is invalid.
           if ((currentDataRow == null) || (currentDataTable == null) ) {//|| (currentDataRow != currentDataTable.Rows[rowCounter])) do we need thios check! 
               ReaderIsInvalid = true;
               throw  ExceptionBuilder.InvalidDataTableReader(currentDataTable.TableName); 
           } 
           //See if without any event raing, if our rows are deleted, or removed! Reader is not invalid, user should be able to read and reach goo row WebData98325
           if ((currentDataRow.RowState == DataRowState.Deleted) || (currentDataRow.RowState == DataRowState.Detached) ||currentRowRemoved) 
                throw  ExceptionBuilder.InvalidCurrentRowInDataTableReader();
           // user may have called clear (which removes the rows without raing event) or deleted part of rows without raising event!if so reader is invalid.
           if (0 > rowCounter ||currentDataTable.Rows.Count <= rowCounter) {
                ReaderIsInvalid = true; 
               throw  ExceptionBuilder.InvalidDataTableReader(currentDataTable.TableName);
           } 
           else { 

           } 
       }

       private void ValidateRow(Int32 rowPosition) {
           if (ReaderIsInvalid) 
               throw  ExceptionBuilder.InvalidDataTableReader(currentDataTable.TableName);
 
           if (0 > rowPosition ||currentDataTable.Rows.Count <= rowPosition) { 
               ReaderIsInvalid = true;
               throw  ExceptionBuilder.InvalidDataTableReader(currentDataTable.TableName); 
           }
       }

// Event Call backs from DataTableReaderListener,  will invoke these methods 
       internal void SchemaChanged() {
           IsSchemaChanged = true; 
       } 
       internal void DataTableCleared() {
           if (!started) 
               return;

            rowCounter = -1;
            if (!reachEORows) 
                currentRowRemoved = true;
       } 
 
       internal void DataChanged(DataRowChangeEventArgs args ) {
           if ((!started) ||(rowCounter == -1 && !tableCleared)) 
               return;
/*           if (rowCounter == -1 && tableCleared && args.Action == DataRowAction.Add) {
               tableCleared = false;
               return; 
           }
*/ 
           switch (args.Action) { 
               case DataRowAction.Add:
                   ValidateRow(rowCounter + 1); 
/*                   if (tableCleared) {
                       tableCleared = false;
                       rowCounter++;
                       currentDataRow = currentDataTable.Rows[rowCounter]; 
                       currentRowRemoved = false;
                   } 
                   else 
*/
                    if (currentDataRow == currentDataTable.Rows[rowCounter + 1]) { // check if we moved one position up 
                       rowCounter++;  // if so, refresh the datarow and fix the counter
                   }
                   break;
               case DataRowAction.Delete: // delete 
               case DataRowAction.Rollback:// rejectchanges
               case DataRowAction.Commit: // acceptchanges 
                   if ( args.Row.RowState == DataRowState.Detached ) { 
                       if (args.Row != currentDataRow) {
                           if (rowCounter == 0) // if I am at first row and no previous row exist,NOOP 
                               break;
                           ValidateRow(rowCounter -1);
                           if (currentDataRow == currentDataTable.Rows[rowCounter - 1]) { // one of previous rows is detached, collection size is changed!
                               rowCounter--; 
                           }
                       } 
                       else { // we are proccessing current datarow 
                           currentRowRemoved = true;
                           if (rowCounter > 0) {  // go back one row, no matter what the state is 
                               rowCounter--;
                               currentDataRow = currentDataTable.Rows[rowCounter];
                           }
                           else {  // we are on 0th row, so reset data to initial state! 
                               rowCounter = -1;
                               currentDataRow = null; 
                           } 
                       }
                   } 
                   break;
               default:
                   break;
           } 
       }
 
    } 
}

// File provided for Reference Use Only by Microsoft Corporation (c) 2007.
//------------------------------------------------------------------------------ 
// 
//     Copyright (c) Microsoft Corporation.  All rights reserved.
// 
// [....] 
// [....]
// [....] 
//----------------------------------------------------------------------------- 

namespace System.Data { 
    using System;
    using System.Data.Common;
    using System.Data.SqlTypes;
    using System.Collections; 
    using System.ComponentModel;
 
    public sealed class DataTableReader : DbDataReader  { 

        private readonly DataTable[] tables = null; 
        private bool isOpen = true;
        private DataTable schemaTable = null;

        private int tableCounter = -1; 
        private int rowCounter = -1;
        private DataTable currentDataTable = null; 
        private DataRow currentDataRow = null; 

        private bool hasRows= true; 
        private bool reachEORows = false;
        private bool currentRowRemoved = false;
        private bool schemaIsChanged = false;
        private bool started = false; 
        private bool readerIsInvalid = false;
        private DataTableReaderListener listener = null; 
        private bool tableCleared = false; 

       public  DataTableReader(DataTable dataTable) { 
            if (dataTable == null)
                throw ExceptionBuilder.ArgumentNull("DataTable");
            tables = new DataTable[1] {dataTable};
 
            init();
//            schemaTable = GetSchemaTableFromDataTable(currentDataTable); 
        } 

        public  DataTableReader(DataTable [] dataTables) { 
           if (dataTables == null)
                throw ExceptionBuilder.ArgumentNull("DataTable");

           if (dataTables.Length == 0) 
               throw ExceptionBuilder.DataTableReaderArgumentIsEmpty();
 
 
           tables = new DataTable[dataTables.Length];
           for (int i = 0; i < dataTables.Length ; i++) { 
               if (dataTables[i] == null)
                   throw ExceptionBuilder.ArgumentNull("DataTable");
               tables[i] = dataTables[i];
           } 

           init(); 
//           schemaTable = GetSchemaTableFromDataTable(currentDataTable); 
        }
 
        private bool ReaderIsInvalid {
            get {
                return readerIsInvalid;
            } 
            set {
                if (readerIsInvalid == value) 
                    return; 
                readerIsInvalid = value;
                if (readerIsInvalid && listener != null) { 
                    listener.CleanUp();
                }
            }
        } 

        private bool IsSchemaChanged { 
            get { 
                return schemaIsChanged;
            } 
            set {
                if (!value || schemaIsChanged == value) //once it is set to false; should not change unless in init() or NextResult()
                    return;
                schemaIsChanged  = value; 
                if (listener != null) {
                    listener.CleanUp(); 
                } 
            }
        } 

        internal DataTable CurrentDataTable {
            get {
                return currentDataTable; 
            }
        } 
 
        private void init() {
            tableCounter = 0; 
            reachEORows = false;
            schemaIsChanged = false;
            currentDataTable = tables[tableCounter];
            hasRows = (currentDataTable.Rows.Count > 0); 
            ReaderIsInvalid = false;
 
// we need to listen to current tables event so create a listener, it will listen to events and call us back. 
            listener = new DataTableReaderListener(this);
        } 


        override public void Close() {
            if (!isOpen) 
                return;
// no need to listen to events after close 
            if (listener != null) 
                listener.CleanUp();
 
            listener = null;
            schemaTable = null;

            isOpen = false; 
        }
 
        override public DataTable GetSchemaTable(){ 
            ValidateOpen("GetSchemaTable");
            ValidateReader(); 

// each time, we just get schema table of current table for once, no need to recreate each time, if schema is changed, reader is already
// is invalid
            if (schemaTable == null) 
                schemaTable = GetSchemaTableFromDataTable(currentDataTable);
 
            return schemaTable; 
        }
 
        override public bool  NextResult() {
// next result set; reset everything
            ValidateOpen("NextResult");
 
            if ((tableCounter ==  tables.Length -1))
                return false; 
 
           currentDataTable = tables[++tableCounter];
 
           if (listener != null)
                listener.UpdataTable(currentDataTable); // it will unsubscribe from preveous tables events and subscribe to new table's events

           schemaTable = null; 
           rowCounter = -1;
           currentRowRemoved = false; 
           reachEORows = false; 
           schemaIsChanged = false;
           started = false; 
           ReaderIsInvalid = false;
           tableCleared = false;

            hasRows = (currentDataTable.Rows.Count > 0); 

           return true; 
        } 

        override public bool Read() { 

/*            else if (tableCleared) {
                return false;
                throw  ExceptionBuilder.EmptyDataTableReader(currentDataTable.TableName); 
            }
  */ 
            if (!started) { 
                started = true;
            } 
            /*else {
                ValidateRow(rowCounter);
            }*/
 
            ValidateOpen("Read");
 
            ValidateReader(); 

 
            if(reachEORows) {
                return false;
            }
 
            if (rowCounter >=  currentDataTable.Rows.Count  -1 ) {
                reachEORows = true; 
                if (listener != null) 
                    listener.CleanUp();
               return false; 
            }

            rowCounter ++;
            ValidateRow(rowCounter); 
            currentDataRow = currentDataTable.Rows[rowCounter];
 
            while (currentDataRow.RowState == DataRowState.Deleted) { 
                rowCounter++;
                if (rowCounter ==  currentDataTable.Rows.Count) { 
                    reachEORows = true;
                    if (listener != null)
                        listener.CleanUp();
                    return false; 
                }
                ValidateRow(rowCounter); 
                currentDataRow = currentDataTable.Rows[rowCounter]; 
            }
            if (currentRowRemoved) 
                currentRowRemoved = false;

            return true;
        } 

        override public int Depth { 
           get { 
               ValidateOpen("Depth");
               ValidateReader(); 
               return 0;
           }
        }
 
        override public bool IsClosed {
            get { 
                return (!isOpen); 
            }
        } 

        override public int RecordsAffected {
            get {
                ValidateReader(); 
                return 0;
            } 
        } 

        override public bool HasRows { 
            get {
                ValidateOpen("HasRows");
                ValidateReader();
                return hasRows; 
            }
        } 
 
        override public object this[int ordinal] {
            get { 
                ValidateOpen("Item");
                ValidateReader();
                if ((currentDataRow == null) || (currentDataRow.RowState == DataRowState.Deleted)) {
                    ReaderIsInvalid = true; 
                    throw  ExceptionBuilder.InvalidDataTableReader(currentDataTable.TableName);
                } 
                try { 
                    return currentDataRow[ordinal];
                } 
                catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                    ExceptionBuilder.TraceExceptionWithoutRethrow(e);
                    throw ExceptionBuilder.ArgumentOutOfRange("ordinal");
                } 
            }
        } 
 
        override public object this[string name] {
            get { 
                ValidateOpen("Item");
                ValidateReader();
                if ((currentDataRow == null) || (currentDataRow.RowState == DataRowState.Deleted)) {
                    ReaderIsInvalid = true; 
                    throw  ExceptionBuilder.InvalidDataTableReader(currentDataTable.TableName);
                } 
                return currentDataRow[name]; 
            }
        } 

        override public Int32 FieldCount {
            get {
                ValidateOpen("FieldCount"); 
                ValidateReader();
                return currentDataTable.Columns.Count; 
            } 
        }
 
        override public Type GetProviderSpecificFieldType(int ordinal) {
            ValidateOpen("GetProviderSpecificFieldType");
            ValidateReader();
            return GetFieldType(ordinal); 
        }
 
        override public Object GetProviderSpecificValue(int ordinal) { 
            ValidateOpen("GetProviderSpecificValue");
            ValidateReader(); 
            return GetValue(ordinal);
        }

        override  public int GetProviderSpecificValues(object[] values) { 
            ValidateOpen("GetProviderSpecificValues");
            ValidateReader(); 
            return GetValues(values); 
        }
 
        override public  bool GetBoolean (int ordinal) {
            ValidateState("GetBoolean");
            ValidateReader();
            try { 
                return (bool) currentDataRow[ordinal];
            } 
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection 
                ExceptionBuilder.TraceExceptionWithoutRethrow(e);
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal"); 
            }
        }

        override public  byte GetByte (int ordinal) { 
            ValidateState("GetByte");
            ValidateReader(); 
            try { 
                return (byte) currentDataRow[ordinal];
            } 
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e);
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal");
            } 
        }
 
       override public long GetBytes(int ordinal, long dataIndex, byte[] buffer, int bufferIndex, int length) { 
            ValidateState("GetBytes");
            ValidateReader(); 
            byte[] tempBuffer;
            try {
                tempBuffer = (byte[]) currentDataRow[ordinal];
            } 
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e); 
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal"); 
            }
            if (buffer == null) { 
                return tempBuffer.Length;
            }
            int srcIndex = (int) dataIndex;
            int byteCount = Math.Min(tempBuffer.Length - srcIndex, length); 
            if (srcIndex < 0) {
                throw ADP.InvalidSourceBufferIndex(tempBuffer.Length, srcIndex, "dataIndex"); 
            } 
            else if ((bufferIndex < 0) || (bufferIndex > 0 && bufferIndex >= buffer.Length)) {
                throw ADP.InvalidDestinationBufferIndex(buffer.Length, bufferIndex, "bufferIndex"); 
            }

            if (0 < byteCount) {
                Array.Copy(tempBuffer, dataIndex, buffer, bufferIndex, byteCount); 
            }
            else if (length < 0) { 
                throw ADP.InvalidDataLength(length); 
            }
            else { 
                byteCount = 0;
            }
            return byteCount;
 
        }
 
        override public  char GetChar (int ordinal) { 
            ValidateState("GetChar");
            ValidateReader(); 
            try {
                return (char) currentDataRow[ordinal];
            }
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection 
                ExceptionBuilder.TraceExceptionWithoutRethrow(e);
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal"); 
            } 
        }
 
       override public long GetChars(int ordinal, long dataIndex, char[] buffer, int bufferIndex, int length) {
            ValidateState("GetChars");
            ValidateReader();
            char[] tempBuffer; 
            try {
                tempBuffer = (char[]) currentDataRow[ordinal]; 
            } 
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e); 
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal");
            }

            if (buffer == null) { 
                return tempBuffer.Length;
            } 
 
            int srcIndex = (int) dataIndex;
            int charCount = Math.Min(tempBuffer.Length - srcIndex, length); 
            if (srcIndex < 0) {
                throw ADP.InvalidSourceBufferIndex(tempBuffer.Length, srcIndex, "dataIndex");
            }
            else if ((bufferIndex < 0) || (bufferIndex > 0 && bufferIndex >= buffer.Length)) { 
                throw ADP.InvalidDestinationBufferIndex(buffer.Length, bufferIndex, "bufferIndex");
            } 
 
            if (0 < charCount) {
                Array.Copy(tempBuffer, dataIndex, buffer, bufferIndex, charCount); 
            }
            else if (length < 0) {
                throw ADP.InvalidDataLength(length);
            } 
            else {
                charCount = 0; 
            } 
            return charCount;
        } 

        override public  String GetDataTypeName (int ordinal) {
            ValidateOpen("GetDataTypeName");
            ValidateReader(); 
            return ((Type)GetFieldType(ordinal)).Name;
        } 
 
        override public  DateTime GetDateTime (int ordinal) {
            ValidateState("GetDateTime"); 
            ValidateReader();
            try {
                return (DateTime) currentDataRow[ordinal];
            } 
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e); 
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal"); 
            }
        } 

        override public  Decimal GetDecimal (int ordinal) {
            ValidateState("GetDecimal");
            ValidateReader(); 
            try {
                return (Decimal) currentDataRow[ordinal]; 
            } 
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e); 
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal");
            }
        }
 
        override public  Double GetDouble (int ordinal) {
            ValidateState("GetDouble"); 
            ValidateReader(); 
            try {
                return (double) currentDataRow[ordinal]; 
            }
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e);
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal"); 
            }
        } 
 
        override public  Type GetFieldType (int ordinal) {
            ValidateOpen("GetFieldType"); 
            ValidateReader();
            try {
                return (currentDataTable.Columns[ordinal].DataType);
            } 
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e); 
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal"); 
            }
        } 

        override public  Single GetFloat (int ordinal) {
            ValidateState("GetFloat");
            ValidateReader(); 
            try {
                return (Single) currentDataRow[ordinal]; 
            } 
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e); 
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal");
            }
        }
 
        override public  Guid GetGuid (int ordinal) {
            ValidateState("GetGuid"); 
            ValidateReader(); 
            try {
                return (Guid) currentDataRow[ordinal]; 
            }
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e);
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal"); 
            }
        } 
 
        override public  Int16 GetInt16 (int ordinal) {
            ValidateState("GetInt16"); 
            ValidateReader();
            try {
                return (Int16) currentDataRow[ordinal];
            } 
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e); 
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal"); 
            }
        } 

        override public Int32 GetInt32 (int ordinal) {
            ValidateState("GetInt32");
            ValidateReader(); 
            try {
                return (Int32) currentDataRow[ordinal]; 
            } 
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e); 
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal");
            }
        }
 
        override public  Int64 GetInt64 (int ordinal) {
            ValidateState("GetInt64"); 
            ValidateReader(); 
            try {
                return (Int64) currentDataRow[ordinal]; 
            }
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e);
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal"); 
            }
        } 
 
        override public  String GetName (int ordinal) {
            ValidateOpen("GetName"); 
            ValidateReader();
            try {
                return (currentDataTable.Columns[ordinal].ColumnName);
            } 
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e); 
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal"); 
            }
        } 

        override public  Int32 GetOrdinal (string name) {
            ValidateOpen("GetOrdinal");
            ValidateReader(); 
            DataColumn dc = currentDataTable.Columns[name];
 
            if (dc != null) { 
                return dc.Ordinal;// WebData 113248
            } 
            else{
                throw ExceptionBuilder.ColumnNotInTheTable(name, currentDataTable.TableName);
            }
        } 

        override public  string GetString (int ordinal) { 
            ValidateState("GetString"); 
            ValidateReader();
            try { 
                return (string) currentDataRow[ordinal];
            }
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e); 
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal");
            } 
        } 

 
        override public  object GetValue (int ordinal) {
            ValidateState("GetValue");
            ValidateReader();
            try { 
                return currentDataRow[ordinal];
            } 
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection 
                ExceptionBuilder.TraceExceptionWithoutRethrow(e);
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal"); 
            }
        }

        override public  Int32 GetValues (object[] values) { 
            ValidateState("GetValues");
            ValidateReader(); 
 
            if (values ==null)
                throw ExceptionBuilder.ArgumentNull("values"); 

            Array.Copy(currentDataRow.ItemArray, values,  currentDataRow.ItemArray.Length > values.Length ? values.Length : currentDataRow.ItemArray.Length);
            return (currentDataRow.ItemArray.Length > values.Length ? values.Length : currentDataRow.ItemArray.Length);
        } 
        override public bool IsDBNull (int ordinal) {
            ValidateState("IsDBNull"); 
            ValidateReader(); 
            try {
                return (currentDataRow.IsNull(ordinal)); 
            }
            catch(IndexOutOfRangeException e) { // thrown by DataColumnCollection
                ExceptionBuilder.TraceExceptionWithoutRethrow(e);
                throw ExceptionBuilder.ArgumentOutOfRange("ordinal"); 
            }
        } 
 
// IEnumerable
        override public IEnumerator GetEnumerator() { 
            ValidateOpen("GetEnumerator");
            return new DbEnumerator((IDataReader)this);
        }
 
        static internal DataTable GetSchemaTableFromDataTable(DataTable table) {
            if (table == null) { 
                throw ExceptionBuilder.ArgumentNull("DataTable"); 
            }
 
            DataTable tempSchemaTable = new DataTable("SchemaTable");
            tempSchemaTable.Locale = System.Globalization.CultureInfo.InvariantCulture;

            DataColumn ColumnName          = new DataColumn(SchemaTableColumn.ColumnName,          typeof(System.String)); 
            DataColumn ColumnOrdinal       = new DataColumn(SchemaTableColumn.ColumnOrdinal,       typeof(System.Int32));
            DataColumn ColumnSize          = new DataColumn(SchemaTableColumn.ColumnSize,          typeof(System.Int32)); 
            DataColumn NumericPrecision    = new DataColumn(SchemaTableColumn.NumericPrecision,    typeof(System.Int16)); 
            DataColumn NumericScale        = new DataColumn(SchemaTableColumn.NumericScale,        typeof(System.Int16));
            DataColumn DataType            = new DataColumn(SchemaTableColumn.DataType,            typeof(System.Type)); 
            DataColumn ProviderType        = new DataColumn(SchemaTableColumn.ProviderType,        typeof(System.Int32));
            DataColumn IsLong              = new DataColumn(SchemaTableColumn.IsLong,              typeof(System.Boolean));
            DataColumn AllowDBNull         = new DataColumn(SchemaTableColumn.AllowDBNull,         typeof(System.Boolean));
            DataColumn IsReadOnly          = new DataColumn(SchemaTableOptionalColumn.IsReadOnly,   typeof(System.Boolean)); 
            DataColumn IsRowVersion        = new DataColumn(SchemaTableOptionalColumn.IsRowVersion, typeof(System.Boolean));
            DataColumn IsUnique            = new DataColumn(SchemaTableColumn.IsUnique,            typeof(System.Boolean)); 
            DataColumn IsKeyColumn         = new DataColumn(SchemaTableColumn.IsKey,               typeof(System.Boolean)); 
            DataColumn IsAutoIncrement     = new DataColumn(SchemaTableOptionalColumn.IsAutoIncrement,     typeof(System.Boolean));
            DataColumn BaseSchemaName      = new DataColumn(SchemaTableColumn.BaseSchemaName,      typeof(System.String)); 
            DataColumn BaseCatalogName     = new DataColumn(SchemaTableOptionalColumn.BaseCatalogName,     typeof(System.String));
            DataColumn BaseTableName       = new DataColumn(SchemaTableColumn.BaseTableName,       typeof(System.String));
            DataColumn BaseColumnName      = new DataColumn(SchemaTableColumn.BaseColumnName,      typeof(System.String));
            DataColumn AutoIncrementSeed   = new DataColumn(SchemaTableOptionalColumn.AutoIncrementSeed,   typeof(System.Int64)); 
            DataColumn AutoIncrementStep   = new DataColumn(SchemaTableOptionalColumn.AutoIncrementStep,   typeof(System.Int64));
            DataColumn DefaultValue        = new DataColumn(SchemaTableOptionalColumn.DefaultValue,        typeof(System.Object)); 
            DataColumn Expression          = new DataColumn(SchemaTableOptionalColumn.Expression,          typeof(System.String)); 
            DataColumn ColumnMapping       = new DataColumn(SchemaTableOptionalColumn.ColumnMapping,       typeof(System.Data.MappingType));
            DataColumn BaseTableNamespace  = new DataColumn(SchemaTableOptionalColumn.BaseTableNamespace,  typeof(System.String)); 
            DataColumn BaseColumnNamespace = new DataColumn(SchemaTableOptionalColumn.BaseColumnNamespace, typeof(System.String));

           ColumnSize.DefaultValue = -1;
 
           if (table.DataSet != null)
               BaseCatalogName.DefaultValue =  table.DataSet.DataSetName; 
 
           BaseTableName.DefaultValue = table.TableName;
           BaseTableNamespace.DefaultValue = table.Namespace; 
           IsRowVersion.DefaultValue = false;
           IsLong.DefaultValue = false;
           IsReadOnly.DefaultValue = false;
           IsKeyColumn.DefaultValue = false; 
           IsAutoIncrement.DefaultValue = false;
           AutoIncrementSeed.DefaultValue = 0; 
           AutoIncrementStep.DefaultValue = 1; 

 
           tempSchemaTable.Columns.Add(ColumnName);
           tempSchemaTable.Columns.Add(ColumnOrdinal);
           tempSchemaTable.Columns.Add(ColumnSize);
           tempSchemaTable.Columns.Add(NumericPrecision); 
           tempSchemaTable.Columns.Add(NumericScale);
           tempSchemaTable.Columns.Add(DataType); 
           tempSchemaTable.Columns.Add(ProviderType); 
           tempSchemaTable.Columns.Add(IsLong);
           tempSchemaTable.Columns.Add(AllowDBNull); 
           tempSchemaTable.Columns.Add(IsReadOnly);
           tempSchemaTable.Columns.Add(IsRowVersion);
           tempSchemaTable.Columns.Add(IsUnique);
           tempSchemaTable.Columns.Add(IsKeyColumn); 
           tempSchemaTable.Columns.Add(IsAutoIncrement);
           tempSchemaTable.Columns.Add(BaseCatalogName); 
           tempSchemaTable.Columns.Add(BaseSchemaName); 
           // specific to datatablereader
           tempSchemaTable.Columns.Add(BaseTableName); 
           tempSchemaTable.Columns.Add(BaseColumnName);
           tempSchemaTable.Columns.Add(AutoIncrementSeed);
           tempSchemaTable.Columns.Add(AutoIncrementStep);
           tempSchemaTable.Columns.Add(DefaultValue); 
           tempSchemaTable.Columns.Add(Expression);
           tempSchemaTable.Columns.Add(ColumnMapping); 
           tempSchemaTable.Columns.Add(BaseTableNamespace); 
           tempSchemaTable.Columns.Add(BaseColumnNamespace);
 
           foreach (DataColumn dc in table.Columns) {
               DataRow dr = tempSchemaTable.NewRow();

               dr[ColumnName] = dc.ColumnName; 
               dr[ColumnOrdinal] = dc.Ordinal;
               dr[DataType] = dc.DataType; 
 
               if (dc.DataType == typeof(string)) {
                   dr[ColumnSize] = dc.MaxLength; 
               }

               dr[AllowDBNull] = dc.AllowDBNull;
               dr[IsReadOnly] = dc.ReadOnly; 
               dr[IsUnique] = dc.Unique;
 
               if (dc.AutoIncrement) { 
                   dr[IsAutoIncrement] = true;
                   dr[AutoIncrementSeed] = dc.AutoIncrementSeed; 
                   dr[AutoIncrementStep] = dc.AutoIncrementStep;
               }

               if (dc.DefaultValue != DBNull.Value) 
                   dr[DefaultValue] =  dc.DefaultValue;
 
               if (dc.Expression.Length  != 0)  { 
                   bool hasExternalDependency = false;
                   DataColumn[] dependency = dc.DataExpression.GetDependency(); 
                   for (int j = 0; j < dependency.Length; j++) {
                       if (dependency[j].Table != table) {
                           hasExternalDependency = true;
                           break; 
                       }
                   } 
                   if (!hasExternalDependency) 
                       dr[Expression] =  dc.Expression;
               } 

               dr[ColumnMapping] =  dc.ColumnMapping;
               dr[BaseColumnName] = dc.ColumnName;
               dr[BaseColumnNamespace] = dc.Namespace; 

               tempSchemaTable.Rows.Add(dr); 
           } 

           foreach(DataColumn key in table.PrimaryKey) { 
               tempSchemaTable.Rows[key.Ordinal][IsKeyColumn] = true;
           }

 
               tempSchemaTable.AcceptChanges();
 
           return tempSchemaTable; 
        }
 
        private void ValidateOpen(string caller) {
           if (!isOpen)
               throw ADP.DataReaderClosed(caller);
       } 

       private void ValidateReader() { 
           if (ReaderIsInvalid) 
               throw  ExceptionBuilder.InvalidDataTableReader(currentDataTable.TableName);
 
           if (IsSchemaChanged) {
               throw  ExceptionBuilder.DataTableReaderSchemaIsInvalid(currentDataTable.TableName); // may be we can use better error message!
           }
 
       }
 
       private void ValidateState(string caller) { 
           ValidateOpen(caller);
           if (tableCleared) { 
               throw  ExceptionBuilder.EmptyDataTableReader(currentDataTable.TableName);
           }
           // see if without any event raising, if our curent row has some changes!if so reader is invalid.
           if ((currentDataRow == null) || (currentDataTable == null) ) {//|| (currentDataRow != currentDataTable.Rows[rowCounter])) do we need thios check! 
               ReaderIsInvalid = true;
               throw  ExceptionBuilder.InvalidDataTableReader(currentDataTable.TableName); 
           } 
           //See if without any event raing, if our rows are deleted, or removed! Reader is not invalid, user should be able to read and reach goo row WebData98325
           if ((currentDataRow.RowState == DataRowState.Deleted) || (currentDataRow.RowState == DataRowState.Detached) ||currentRowRemoved) 
                throw  ExceptionBuilder.InvalidCurrentRowInDataTableReader();
           // user may have called clear (which removes the rows without raing event) or deleted part of rows without raising event!if so reader is invalid.
           if (0 > rowCounter ||currentDataTable.Rows.Count <= rowCounter) {
                ReaderIsInvalid = true; 
               throw  ExceptionBuilder.InvalidDataTableReader(currentDataTable.TableName);
           } 
           else { 

           } 
       }

       private void ValidateRow(Int32 rowPosition) {
           if (ReaderIsInvalid) 
               throw  ExceptionBuilder.InvalidDataTableReader(currentDataTable.TableName);
 
           if (0 > rowPosition ||currentDataTable.Rows.Count <= rowPosition) { 
               ReaderIsInvalid = true;
               throw  ExceptionBuilder.InvalidDataTableReader(currentDataTable.TableName); 
           }
       }

// Event Call backs from DataTableReaderListener,  will invoke these methods 
       internal void SchemaChanged() {
           IsSchemaChanged = true; 
       } 
       internal void DataTableCleared() {
           if (!started) 
               return;

            rowCounter = -1;
            if (!reachEORows) 
                currentRowRemoved = true;
       } 
 
       internal void DataChanged(DataRowChangeEventArgs args ) {
           if ((!started) ||(rowCounter == -1 && !tableCleared)) 
               return;
/*           if (rowCounter == -1 && tableCleared && args.Action == DataRowAction.Add) {
               tableCleared = false;
               return; 
           }
*/ 
           switch (args.Action) { 
               case DataRowAction.Add:
                   ValidateRow(rowCounter + 1); 
/*                   if (tableCleared) {
                       tableCleared = false;
                       rowCounter++;
                       currentDataRow = currentDataTable.Rows[rowCounter]; 
                       currentRowRemoved = false;
                   } 
                   else 
*/
                    if (currentDataRow == currentDataTable.Rows[rowCounter + 1]) { // check if we moved one position up 
                       rowCounter++;  // if so, refresh the datarow and fix the counter
                   }
                   break;
               case DataRowAction.Delete: // delete 
               case DataRowAction.Rollback:// rejectchanges
               case DataRowAction.Commit: // acceptchanges 
                   if ( args.Row.RowState == DataRowState.Detached ) { 
                       if (args.Row != currentDataRow) {
                           if (rowCounter == 0) // if I am at first row and no previous row exist,NOOP 
                               break;
                           ValidateRow(rowCounter -1);
                           if (currentDataRow == currentDataTable.Rows[rowCounter - 1]) { // one of previous rows is detached, collection size is changed!
                               rowCounter--; 
                           }
                       } 
                       else { // we are proccessing current datarow 
                           currentRowRemoved = true;
                           if (rowCounter > 0) {  // go back one row, no matter what the state is 
                               rowCounter--;
                               currentDataRow = currentDataTable.Rows[rowCounter];
                           }
                           else {  // we are on 0th row, so reset data to initial state! 
                               rowCounter = -1;
                               currentDataRow = null; 
                           } 
                       }
                   } 
                   break;
               default:
                   break;
           } 
       }
 
    } 
}

// File provided for Reference Use Only by Microsoft Corporation (c) 2007.
                        

Link Menu

Network programming in C#, Network Programming in VB.NET, Network Programming in .NET
This book is available now!
Buy at Amazon US or
Buy at Amazon UK