/// <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"]]);
}
