Solved

Gridview RowUpdating Exception Handling

Posted on 2008-10-02
4
2,432 Views
Last Modified: 2013-11-11
I am attempting to update an SQL 2005 table from a gridview.  The table has a unique index on two fields, PersonID and EmailTypeID.

I can update a record successfully if the record is indeed unique:

PersonID     EmailTypeID
123             1
123             2
123             3

the record is committed to the DB and all is well.

If I attempt to update and violate the unique index such as:
PersonID     EmailTypeID
123             1
123             2
123             2

I get no response in the web page.  The update simply does not happen, but there is no indication on the page that there is a problem.

If I run Query Analyzer and run the generated SQL captured from Profiler, I get the obvious:
 "Cannot insert duplicate key row"

I tried to use:
    Protected Sub grdEmails_RowUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles grdEmails.RowUpdating

    End Sub

but I can't seem to expose any exception class from e.

I am using a LinqDataSource... and I only have two properties in my codebehind

How can I trap the exception?

Thanks,
Aaron

<asp:UpdatePanel ID="UpdatePanel1" runat="server">

<ContentTemplate>

<asp:GridView ID="grdEmails" runat="server" AutoGenerateColumns="False" DataSourceID="ldsPersonEmails" 

    DataKeyNames="EmailRecordID" OnRowUpdating="UpdateEmails">

    <Columns>

        <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" EditText="edit" DeleteText="delete" />

        <asp:TemplateField HeaderText="Email">

            <EditItemTemplate>

                <asp:TextBox ID="txtEditEmailAddress" runat="server" Text='<%# Bind("EmailAddress")%>' ></asp:TextBox>

            </EditItemTemplate>

            <FooterTemplate>

                Add

                <asp:TextBox ID="txtNewEmailAddress1" runat="server"></asp:TextBox>

            </FooterTemplate>

            <ItemTemplate>

                <asp:HyperLink ID="hlkEmailAddress" runat="server" NavigateUrl='<%# Eval("EmailAddress", "mailto:{0}") %>'

                    Text='<%# Eval("EmailAddress") %>'>

                </asp:HyperLink>

            </ItemTemplate>

        </asp:TemplateField>

        <asp:TemplateField HeaderText="Type">

            <FooterTemplate>

                <asp:DropDownList ID="ddlEmailTypes1" DataSourceID="ldsEmailTypes" DataValueField="EmailTypeID"

                    DataTextField="EmailDescription"  runat="server">

                </asp:DropDownList>

            </FooterTemplate>

            <ItemTemplate>

                <%#Eval("email_type.EmailDescription")%>

            </ItemTemplate>

            <EditItemTemplate>

                <asp:DropDownList ID="ddlEmailTypes2" DataSourceID="ldsEmailTypes" DataValueField="EmailTypeID"

                    DataTextField="EmailDescription" SelectedValue='<%#Bind("EmailTypeID")%>' runat="server">

                </asp:DropDownList>

            </EditItemTemplate>

        </asp:TemplateField>

    </Columns>

    <EmptyDataTemplate>

        No email addresses on file.<br />

        <br />

        Add a new email address:<br />

        <asp:TextBox ID="txtNewEmailAddress2" runat="server"></asp:TextBox>

        <asp:DropDownList ID="ddlEmailTypes3" DataSourceID="ldsEmailTypes" DataValueField="EmailTypeID"

                    DataTextField="EmailDescription"  runat="server">

        </asp:DropDownList>

        <asp:LinkButton ID="lnkAddNewEmailEmptyData" runat="server">Add</asp:LinkButton>

    </EmptyDataTemplate>

</asp:GridView>

<asp:LinqDataSource ID="ldsPersonEmails" runat="server" ContextTypeName="VBCODE.jhadbDataClassesDataContext"

    TableName="person_emails" Where="PersonID == @PersonID" EnableDelete="True" EnableInsert="True"

    EnableUpdate="True">

    <WhereParameters>

        <asp:QueryStringParameter Name="PersonID" QueryStringField="PersonID" Type="Int32" />

    </WhereParameters>

</asp:LinqDataSource>

<asp:LinqDataSource ID="ldsEmailTypes" ContextTypeName="VBCODE.jhadbDataClassesDataContext"

    TableName="email_types" runat="server">

</asp:LinqDataSource>

</ContentTemplate>

</asp:UpdatePanel>

Open in new window

0
Comment
Question by:abenage
  • 2
4 Comments
 
LVL 12

Expert Comment

by:madhevan_pillai
ID: 22658125
Hi

Did you get any exception like the below
Could not find a row that matches the given keys in the original values stored in ViewState.  Ensure that the 'keys' dictionary contains unique key values that correspond to a row returned from the previous Select operation.
0
 
LVL 1

Author Comment

by:abenage
ID: 22659471
I think I have ran into that problem and I needed to make sure there was a unique column on the database table.  For example, I was using the PersonID and EmailTypeID columns for the primary key.  What I had to do was create a EmailRecordID column, type INT, Identity True and set that as the Primary key.  I then used the other two columns to create a unique index.  Then, in my gridview, I set the DataKeyNames to the new EmailRecordID column.  Does this help you?
0
 
LVL 4

Accepted Solution

by:
novynov earned 500 total points
ID: 22670543
Using the controls that you mentioned (LinqDataSource / GridView), there are 3 events during update that expose an exception:

- LinqDataSource.OnUpdating - LinqDataSourceUpdateEventArgs.Exception
- LinqDataSource.OnUpdated - LinqDataSourceStatusEventArgs.Exception
-GridView.OnRowUpdated - GridViewRowUpdatedEventArgs.Exception

The GridView.OnRowUpdating does not expose one.

That said, I believe an exception due to a violation of a constraint (e.g. FK) will be trappable both on LinqDataSource.OnUpdated as well as GridView.OnRowUpdated.

On each of those events, there is an ExceptionHandled property that you can set to true if you want the exception to cease bubbling up.

Please let me know if this doesn't answer your question. I'll be glad to help.




0
 
LVL 1

Author Comment

by:abenage
ID: 22679454
I got it with LinqDataSource.OnUpdating.  Thanks!
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now