[SqlException (0x80131904): '*' 附近有语法错误。]

Question

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

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

源错误:

行 60: catch (Exception ex)
行 61: {
行 62: throw ex;
行 63: }
行 64: finally

源文件: f:\bookshop\App_Code\DataBaseHelper.cs 行: 62

堆栈跟踪:

[SqlException (0x80131904): '*' 附近有语法错误。]
DataBaseHelper.ExecuteNonQuery(String sql, SqlParameter[] param) in f:\bookshop\App_Code\DataBaseHelper.cs:62
DataBaseHelper.ExecuteNonQuery(String sql) in f:\bookshop\App_Code\DataBaseHelper.cs:34
Manger_OrderList.gvOrderList_RowDeleting(Object sender, GridViewDeleteEventArgs e) in f:\bookshop\Manager\OrderList.aspx.cs:78
System.Web.UI.WebControls.GridView.OnRowDeleting(GridViewDeleteEventArgs e) +133
System.Web.UI.WebControls.GridView.HandleDelete(GridViewRow row, Int32 rowIndex) +569
System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +869
System.Web.UI.WebControls.GridView.RaisePostBackEvent(String eventArgument) +207
System.Web.UI.WebControls.GridView.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +175
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint
protected void gvOrderList_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string orderID = gvOrderList.DataKeys[e.RowIndex].Value.ToString();
string sql =

Answer 1

异常详细信息: System.Data.SqlClient.SqlException: '*' 附近有语法错误。，检查sql语句那段代码，
你给的问题补充看不到sql语句代码，你调试一下那块即可。

Answer 2

sql语句出现错误了 你用到了*是不是在*附近有错

Answer 3

这样很难看出问题,直接贴原代码看看会好点,估计是你更新数据的格式不正确.