Comparing two Values in Griview Using CustomValidator

See more:

ASP.NET

Hello Guys,

-There is 2 columns(i.e txtAQty(Available Quantity) and txtQtyOff(Quantity Needed)) and 2 different text boxes in a GridView Footer Row.
-When I insert the data using Footer Row it save the data in DataRow.
-Now I want to compare values of the two text boxes(i.e txtAQty(Available Quantity) and txtQtyOff(Quantity Needed))
-I implement CustomValidator which is not working properly.
-When I insert a record it is supposed to show the error message.
-But it is inserting the record as well and displaying the error message also..

-Please Help..

Thanks in Advance.


Behind The Code:
****************

protected void CustomValidator1_ServerValidate(object sender, ServerValidateEventArgs args)
       {

           CustomValidator cv = (CustomValidator)sender;

           GridViewRow grv1 = (GridViewRow)cv.NamingContainer;

           //dim gvr As GridViewRow = cv.NamingContainer

           decimal txtofstock = 0;
           decimal txtastock = 0;

           decimal.TryParse(((TextBox)GridView1.FooterRow.FindControl("txtQtyOff")).Text, out txtofstock);
           decimal.TryParse(((TextBox)GridView1.FooterRow.FindControl("txtAQty")).Text, out txtastock);

           if (txtofstock > txtastock)
           {
               Response.Write("Error");
               //lblError.Text = "Error ";
           }

       }

ASPX Page:
**********

<Columns>
                <asp:TemplateField HeaderText="AvailableQuantity" HeaderStyle-ForeColor="Maroon" HeaderStyle-BackColor="LightGray">
                    <ItemTemplate>
                        <asp:Textbox ID = "txtAQty"   runat ="server" Text='<%# Eval("AQty") %>'  BorderWidth="0" Width="100%"  ></asp:Textbox>
                    </ItemTemplate>
                    <FooterTemplate>
                        <asp:TextBox ID ="txtAQty" runat="server"  AutoPostBack="true" ></asp:TextBox>
                    </FooterTemplate>
                </asp:TemplateField>
            </Columns>
            <Columns>
                <asp:TemplateField HeaderText="QuantityOffered"  HeaderStyle-ForeColor="Maroon" HeaderStyle-BackColor="LightGray" >
                    <ItemTemplate>
                        <asp:TextBox ID="txtQtyOff" runat="server" Text='<%# Eval("QtyOff") %>' BorderWidth="0" Width="100%"></asp:TextBox>
                    </ItemTemplate>
                    <FooterTemplate>
                        <asp:TextBox ID="txtQtyOff" runat="server" AutoPostBack="true"   ></asp:TextBox>
                        <asp:CustomValidator  ID="CmpVal" Text = "*"  OnServerValidate="CustomValidator1_ServerValidate" runat="server" ValidateEmptyText="true" ControlToValidate="txtAQty" ></asp:CustomValidator>
                    </FooterTemplate>
                </asp:TemplateField>
            </Columns>