ใช้ GetOrdinal กับ field ใน datareader แต่ค่าที่คืนกลับมา เป็น 1 ตลอด

protected string findQ(string val)
    {
       
        OleDbConnection oConn = new OleDbConnection("Provider=OraOLEDB.Oracle;User Id=;Password=;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.192.168.11)(PORT=1521))(CONNECT_DATA=(SID=books)))");

        string SqlStr = "";
        
        SqlStr = "Select BibId, COUNT(UserId) AS Total_Q FROM holdlist WHERE BibId=" + val + " GROUP BY BibId ";

        OleDbCommand oCmd = new OleDbCommand(SqlStr, oConn);

        oConn.Open();

        OleDbDataReader oReader = oCmd.ExecuteReader();

        if (oReader.HasRows)
        {
            while (oReader.Read())
            {
                ttq = Convert.ToString(oReader.GetOrdinal("Total_Q"));
                // ttq = oReader.GetInt32(1).ToString();               
                // ttq = "มีคิวจอง";
            }
        }
        else
        {
            ttq = "ไม่มีคิวจอง";
        }

        oReader.Dispose();
        oCmd.Dispose();
        oConn.Close();
        oConn.Dispose();

        return ttq;
    }