public DataTable SelectDataStyleAllFinance(string FinanceStyle, string FinanceData) { strOleDb = new StringBuilder(); strOleDb.Append("select Department as 来文机关或部门,Sort as 类别,Amount as 份数,FinanceData as 收到日期,OrderNum as 顺序号,FileNum as 来文号,ArchivesNum as 归入案卷号,FileTitle as 拟办 from Finance"); strOleDb.Append("where FileStyle='" + FinanceStyle + "'and FinanceData='#" + FinanceData + "#'"); strOleDb.Append("order by FinanceID desc");
return DB.Fill(strOleDb.ToString()); }
是WHERE 中错误么？如何改，急求from Finace 后 或 where FileStyle前
加一个空格. like FinanceData='#" ?
加了 没用 跟空格没关系啊
哪里错了？ up strOleDb.Append("where FileStyle='" + FinanceStyle + "'a
