public static int RunNonQueryTest(MainForm frm, PFSQLServerCE40 db) { int numRowsAffected = -1; string query = string.Empty; _msg.Length = 0; _msg.Append("Running RunNonQueryTest ..."); Program._messageLog.WriteLine(_msg.ToString()); try { query = frm.txtQuery.Text; db.OpenConnection(); numRowsAffected = db.RunNonQuery(query); db.CloseConnection(); _msg.Length = 0; _msg.Append("Query: "); _msg.Append(frm.txtQuery.Text); _msg.Append("\r\n"); _msg.Append("Num rows affected: "); _msg.Append(numRowsAffected.ToString("#,##0")); Program._messageLog.WriteLine(_msg.ToString()); } 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("...RunNonQueryTest Finished."); Program._messageLog.WriteLine(_msg.ToString()); } return(numRowsAffected); }