public static void RunResultsetTest(MainForm frm, PFSQLServerCE35 db) { SqlCeResultSet res = null; string query = string.Empty; _msg.Length = 0; _msg.Append("Running RunResultsetTest ..."); Program._messageLog.WriteLine(_msg.ToString()); try { query = frm.txtQuery.Text; db.OpenConnection(); res = db.RunQueryResultset(query); if (res.HasRows) { db.returnResult += new PFSQLServerCE35.ResultDelegate(OutputResults); //sqlce.returnResultAsString += new PFSQLServerCE.ResultAsStringDelegate(OutputResultsAsString); db.ProcessResultSet(res); res.Close(); res = db.RunQueryResultset(query); db.returnResultAsString += new PFSQLServerCE35.ResultAsStringDelegate(OutputExtractFormattedData); db.ExtractDelimitedDataFromResultSet(res, "~", "\r\n", true); res.Close(); res = db.RunQueryResultset(query); db.SaveResultSetToXmlFile(res, @"c:\temp\TestCe35Res.xml"); res.Close(); res = db.RunQueryResultset(query); db.SaveResultSetWithSchemaToXmlFile(res, @"c:\temp\TestCe35ResPlus.xml"); res.Close(); res = db.RunQueryResultset(query); db.SaveResultSetToXmlSchemaFile(res, @"c:\temp\TestCe35Res.xsd"); res.Close(); res = db.RunQueryResultset(query); PFDataProcessor dataProcessor = new PFDataProcessor(); XmlDocument xmlDoc = dataProcessor.CopyDataTableToXmlDocument(PFSQLServerCE35.ConvertResultSetToDataTable(res, "ResultTable")); Program._messageLog.WriteLine("\r\n" + xmlDoc.OuterXml + "\r\n"); res.Close(); } db.CloseConnection(); } catch (System.Exception ex) { _msg.Length = 0; _msg.Append(AppGlobals.AppMessages.FormatErrorMessage(ex)); Program._messageLog.WriteLine(_msg.ToString()); AppMessages.DisplayErrorMessage(_msg.ToString(), _saveErrorMessagesToAppLog); } finally { _msg.Length = 0; _msg.Append("...RunResultsetTest Finished."); Program._messageLog.WriteLine(_msg.ToString()); } }