public DataSet getSearchResult(string m_DataField,string m_Key)
{
string m_SQL; m_SQL="SELECT ProjectID,ProjectName,Telephone,Facsimile,WebSite,ZipCode,Address,FinallyDate FROM Projects"; m_SQL+="WHERE("+m_DataField+" LIKE'%"+m_Key+"%')"; return getDataSet(m_SQL);
}
错误信息“/puteng”应用程序中的服务器错误。
--------------------------------------------------------------------------------FROM 子句语法错误。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.OleDb.OleDbException: FROM 子句语法错误。源错误:
行 76: DataSet ds=new DataSet();
行 77:
行 78: objda.Fill(ds,"dsTable");
行 79:
行 80: CDataBase.CloseConnect();
SELECT ProjectID,ProjectName,Telephone,Facsimile,WebSite,ZipCode,Address,FinallyDate FROM ProjectsWHERE ....
加空格了没有?
m_SQL+=" WHERE("+m_DataField+" LIKE'%"+m_Key+"%')";
m_SQL+=" WHERE("+m_DataField+" LIKE'%"+m_Key+"%')";
{
string m_SQL; m_SQL="SELECT ProjectID,ProjectName,Telephone,Facsimile,WebSite,ZipCode,Address,FinallyDate FROM Projects"; m_SQL+=" WHERE("+m_DataField+" LIKE'%"+m_Key+"%')";
//少了个空格
return getDataSet(m_SQL);
}
加空格变成这样,但错误依旧 public DataSet getSearchResult(string m_DataField,string m_Key)
{
string m_SQL; m_SQL="SELECT ProjectID,ProjectName,Telephone,Facsimile,WebSite,ZipCode,Address,FinallyDate FROM Projects"; m_SQL+=" WHRER("+m_DataField+" LIKE'%"+m_Key+"%')"; return getDataSet(m_SQL);
}
是 WHERE 呀,不是whrer