troubleshooting Question
ASP.NET, How to handle Gridview foreign key constraints when deleting ??
asked on
Hi,
What is the beat way to intercept this SQLException, stop processing and display the error message when using the standard Gridview features. Currently the best I can see is by using something similar to:
I guess there must be a very standard way of achieving this.
I am using ASP.NET2 and SQL Server 2005.
Thanks in advance,
Sam
What is the beat way to intercept this SQLException, stop processing and display the error message when using the standard Gridview features. Currently the best I can see is by using something similar to:
Protected Sub gv_OnRowDeleting(ByVal sender As Object, ByVal e As GridViewDeleteEventArgs)
Try
Catch ex As System.Data.SqlClient.SqlException
some delete code here... Would expect a reference to the standard Gridview delete process somehow...
If ex.Number = 547 Then 'handle foreign key violation(547)
lblMsg.Text = "Record cannot be deleted as it is being used by other tables."
End If
End Try
End Sub
I guess there must be a very standard way of achieving this.
I am using ASP.NET2 and SQL Server 2005.
Thanks in advance,
Sam
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.