如题!
如果我添加没有代码的文章,就可以成功添加,但如果添加带有代码的文章的时候,就会报错,如:'执行删除事件' 附近有语法错误。    '执行插入事件' 附近有语法错误。等等~`
如何解决呢?

解决方案 »

  1.   

    <asp:GridView ID="ListGroup" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="4" GridLines="Horizontal" ForeColor="Black" CssClass="GridView" Width="700px" OnRowDeleting="ListGroup_RowDeleting">
                                        <FooterStyle BackColor="#CCCC99" ForeColor="Black" />
                                        <Columns>
                                            <asp:TemplateField>
                                                <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Height="20px" />
                                                <ItemStyle Width="50px" HorizontalAlign="Center" VerticalAlign="Middle" />
                                                <ItemTemplate>
                                                    <asp:Image ID="Image3" runat="server" ImageUrl="~/manager/image/usergroup.gif" />
                                                </ItemTemplate>
                                            </asp:TemplateField>
                                            <asp:TemplateField HeaderText="序号">
                                                <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Height="20px" />
                                                <ItemStyle Width="50px" HorizontalAlign="Center" VerticalAlign="Middle" />
                                                <ItemTemplate> <%# Container.DataItemIndex+1 %> </ItemTemplate>
                                            </asp:TemplateField>
                                            <asp:BoundField DataField="UserGroupName" HeaderText="用户组名">
                                                <HeaderStyle HorizontalAlign="Left" VerticalAlign="Middle" Height="20px" />
                                                <ItemStyle Width="200px" HorizontalAlign="Left" VerticalAlign="Middle" />
                                            </asp:BoundField>
                                            <asp:BoundField DataField="UserGroupAbout" HeaderText="相关说明">
                                                <HeaderStyle HorizontalAlign="Left" VerticalAlign="Middle" Height="20px" />
                                                <ItemStyle Width="200px" HorizontalAlign="Left" VerticalAlign="Middle" />
                                            </asp:BoundField>
                                            <asp:TemplateField HeaderText="编辑">
                                                <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Height="20px" />
                                                <ItemStyle Width="100px" HorizontalAlign="Center" VerticalAlign="Middle" />
                                                <ItemTemplate>
                                                    <asp:ImageButton ID="ImageButton3" runat="server" ImageUrl="~/manager/image/editimage-noboarder.gif" CommandName="Delete" />
                                                </ItemTemplate>
                                            </asp:TemplateField>
                                            <asp:TemplateField HeaderText="删除">
                                                <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Height="20px" />
                                                <ItemStyle Width="100px" HorizontalAlign="Center" VerticalAlign="Middle" />
                                                <ItemTemplate>
                                                    <asp:ImageButton ID="ImageButton2" runat="server" ImageUrl="~/manager/image/delimage-noboarder.gif" CausesValidation="False" CommandName="Delete" />&nbsp;
                                                </ItemTemplate>
                                            </asp:TemplateField>
                                        </Columns>
                                        <SelectedRowStyle BackColor="#CC3333" Font-Bold="True" ForeColor="White" />
                                        <PagerStyle BackColor="White" ForeColor="Black" HorizontalAlign="Right" />
                                        <HeaderStyle BackColor="White" Font-Bold="False" ForeColor="CornflowerBlue" Height="20px" />
                                    </asp:GridView>后台我只是简单的加了句测试的语句:protected void ListGroup_RowDeleting(object sender, GridViewDeleteEventArgs e)
            {
                Response.Write("scriptalert('执行删除事件')/script");
            }如上面的代码,添加的时候报错:
     '执行删除事件' 附近有语法错误。
    说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。异常详细信息: System.Data.SqlClient.SqlException: '执行删除事件' 附近有语法错误。源错误:行 70:         SqlCommand mycmd = new SqlCommand(strsql, myconn);
    行 71: 
    行 72:         mycmd.ExecuteNonQuery();
    行 73:         Response.Redirect("ArticleManage.aspx");
    行 74: 
    源文件: d:\WEBPAGE\jusonloblog\Admin\AddNew.ascx.cs    行: 72堆栈跟踪:[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.RunExecuteNonQueryTds(String methodName, Boolean async) +196
       System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +269
       System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
       Admin_AddNew.btn_add_Click(Object sender, EventArgs e) in d:\WEBPAGE\jusonloblog\Admin\AddNew.ascx.cs:72
       System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
       System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
       System.Web.UI.WebControls.Button.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) +33
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746