How to check if values have changed using data grid in .net 2.0

Basically, I am using a data grid to display data from a sql table via a web interface. I have given the viewer of this data the ability to edit and update via an update query. when the user updates the data, i write a 1 in a column in the table called "Modified." This is needed, because i have a stored procedure which runs nightly that identifies rows of data containing the number 1 as updated and then emails our IT department so that we can act on the changes.

Here in lies the problem:

If the end user selects a row of data to edit, and then changes her mind and does not update, but still clicks on the "update" button, my code will still write a 1 in the "Modified" column. Similarly, if the end user selects a row of data, then types in the exact same value that already exists and presses the "update" button, my code will again write a 1 in the "modified" column.

I think the best thing to do would be to only "activate" the "update" button if the end user begins typing in the editable fields. Even more so, upon update, the code should be intelligent enough to only insert the number 1 in the Modified column if the data has changed.

I need help modifying my code so that this intelligence exists. Of course, if there are other methods of how to accomplish what i desire I am willing to try them out. My code is listed below.

<asp:SqlDataSource ID="AssociateIndexDataSource" runat="server" 
        ConnectionString="<%$ ConnectionStrings:AssociateIndexTestConnectionString %>" 
        SelectCommand="SELECT * FROM [FSPI_AssociateIndex] ORDER BY [Status] ASC, [AssociateID] ASC"
        InsertCommand="INSERT INTO [FSPI_AssociateIndex] ([AssociateID], [Name], [SSN], [Code], [Status], [Modified]) VALUES (@AssociateID, @Name, @SSN, @Code, @Status, @Modified)"  
        UpdateCommand="UPDATE [FSPI_AssociateIndex] SET [Name] = @Name, [Code] = @Code, [Status] = @Status, [Modified] = @Modified
        WHERE [AssociateID] = @AssociateID">
        <%--WHERE [AssociateID] = @AssociateID--%>
        <%--DECLARE @AssociateID int--%>
        <%-- InsertCommand="INSERT INTO FSPI_AssociateIndex(AssociateID, Name, SSN, Code, Status) VALUES (,,,,)" --%>
    <UpdateParameters>
        <asp:Parameter Name="AssociateID" Type="Int32" />
        <asp:Parameter Name="Name" Type="String" />
        <asp:Parameter Name="SSN" Type="String" Size="9" />
        <asp:Parameter Name="Code" Type="String" Size="6" />
        <asp:Parameter Name="Status" Type="String" Size="1" />
        <asp:Parameter Name="Modified" Type="Int32" Size="1" DefaultValue="1" />
    </UpdateParameters>
    <InsertParameters>
        <asp:Parameter Name="AssociateID" Type="Int32" />
        <asp:Parameter Name="Name" Type="String" />
        <asp:Parameter Name="SSN" Type="String" />
        <asp:Parameter Name="Code" Type="String" />
        <asp:Parameter Name="Status" Type="String" />
        <asp:Parameter Name="Modified" Type="Int32" />
    </InsertParameters>

       </asp:SqlDataSource>
    
    <asp:TextBox ID="tbRequesterName" runat="server" Visible="false"></asp:TextBox>
    
      <div id="content">
      
    <div id="insert">
    
        <asp:FormView ID="FormView1" runat="server" 
            DataSourceID="AssociateIndexDataSource">
           
            <InsertItemTemplate>
            
            <table>
            <tr>
            <td>AssociateID:</td>
            <td>Name:</td>
            <td>SSN:</td>
            <td>Department:</td>
            <td>&nbsp;<!--Status:--></td>
            <td>&nbsp;<!--Modified:--></td>
            <td>&nbsp;</td>
            </tr>
            <tr>
            <td><asp:TextBox ID="AssociateIDTextBox" runat="server" Text='<%# Bind("AssociateID") %>' Width="80" MaxLength="6" /></td>
            <td><asp:TextBox ID="NameTextBox" runat="server" Text='<%# Bind("Name") %>' Width="300" /></td>
            <td><asp:TextBox ID="SSNTextBox" runat="server" Text='<%# Bind("SSN") %>' Width="90" MaxLength="9" /></td>
            <td><asp:TextBox ID="CodeTextBox" runat="server" Text='<%# Bind("Code") %>' Width="50" MaxLength="5" /></td>
            <td><asp:TextBox ID="StatusTextBox" runat="server" Text='<%# Bind("Status") %>' Width="10" MaxLength="1" Visible="false" >A</asp:TextBox></td>
            <td><asp:TextBox ID="ModifiedtextBox" runat="server" Text='<%# Bind("Modified") %>' Width="1" MaxLength="1" Visible="false" >2</asp:TextBox></td>
            <td><asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert" ><img src="images/Next.png" border="0" alt="Insert" /></asp:LinkButton>
            <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel" ><img src="images/Cancel.png" border="0" alt="Cancel" /></asp:LinkButton></td>
            </tr>
            </table>
            </InsertItemTemplate>
            <ItemTemplate>
                <asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" CommandName="New" ><img class="addnewassociateimg" src="images/AddAssociate.png" border="0" alt="Add" /></asp:LinkButton>
            </ItemTemplate>
        </asp:FormView>
        <br />
    </div>
      
      
             <asp:GridView ID="GridView2" runat="server" AllowSorting="True" CssClass="aitable" DataKeyNames="AssociateID"
           AutoGenerateColumns="False" CellPadding="4" 
           DataSourceID="AssociateIndexDataSource" ForeColor="#333333" GridLines="None">
           <RowStyle BackColor="#f6f6f6" ForeColor="#333333" />
           <Columns>
               <%--<asp:CommandField ShowDeleteButton="True" ButtonType="Image" DeleteImageUrl="images/Delete.png" />--%>
               <asp:CommandField ShowEditButton="True" ButtonType="Image" EditImageUrl="images/Edit.png" UpdateImageUrl="images/Next.png" CancelImageUrl="images/Cancel.png" />
               <asp:TemplateField HeaderText="AssociateID" SortExpression="AssociateID">
                   <EditItemTemplate>
                       <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("AssociateID") %>' Width="60" MaxLength="6"></asp:TextBox>
                   </EditItemTemplate>
                   <ItemTemplate>
                       <asp:Label ID="Label3" runat="server" Text='<%# Bind("AssociateID") %>'></asp:Label>
                   </ItemTemplate>
               </asp:TemplateField>
               <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" >
                   <ControlStyle Width="300px" />
               </asp:BoundField>
