Question

'·' 附近有语法错误。 急求解决，在线等。

'·' 附近有语法错误。
说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.Data.SqlClient.SqlException: '·' 附近有语法错误。

源错误:

执行当前 Web 请求期间生成了未处理的异常。可以使用下面的异常堆栈跟踪信息确定有关异常原因和发生位置的信息。

堆栈跟踪:

[SqlException (0x80131904): '·' 附近有语法错误。]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +149
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1005
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +149
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand command, DataSourceOperation operation) +404
System.Web.UI.WebControls.SqlDataSourceView.ExecuteDelete(IDictionary keys, IDictionary oldValues) +720
System.Web.UI.DataSourceView.Delete(IDictionary keys, IDictionary oldValues, DataSourceViewOperationCallback callback) +75
System.Web.UI.WebControls.GridView.HandleDelete(GridViewRow row, Int32 rowIndex) +927
System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +1134
System.Web.UI.WebControls.GridView.RaisePostBackEvent(String eventArgument) +199
System.Web.UI.WebControls.GridView.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +177
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746
我用的是GridView中自带的编辑功能
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:address bookConnectionString7 %>"
DeleteCommand="DELETE FROM [Communication file] WHERE [部门·姓名] = @column1"
InsertCommand="INSERT INTO [Communication file] ([部门·姓名], [办公电话], [住宅电话], [手机], [短号]) VALUES (@column1, @办公电话, @住宅电话, @手机, @短号)"
SelectCommand="SELECT * FROM [Communication file]"
UpdateCommand="UPDATE [Communication file] SET [办公电话] = @办公电话, [住宅电话] = @住宅电话, [手机] = @手机, [短号] = @短号 WHERE [部门·姓名] = @column1">
<DeleteParameters>
<asp:Parameter Name="column1" Type="String" />
</DeleteParameters>
<UpdateParameters>

Answer 1

insertsql
=
"insert
into
用户(用户名，密码，提示问题，答案，性别，所在地，QQ号码，常用邮箱)
values('"
&
TextBox1.Text
&
"','"
&
TextBox2.Text
&
"','"
&
ComboBox1.Text
&
"','"
&
TextBox4.Text
&
"','"
&
ComboBox2.Text
&
"','"
&
ComboBox3.Text
&
"','"
&
TextBox3.Text
&
"','"
&
TextBox5.Text
&
"',)"
改为
insertsql
=
"insert
into
用户
(用户名,
密码,
提示问题,
答案,
性别,
所在地,
QQ号码,
常用邮箱)
values
('"
&
TextBox1.Text
&
"','"
&
TextBox2.Text
&
"','"
&
ComboBox1.Text
&
"','"
&
TextBox4.Text
&
"','"
&
ComboBox2.Text
&
"','"
&
ComboBox3.Text
&
"','"
&
TextBox3.Text
&
"','"
&
TextBox5.Text
&
"')"
所有全角逗号改为半角逗号，另外最后多了一个逗号

Answer 2

你这个错误是个SQL语句的错误，你要设置断点调试把这个查询语句查出来，然后在数据库中执行就知道这个语句错在哪里了

Answer 3

放源码

Answer 4

sql语句贴出来. 最好调试下,把出错的地方贴出来.

Answer 5

SQL 语句多了或者少了 '

Answer 6

你把你的SQL语句放到查询分析器里面执行试试就知道了。。