异常将 msg 作为："IndexOutOfRangeException was unhandle OrgerView" 在 C# 中，我该怎么办？

Question

我尝试在C#中连接MS Access Db，并希望查看全部。我的 Db 连接代码如下所示

String conStr= @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:UsersAdministratorDesktopSMSGateway2SMS.mdb;Persist Security Info=True; Jet OLEDB:Database Password=testing" ;
        OleDbConnection con;
        con = new OleDbConnection(conStr);
        string cmdString = "select * from Temp_Order";
        OleDbCommand command = new OleDbCommand(cmdString, con);
        try
        {
            con.Open();
            command.ExecuteNonQuery();
            OleDbDataReader reader = command.ExecuteReader();
            while (reader.Read())
            {
                richTextBox1.Text = "Student Name: " + reader["SenderNo"].ToString() + "n" +
                   "ID: " + reader["OrgerView"].ToString() + "n" +
                   "Program: " + reader["OrderTime"].ToString() + "n" +
                   "Address: " + reader["Flag"].ToString();
            }

        }
        catch (Exception readexcp)
        {
            throw readexcp;
        }
        finally
        {
            con.Close();
        }

Answer 1

首先删除此行command.ExecuteNonQuery();然后检查 SenderNo、OrgerView、OrderTime 和 Flag 是否为有效的列名。