<%--               <asp:BoundField DataField="SSN" HeaderText="SSN" ReadOnly="false" 
                   SortExpression="SSN" DataFormatString="*********"  >
               
                   <ControlStyle Width="90px" />
               </asp:BoundField>--%>
               <asp:TemplateField HeaderText="SSN" SortExpression="SSN">
                   <EditItemTemplate>
                       <asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("SSN") %>' Width="90" MaxLength="9"></asp:TextBox>
                   </EditItemTemplate>
                   <ItemTemplate>
                   <asp:Label id="SSNLabel" runat="server" Text='<%# "***-**-" + Eval("SSN").ToString().SubString(5) %>'></asp:Label>
                    
                   </ItemTemplate>
                   <ControlStyle Width="90px" />
               </asp:TemplateField>
               
               <asp:TemplateField HeaderText="Department" SortExpression="Code">
                   <EditItemTemplate>
                       <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("Code") %>' Width="50" MaxLength="5"></asp:TextBox>
                   </EditItemTemplate>
                   <ItemTemplate>
                       <asp:Label ID="Label2" runat="server" Text='<%# Bind("Code") %>'></asp:Label>
                   </ItemTemplate>
               </asp:TemplateField>
               <asp:TemplateField HeaderText="Status" SortExpression="Status">
                   <EditItemTemplate>
                       <asp:DropDownList ID="DropDownList1" runat="server" Text='<%# Bind("Status") %>' Width="40" MaxLength="1">
                       <asp:ListItem>A</asp:ListItem>
                       <asp:ListItem>T</asp:ListItem>
                       </asp:DropDownList>
                       <%--<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Status") %>' Width="10" MaxLength="1"></asp:TextBox>--%>
                   </EditItemTemplate> 
                   <ItemTemplate>
                       <asp:Label ID="Label1" runat="server" Text='<%# Bind("Status") %>'></asp:Label>
                       <%--<asp:TextBox ID="UpdateModified" runat="server" Text='<%# Bind("Modified") %>' Visible="false" Width="1" MaxLength="1">1</asp:TextBox>--%>
                   </ItemTemplate>
               </asp:TemplateField>
           </Columns>
           <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
           <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
           <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
           <HeaderStyle BackColor="#006600" Font-Bold="True" ForeColor="White" />
           <AlternatingRowStyle BackColor="White" />
       </asp:GridView>
       </div>
    </form>

Select allOpen in new window