Server Error in '/' Application.

The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_WebFolder_WebFolder". The conflict occurred in database "ngservices", table "dbo.WebFolder", column 'ParentFolderID'.

The statement has been terminated.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.



Exception Details: System.Data.SqlClient.SqlException: The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_WebFolder_WebFolder". The conflict occurred in database "ngservices", table "dbo.WebFolder", column 'ParentFolderID'.

The statement has been terminated.



Source Error:



An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.



Stack Trace:



[SqlException (0x80131904): The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_WebFolder_WebFolder". The conflict occurred in database "ngservices", table "dbo.WebFolder", column 'ParentFolderID'.

The statement has been terminated.]

   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +928490

   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +801478

   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) +954

   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +253

   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +431

   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135

   ngslib.WEFolders.DeleteWebFolder(Int32 userId, Int32 folderId, Int32 machineId) in c:\Release\NewsGator Online\Online Build and Deploy Release\Sources\Branches\Release\Sourcegslib\WEFolders.cs:1783

   ngservices.WebFolderMaint.btnDelete_Click(Object sender, EventArgs e) in c:\Release\NewsGator Online\Online Build and Deploy Release\Sources\Branches\Release\Source\NewsGator.Webgs\subscriber\WebFolderMaint.aspx.cs:307

   System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) +90

   System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +76

   System.Web.UI.WebControls.LinkButton.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