Solved

Gridview RowUpdating Exception Handling

Posted on 2008-10-02
4
2,451 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
how to reference the id of my checkbox in a dynamic GridView control 2 30
Updating a single record in forEach using C#/Entity 7 26
ModalPopup  question 22 38
Json and ajax 1 22
User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

733 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