错误提示说关键字FROM附近出现错误 请问是怎么回事
string strSql = "SELECT tb_ResearcherInfo.EId, tb_ResearcherInfo.PId, tb_ResearcherInfo.EName, " +"tb_ResearcherInfo.ESex, tb_ResearcherInfo.EBirthday, tb_ResearcherInfo.ECard, " +
"tb_ResearcherInfo.ETel, tb_ResearcherInfo.EAddress, tb_ResearcherInfo.EField, " +
"FROM tb_ResearcherInfo"; --------------------编程问答-------------------- 多了个逗号吧
正确应该是 select * from Table --------------------编程问答-------------------- FROM 前面多了个 , 号 ,请仔细查看 --------------------编程问答--------------------
string strSql = "SELECT tb_ResearcherInfo.EId, tb_ResearcherInfo.PId, tb_ResearcherInfo.EName, " +
"tb_ResearcherInfo.ESex, tb_ResearcherInfo.EBirthday, tb_ResearcherInfo.ECard, " +
"tb_ResearcherInfo.ETel, tb_ResearcherInfo.EAddress, tb_ResearcherInfo.EField, " +
"FROM tb_ResearcherInfo";
改成
--------------------编程问答-------------------- 靠近from 多了个逗号 --------------------编程问答--------------------
string strSql = "SELECT tb_ResearcherInfo.EId, tb_ResearcherInfo.PId, tb_ResearcherInfo.EName, " +
"tb_ResearcherInfo.ESex, tb_ResearcherInfo.EBirthday, tb_ResearcherInfo.ECard, " +
"tb_ResearcherInfo.ETel, tb_ResearcherInfo.EAddress, tb_ResearcherInfo.EField " +
"FROM tb_ResearcherInfo";
FROM 前面的逗号。。。。。。 --------------------编程问答-------------------- 逗号是个好东西 --------------------编程问答-------------------- "SELECT tb_ResearcherInfo.EId, tb_ResearcherInfo.PId, tb_ResearcherInfo.EName, " +
"tb_ResearcherInfo.ESex, tb_ResearcherInfo.EBirthday, tb_ResearcherInfo.ECard, " +
"tb_ResearcherInfo.ETel, tb_ResearcherInfo.EAddress, tb_ResearcherInfo.EField, " +
"FROM tb_ResearcherInfo";
红色部分已经标出 --------------------编程问答-------------------- "SELECT tb_ResearcherInfo.EId, tb_ResearcherInfo.PId, tb_ResearcherInfo.EName, " +
"tb_ResearcherInfo.ESex, tb_ResearcherInfo.EBirthday, tb_ResearcherInfo.ECard, " +
"tb_ResearcherInfo.ETel, tb_ResearcherInfo.EAddress, tb_ResearcherInfo.EField " +
"FROM tb_ResearcherInfo";
换成这样就OK了
--------------------编程问答-------------------- string strSql = "SELECT tb_ResearcherInfo.EId, tb_ResearcherInfo.PId, tb_ResearcherInfo.EName, " +
"tb_ResearcherInfo.ESex, tb_ResearcherInfo.EBirthday, tb_ResearcherInfo.ECard, " +
"tb_ResearcherInfo.ETel, tb_ResearcherInfo.EAddress, tb_ResearcherInfo.EField, " +
"FROM tb_ResearcherInfo";
去掉红色部分 --------------------编程问答--------------------
正解
补充:.NET技术 , ASP.NET