Mega Code Archive
Categories
/
ASP.Net
/
ADO Database
Using the RowDeleted event to catch SQL errors (C#)
<%@ Page Language="C#" %>
Untitled Page
" DataSourceMode="DataSet" DeleteCommand="DELETE From Customers WHERE (CustomerID = @CustomerID)" UpdateCommand="UPDATE [Customers] SET [CompanyName] = @CompanyName, [ContactName] = @ContactName, [ContactTitle] = @ContactTitle, [Address] = @Address, [City] = @City, [Region] = @Region, [PostalCode] = @PostalCode, [Country] = @Country, [Phone] = @Phone, [Fax] = @Fax WHERE [CustomerID] = @original_CustomerID" OnDeleted="SqlDataSource1_Deleted">
File: Web.config