c# - 诱捕错误并继续运输

我编写了一个C#监视程序来检查数据库中的值。它运行4个单独的检查，然后输出结果(Winform)。

一切运行良好，然后上周第一次检查遇到问题，整个程序停止了。

因此，我的问题是，如何在4个支票中的任何一个中捕获任何错误并继续运输？

我可以尝试捕获还是停止程序执行？

代码样例

        bool bTestDate;
        object LastDataDate;

      //--  Check A - Table 1
        OdbcConnection DbConnection = new OdbcConnection("DSN=EDATA");
        try
        {
            DbConnection.Open();
        }
        catch (OdbcException ex)
        {
            Console.WriteLine("connection to the DSN '" + connStr + "' failed.");
            Console.WriteLine(ex.Message);
            return;
        }

        OdbcCommand DbCommand = DbConnection.CreateCommand();
        DbCommand.CommandText = "SELECT NAME, UNAME, DATIME_ENDED FROM XPF WHERE NAME='XXXX'";

        OdbcDataReader DbReader = DbCommand.ExecuteReader();
        int fCount = DbReader.FieldCount;

        string myBatch;
        string myUser;
        string myDate;

        while (DbReader.Read())
        {
            Console.Write(":");

            myBatch = DbReader.GetString(0);
            myUser = DbReader.GetString(1);
            myDate = DbReader.GetString(2);
            myDate = myDate.Remove(myDate.Length - 10);

            for (int i = 0; i < fCount; i++)
            {
                String col = DbReader.GetString(i);
                Console.Write(col + ":");
            }
            tbxxx.Text = string.Format("{0:dd/M/yy   H:mm:ss}", myDate);

            bool TestDate;
            TestDate = CheckDate(Convert.ToDateTime(myDate));
            CheckVerif(TestDate, lblVerifixxx);
        }

      //--  Check B - Table 2
        string cnStr = setConnectionString();
        string mySQL = "Select Max(TO_DATE(TIME_ID, 'DD/MM/YYYY')) FROM table";
        OracleConnection cn = new OracleConnection(cnStr);
        cn.Open();

        OracleCommand cmd = new OracleCommand(mySQL, cn);
        LastDataDate = cmd.ExecuteScalar();
        cmd.Dispose();

        tbLastDate.Text = string.Format("{0:dd MMM yy}", LastDataDate);
        bTestDate = CheckDate(Convert.ToDateTime(LastDataDate));
        CheckVerif(bTestDate, lblVerif);

      //--  Check C - Table 3
        mySQL = "Select Max(xxx_DATE) from AGENT";
        OracleCommand cmd2 = new OracleCommand(mySQL, cn);
        LastDataDate = cmd2.ExecuteScalar();
        cmd2.Dispose();

        tbxxx2.Text = string.Format("{0:dd MMM yy}", LastDataDate);
        bool TestDatex;
        TestDatex = CheckDate(Convert.ToDateTime(LastDataDate));
        CheckVerif(TestDatex, lblVerif2);

最佳答案

您可以将try catch块与预期的异常一起使用，并可以将其与一般的异常一起使用，只是可以确定您捕获了所有异常并且不会引发异常，因此不会暂停程序。

try
{
    string s = null;
    ProcessString(s);
}
// Most specific:
catch (ArgumentNullException e)
{
    Console.WriteLine("{0} First exception caught.", e);
}
// Least specific:
catch (Exception e)
{
    Console.WriteLine("{0} Second exception caught.", e);
}

检查https://msdn.microsoft.com/en-us/library/0yd65esw.aspx

关于c# - 诱捕错误并继续运输，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/35013246/