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);
}
