提示：语法错误 (操作符丢失) 在查询表达式 'FileStyle=审核order by FinanceID desc' 中。

Question

public DataTable SelectStyleFinance(string FinanceStyle) 
        { 
            strOleDb = new StringBuilder(); 
            strOleDb.Append("select FinanceData as 收到日期,ArchivesNum as 归入案卷号,FileNum as 来文号,Department as 来文机关或部门,FileTitle as 拟办 FROM FINANCE"); 
            strOleDb.Append(" where FileStyle=" + FinanceStyle + ""); 
            strOleDb.Append("order by FinanceID desc");             return DB.Fill(strOleDb.ToString()); 
        } 提示：语法错误 (操作符丢失) 在查询表达式 'FileStyle=审核order by FinanceID desc' 中。 
什么错误 

Answer 1

'FileStyle=审核order by FinanceID desc'前面就个空格
strOleDb.Append(" order by FinanceID desc ");

Answer 2

strOleDb.Append(" where FileStyle=" + FinanceStyle + ""); 
            strOleDb.Append("  order by FinanceID desc"); 少了空格

Answer 3

'FileStyle='审核' order by FinanceID desc' 字符总得有引号吧

Answer 4

 /// <summary>
        /// 产品分页展示
        /// </summary>
        /// <param name="pagesize">每页显示多少条</param>
        /// <param name="pageindex">当前第几页</param>
        /// <returns></returns>
        public List<prod_news> ProductFenYe(int begin, int end)
        {
            try
            {
                string sqlStr = "select*from(select row_number()over(order by infotime desc)as RowIndex,*from prod_news)as a where RowIndex between "+begin+" and "+end;
                OleDbCommand cmd = new OleDbCommand(sqlStr, con); 
                OleDbParameter par1 = new OleDbParameter("@begin",OleDbType.Integer);
                OleDbParameter par2 = new OleDbParameter("@end",OleDbType.Integer);
                par1.Value = begin;
                par2.Value = end;
                cmd.Parameters.Add(par1);
                cmd.Parameters.Add(par2);
                List<prod_news> list = new List<prod_news>();
                con.Open();
                OleDbDataReader reader = cmd.ExecuteReader();
                while (reader.Read())
                {
                    prod_news prod_news = new prod_news();
                    prod_news.ID = Convert.ToInt32(reader["ID"]);
                    prod_news.title = reader["title"].ToString();
                    prod_news.content = reader["content"].ToString();
                    prod_news.ClassName = reader["ClassName"].ToString();
                    prod_news.img = reader["img"].ToString();
                    prod_news.okay2 = Convert.ToInt32(reader["okay2"]);
                    prod_news.okay = Convert.ToInt32(reader["okay"]);
                    prod_news.infotime = Convert.ToDateTime(reader["infotime"]);
                    prod_news.hits = Convert.ToInt32(reader["hits"]);
                    prod_news.ok = Convert.ToBoolean(reader["ok"]);
                    list.Add(prod_news);
                }
                return list;
            }
            catch (Exception ec)
            {                throw ec;
               
            }
连接的是ACCESS数据库  老提示语法错误 (操作符丢失) 在查询表达式 'row_number()over(order by infotime desc)' 中。  如果是SQL server就没事啊 谁帮解决  谢谢