}//end DataTableTest
public static void DataSetTest(MainForm frm)
{
PFMsOracle oracle = new PFMsOracle();
string connectionString = string.Empty;
Stopwatch sw = new Stopwatch();
try
{
oracle.DataSource = frm.txtDataSource.Text;
oracle.UseIntegratedSecurity = frm.chkUseIntegratedSecurity.Checked;
oracle.Username = frm.txtUserId.Text;
oracle.Password = frm.txtPassword.Text;
connectionString = oracle.ConnectionString;
_msg.Length = 0;
_msg.Append("Connection string is: \r\n");
_msg.Append(connectionString);
Program._messageLog.WriteLine(_msg.ToString());
if (frm.txtSQLQuery.Text.Length == 0)
{
throw new System.Exception("You must specify a SQL query to run.");
}
oracle.OpenConnection();
oracle.SQLQuery = frm.txtSQLQuery.Text;
if (frm.chkIsStoredProcedure.Checked)
{
oracle.CommandType = CommandType.StoredProcedure;
}
else
{
oracle.CommandType = CommandType.Text;
}
sw.Start();
DataSet ds1 = oracle.RunQueryDataSet();
oracle.returnResult += new PFMsOracle.ResultDelegate(OutputResults);
oracle.ProcessDataSet(ds1);
sw.Stop();
_msg.Length = 0;
_msg.Append("Process Dataset time: ");
_msg.Append(sw.FormattedElapsedTime);
Program._messageLog.WriteLine(_msg.ToString());
//Run data extract test
Program._messageLog.WriteLine("\r\nRunning data extract tests ...\r\n");
oracle.returnResultAsString += new PFMsOracle.ResultAsStringDelegate(OutputResultsToFile);
if (_textFile.FileIsOpen)
{
_textFile.CloseFile();
}
_textFile.OpenFile(@"c:\temp\DatasetDelimitedTestExtract.txt", PFFileOpenOperation.OpenFileForWrite);
sw.Start();
DataSet ds = oracle.RunQueryDataSet();
oracle.ExtractDelimitedDataFromDataSet(ds, "~", "\r\n", true);
sw.Stop();
_msg.Length = 0;
_msg.Append("Extract Delimiated Dataset time: ");
_msg.Append(sw.FormattedElapsedTime);
Program._messageLog.WriteLine(_msg.ToString());
if (_textFile.FileIsOpen)
{
_textFile.CloseFile();
}
_textFile.OpenFile(@"c:\temp\DatasetFixedLengthTestExtract.txt", PFFileOpenOperation.OpenFileForWrite);
ds = null;
sw.Start();
ds = oracle.RunQueryDataSet();
oracle.ExtractFixedLengthDataFromDataSet(ds, true, true, false);
sw.Stop();
_msg.Length = 0;
_msg.Append("Extract Fixed Length Dataset time: ");
_msg.Append(sw.FormattedElapsedTime);
Program._messageLog.WriteLine(_msg.ToString());
oracle.SaveDataSetToXmlSchemaFile(ds, @"c:\temp\Testds.xsd");
oracle.SaveDataSetToXmlFile(ds, @"c:\temp\Testds.xml");
oracle.SaveDataSetWithSchemaToXmlFile(ds, @"c:\temp\Testdsplus.xml");
DataSet ds2 = oracle.LoadXmlFileToDataSet(@"c:\temp\Testds.xml");;
int numRows = ds2.Tables[0].Rows.Count;
PFDataProcessor dataProcessor = new PFDataProcessor();
XmlDocument xmlDoc = dataProcessor.CopyDataSetToXmlDocument(ds);
Program._messageLog.WriteLine(xmlDoc.OuterXml);
if (_textFile.FileIsOpen)
{
_textFile.CloseFile();
}
ds = null;
}
catch (System.Exception ex)
{
frm.OutputErrorMessageToLog(ex);
}
finally
{
oracle.CloseConnection();
oracle = null;
}
}