Visual Studio C＃Oracle数据库排序日期

Question

我找不到以下代码出了问题。在其中所选的开始日期和结束日期以及按钮过渡到新表格的形式，DataGridView填充了数据库，有必要就选定的日期进行结论，但他不想发出ORA--00933.no" where"一切都很好。

void renewOtchet()
        {
            dgvOtchet.Rows.Clear();
            OracleCommand ocm = Oracle.DBConneciton.CreateCommand();
            ocm.CommandText = "select num, date_start, date_finish, " +
                "trim(name_video), price_video, " +
                "trim(fam_client), " +
                "trim(kind_zal) from video.allData" +
                "where date_start >=  ('"+ date1 + "', 'DD.MM.YYYY' )  and date_finish <= ('" + date2+ "', 'DD.MM.YYYY') ";
            string[] str = new string[7];
            OracleDataReader ord = ocm.ExecuteReader();
            while (ord.Read())
            {
                for (int i = 0; i < 7; i++)
                {
                    str[i] = ord[i].ToString();
                    if (i == 1 || i == 2)
                    {
                        str[i] = str[i].Remove(10);
                    }
                }
                dgvOtchet.Rows.Add(str);
            }
            ord.Dispose();
            ord.Close();
        }

Answer 1

您可以尝试。

"select num, date_start, date_finish, " +
     "trim(name_video), price_video, " + "trim(fam_client), " +
     "trim(kind_zal) from video.allData " +
     "where date_start >=  TO_DATE('"+ date1 + "', 'DD.MM.YYYY' ) 
      and date_finish <= TO_DATE('" + date2+ "','DD.MM.YYYY') ";
      string[] str = new string[7];