报错误ORA-00911 invalid character 报错误在红色的地方 在线等哦

Question

       public static DataSet GetAllIdentifyHistory(string startTime,string endTime)
       {
           try
           {
               OracleConnection conn = CreateConnection();
               string sql1 = "select IDENTIFYHISTORY.ENROLID,IDENTIFYHISTORY.SIMILARITY, BASEENROLMENT.BNAME,BIOMETRICSTYPE.BIOMETRICSNAME,IDENTIFYHISTORY.IDENTIFYDATE ,IDENTIFYHISTORY.REMARK from IDENTIFYHISTORY,BASEENROLMENT,BIOMETRICSTYPE";
               string sql2 = " where IDENTIFYHISTORY.ENROLID=BASEENROLMENT.ENROLID and IDENTIFYHISTORY.BIOMETRICSID=BIOMETRICSTYPE.BIOMETRICSID and IDENTIFYHISTORY.IDENTIFYDATE>to_date('" + startTime + "','yyyy-mm-dd hh24:mi;ss')  and IDENTIFYHISTORY.IDENTIFYDATE<to_date('" + endTime + "','yyyy-mm-dd hh24:mi;ss') ;";
               string sql = sql1 + sql2;
               DataSet ds = new DataSet();
               OracleDataAdapter oda = new OracleDataAdapter(sql, conn);
               
               oda.Fill(ds,"123");               
               oda.Dispose();
               conn.Close();
               return ds;
           }
           catch (Exception OE)
           {
               PDAException.SaveException(OE);
               return null;
           }
                }
sql语句是正确的， 没有问题 请教

Answer 1

呵呵 这就好 解决了 恭喜恭喜