求助：并非所有的变量都已绑定

[sola040515]

        public int SelectByCode( DateTime reg_date, String doctor_code)
        {
            string commandText = "SELECT COUNT(*) FROM SEHR_ORG_REGISTER_SECTION WHERE  REG_DATE = :REG_DATE AND DOCTOR_CODE = :DOCTOR_CODE";
            OracleConnection con = new OracleConnection(this.connectionString);
            OracleCommand cmd = new OracleCommand(commandText, con);
            con.Open();
            
            OracleParameter[] commandParameters = new OracleParameter[2];
            
            commandParameters[0] = new OracleParameter(":REG_DATE", reg_date);

            commandParameters[1] = new OracleParameter(":DOCTOR_CODE", doctor_code);
            OracleDataReader dr;
            DataSet ds = new DataSet();
            int strCount;
            try
            {
                dr = OracleHelper.ExecuteReader(this.connectionString, CommandType.Text, commandText, commandParameters);    
//                 int count = Convert.ToInt32(cmd.ExecuteScalar());
                OracleDataAdapter da = new OracleDataAdapter(commandText,con);
                da.Fill(ds, "SEHR_ORG_REGISTER_SECTION");
                strCount = Convert.ToInt32(ds.Tables["SEHR_ORG_REGISTER_SECTION"].Rows.Count); 
            }
            catch (Exception ex)
            {
                throw ex;
            }

[sola040515]

有没有人帮忙下，thank you

[porschev]

调式一把。。也看不到你OracleHelper里的。。还是参数没赋进去值。。。

或是没有添加到OracleCommand 中