Catch errors when updating a DetailsView control

[stuart.d.jones]

Hi,

I have a DetailsView control bound to a SqlDataSource. I've got
everything working nearly as I want, but here's my problem.

I have a table which has a Guid as a Primary Key, and a VarChar field
(a Title) which is also unique. If the user edits the Title field in
the DetailsView to make it a duplicate, and hits Update, an exception
is thrown (SQLException - statement cancelled as it would violate the
key restrictions).

I was under the impression that regardless of the outcome, the
ItemUpdated event of the DetailsView control would fire, and I could
then check the Exception properties of the event arguments, and act
accordingly.

How can I catch these errors - I have no control over the code where
the error's occurring, so I can't put a try-catch block in? Can I do
this, or do I have to faff around making sure they don't happen before
it tries to save the changes? And if I can't do this, when do the
Exception properties of the ItemUpdated event arguments ever get
used...???

Any help much appreciated!

Cheers.

Stuart

[Mr Newbie]

You need to post more accurate information rather than have us Guess what
your table design is. It sounds to me like the GUID in the current record is
being used as the PK in the duplicate, this is not allowed.

Post your data description for this table and relevent code.

--
Best Regards

The Inimitable Mr Newbie º¿º
<st************ @gmail.com> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .

Hi,

I have a DetailsView control bound to a SqlDataSource. I've got
everything working nearly as I want, but here's my problem.

I have a table which has a Guid as a Primary Key, and a VarChar field
(a Title) which is also unique. If the user edits the Title field in
the DetailsView to make it a duplicate, and hits Update, an exception
is thrown (SQLException - statement cancelled as it would violate the
key restrictions).

I was under the impression that regardless of the outcome, the
ItemUpdated event of the DetailsView control would fire, and I could
then check the Exception properties of the event arguments, and act
accordingly.

How can I catch these errors - I have no control over the code where
the error's occurring, so I can't put a try-catch block in? Can I do
this, or do I have to faff around making sure they don't happen before
it tries to save the changes? And if I can't do this, when do the
Exception properties of the ItemUpdated event arguments ever get
used...???

Any help much appreciated!

Cheers.

Stuart

[stuart.d.jones]

It isn't anything to do with the Guid. The Title field is also a key.
If I change the title field to a value which is also in the table, then
it throws the error below (I couldn't get the description last night,
as I was at home). How can I catch this error, or get the DetailsView
or SqlDataSource to catch it for me, and keep it so I can check on it?
As far as I'm concerned that's all I need to tell you - I don't want to
confuse the issue by pasting the full schema of a massive table when I
know precisely what's going wrong - I just want to catch it! And as
for what code is being executed - there isn't any, it's all handled by
the DetailsView! Hence my puzzlement.

Violation of UNIQUE KEY constraint 'IX_TableName_1 '. Cannot insert
duplicate key in object 'dbo.TableName.
The statement has been terminated.

This key is the one referring to the Title field.

Stack trace follows, in case you need it:
[SqlException (0x80131904): Violation of UNIQUE KEY constraint
'IX_Courses_1'. Cannot insert duplicate key in object 'dbo.Courses'.
The statement has been terminated.]
System.Data.Sql Client.SqlConne ction.OnError(S qlException exception,
Boolean breakConnection ) +177
System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion
exception, Boolean breakConnection ) +68

System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning(Tds ParserStateObje ct
stateObj) +199
System.Data.Sql Client.TdsParse r.Run(RunBehavi or runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleR esultSet bulkCopyHandler , TdsParserStateO bject stateObj)
+2300
System.Data.Sql Client.SqlComma nd.FinishExecut eReader(SqlData Reader
ds, RunBehavior runBehavior, String resetOptionsStr ing) +147
System.Data.Sql Client.SqlComma nd.RunExecuteRe aderTds(Command Behavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean
async) +1021
System.Data.Sql Client.SqlComma nd.RunExecuteRe ader(CommandBeh avior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
method, DbAsyncResult result) +314

System.Data.Sql Client.SqlComma nd.InternalExec uteNonQuery(DbA syncResult
result, String methodName, Boolean sendToPipe) +413
System.Data.Sql Client.SqlComma nd.ExecuteNonQu ery() +115

System.Web.UI.W ebControls.SqlD ataSourceView.E xecuteDbCommand (DbCommand
command, DataSourceOpera tion operation) +392

System.Web.UI.W ebControls.SqlD ataSourceView.E xecuteUpdate(ID ictionary
keys, IDictionary values, IDictionary oldValues) +643
System.Web.UI.D ataSourceView.U pdate(IDictiona ry keys, IDictionary
values, IDictionary oldValues, DataSourceViewO perationCallbac k
callback) +78
System.Web.UI.W ebControls.Deta ilsView.HandleU pdate(String
commandArg, Boolean causesValidatio n) +1153
System.Web.UI.W ebControls.Deta ilsView.HandleE vent(EventArgs e,
Boolean causesValidatio n, String validationGroup ) +450
System.Web.UI.W ebControls.Deta ilsView.OnBubbl eEvent(Object source,
EventArgs e) +88
System.Web.UI.C ontrol.RaiseBub bleEvent(Object source, EventArgs
args) +35
System.Web.UI.W ebControls.Deta ilsViewRow.OnBu bbleEvent(Objec t
source, EventArgs e) +109
System.Web.UI.C ontrol.RaiseBub bleEvent(Object source, EventArgs
args) +35
System.Web.UI.W ebControls.Butt on.OnCommand(Co mmandEventArgs e) +86
System.Web.UI.W ebControls.Butt on.RaisePostBac kEvent(String
eventArgument) +155

System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP ostBackEvent(St ring
eventArgument) +7
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument) +11
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData)
+33
System.Web.UI.P age.ProcessRequ estMain(Boolean
includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint)
+4921

[stuart.d.jones]

Fixed it.

Setting e.ExceptionHand led = True rather than False seems to work just
fine. D'oh!