当前位置:编程学习 > C#/ASP.NET >>

错误提示说关键字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"; 



改成



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 多了个逗号 --------------------编程问答--------------------
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"; 

去掉红色部分 --------------------编程问答--------------------
引用 1 楼 Return_false 的回复:
多了个逗号吧

正确应该是 select * from Table

正解
补充:.NET技术 ,  ASP.NET
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,