/// <summary> /// Retrieve metadata from the datasource. Calling this function will /// reset the main cell reader and the supercell reader. If the datasource has /// not been connected, an InvalidOperationException exception is raised. /// </summary> /// <param name="Metadata"> /// The cCellsMetadata object into which the metadata is written. If Metadata is /// null, an ArgumentNullException exception is raised. /// </param> public override void GetMetadata(cCellsMetadata Metadata) { if (mvarReader == null) { ThrowConnectionException(); } if (Metadata == null) { throw new ArgumentNullException("Metadata", "Metadata must not be null."); } // close the existing reader if (!mvarReader.IsClosed) { mvarReader.Close(); } // reset the connection ResetConnection(); // create the command required to extract the name OleDbCommand cmd = new OleDbCommand("Select * FROM [MetaData]", mvarConnection); mvarReader = cmd.ExecuteReader(); // read the value mvarReader.Read(); Metadata.CreatorName = Convert.ToString(mvarReader["CreatorName"]); Metadata.CreatorAffiliation = Convert.ToString(mvarReader["CreatorAffiliation"]); Metadata.CreatorContactInfo = Convert.ToString(mvarReader["CreatorContactInfo"]); Metadata.CreationDate = Convert.ToString(mvarReader["CreationDate"]); Metadata.Description = Convert.ToString(mvarReader["Description"]); // close this reader and open the reader on the main datasource mvarReader.Close(); this.Reset(); }
/// <summary> /// Retrieve metadata from the datasource. If the datasource has /// not been connected, an InvalidOperationException exception is raised. /// </summary> /// <param name="Metadata"> /// The cCellsMetadata object into which the metadata is written. If Metadata is /// null, an ArgumentNullException exception is raised. /// </param> public override void GetMetadata(cCellsMetadata Metadata) { if (!mvarConnected) { ThrowConnectionException(); } if (Metadata == null) { throw new ArgumentNullException("Metadata", "Metadata must not be null."); } // get the name table DataTable dt = mvarDataSet.Tables[TName["MetaData"]]; DataRow dr = dt.Rows[0]; // get the values Metadata.CreatorName = Convert.ToString(dr[FName["CreatorName"]]); Metadata.CreatorAffiliation = Convert.ToString(dr[FName["CreatorAffiliation"]]); Metadata.CreatorContactInfo = Convert.ToString(dr[FName["CreatorContactInfo"]]); Metadata.CreationDate = Convert.ToString(dr[FName["CreationDate"]]); Metadata.Description = Convert.ToString(dr[FName["Description"]]); }