Reply to thread

Message

[QUOTE="Radu, post: 3436303"]
Hi. I'm struggling to understand what's happening here:

I have the following HTML:

<asp:GridView
      ID="GridView1"
      DataSourceID="SqlDataSource1"
      DataKeyNames="ID"
      AutoGenerateColumns="False"
      ShowFooter="True"
      OnPreRender="GridView1_Prerender"
      OnRowUpdating="GridView1_OnRowUpdating"
      OnRowUpdated="GridView1_OnRowUpdated"
      OnRowDeleting="GridView1_OnRowDeleting"
      OnRowDeleted="GridView1_OnRowDeleted"
      Runat="server"
        <Columns>
          <asp:TemplateField HeaderText="Employee PIN">
            <ItemTemplate>
              <asp:Label ID="EmployeePINLabel" Runat="Server"><
%#Eval("EmployeePIN")%></asp:Label>
            </ItemTemplate>
            <FooterTemplate>
              <asp:TextBox ID="EmployeePINTextBoxAdd" Columns="6"
OnTextChanged="EmployeePINChanged_Add" Runat="Server"></asp:TextBox>
              <asp:RequiredFieldValidator
                id="reqEmployeePINAdd"
                ValidationGroup="Footer-Add"
                ControlToValidate="EmployeePINTextBoxAdd"
                Display="Dynamic"
                Text="*"
                ErrorMessage="The employee's PIN# is required !"
                runat="server">
              </asp:RequiredFieldValidator>

<asp:RegularExpressionValidator
                id="regexEmployeePINAdd"
                ValidationGroup="Footer-Add"
                ControlToValidate="EmployeePINTextBoxAdd"
                Display="Dynamic"
                ValidationExpression="\d{6}"
                Text="*"
                ErrorMessage="The PIN entered is not correct !"
                runat="server">
              </asp:RegularExpressionValidator>

<asp:CompareValidator
                id="compareEmployeePINAdd"
                ValidationGroup="Footer-Add"
                ControlToValidate
="EmployeePINTextBoxAdd"
                ValueToCompare="100000"
                Operator="GreaterThan"
                Display="Dynamic"
                Text="*"
                ErrorMessage="The PIN entered is not
correct !"
                runat="server">
              </asp:CompareValidator>
            </FooterTemplate>

<EditItemTemplate>
              <asp:TextBox ID="EmployeePINTextBoxEdit" Columns="6"
OnTextChanged="EmployeePINChanged_Edit"  Text='<%# Eval("EmployeePIN")
%>' Runat="server"></asp:TextBox>
              <asp:RequiredFieldValidator
                id="reqEmployeePINEdit"
                ValidationGroup="Row-Edit"
                ControlToValidate="EmployeePINTextBoxEdit"
                Display="Dynamic"
                Text="*"
                ErrorMessage="The employee's PIN# is required !"
                runat="server">
              </asp:RequiredFieldValidator>

<asp:RegularExpressionValidator
                id="regexEmployeePINEdit"
                ValidationGroup="Row-Edit"
                ControlToValidate="EmployeePINTextBoxEdit"
                Display="Dynamic"
                ValidationExpression="\d{6}"
                Text="*"
                ErrorMessage="The PIN entered is not correct !"
                runat="server">
              </asp:RegularExpressionValidator>

<asp:CompareValidator
                id="compareEmployeePINEdit"
                ValidationGroup="Row-Edit"
                ControlToValidate
="EmployeePINTextBoxEdit"
                ValueToCompare="100000"
                Operator="GreaterThan"
                Display="Dynamic"
                Text="*"
                ErrorMessage="The PIN entered is not
correct !"
                runat="server">
              </asp:CompareValidator>
            </EditItemTemplate>
            <ItemStyle HorizontalAlign="Center"/>
          </asp:TemplateField>
          .....
          .....
          <asp:TemplateField HeaderText="Edit Record">
                <ItemTemplate>
                  <asp:LinkButton
                    ID = "linkEdit"
                    ForeColor="darkBlue"
                    runat = "server"
                    CausesValidation ="false"
                    CommandName = "Edit"
                    text = "Edit"
                  </asp:LinkButton>
                </ItemTemplate>

<asp:LinkButton
                    ID = "linkCancel"
                    ForeColor="darkBlue"
                    runat = "server"
                    CausesValidation ="false"
                    CommandName = "Cancel"
                    text = "Cancel"
                  </asp:LinkButton>
                </EditItemTemplate>

<asp:ValidationSummary
        id="validSummaryAdd"
        ValidationGroup="Footer-Add"
        ShowSummary="false"
        ShowMessageBox="true"
        HeaderText="The following things have to be fixed (Record -
Add)"
        runat="server"
/>
<asp:ValidationSummary
        id="validSummaryEdit"
        ValidationGroup="Row-Edit"
        HeaderText="The following things have to be fixed (Record -
Edit)"
        ShowSummary="false"
        ShowMessageBox="true"
        runat="server"
/>

....
....

Then I have the code:
protected void cmdAdd_OnClick(object sender, EventArgs e) //Handles
cmdAdd.Click
  {
    //Add the record to the Watchlist table, and maybe also add a
record to the Comments table...
    Util_AddRecord();
    .....
    .....
  }

and

protected void Util_AddRecord()
  //Called by cmdAdd_OnClick
  {
    ....
    ....
    bool boolAddCommentsAsWell;

//Ask the user if he wants to also add a record in the "Comments"
table:
    if (HiddenField1.Value.Equals("1"))
      //User clicked okay
      boolAddCommentsAsWell = true;
    else
      //User clicked cancel
      boolAddCommentsAsWell = false;

//Create a one-to-one reference between this record and the record
in Comments if
    //strCommentsID not null:
    string strCommentsID;
    if (boolAddCommentsAsWell == true)
      strCommentsID = "W " + lblID.Text;
    else
      strCommentsID = "";

SqlDataSource1.InsertParameters["EmployeePIN"].DefaultValue =
txtEmployeePIN.Text;
    ....
    SqlDataSource1.InsertParameters["CommentsID"].DefaultValue =
strCommentsID;

SqlDataSource1.Insert();
    ....
    ....
  }

The problem is the following:

- if I delete the HTML line

OnClientClick="javascript:return ShowConfirm1()"

and therefore skip asking the question, and if I change

if (HiddenField1.Value.Equals("1"))
        //User clicked okay
        boolAddCommentsAsWell = true;
      else
        //User clicked cancel
      boolAddCommentsAsWell = false;

to
      boolAddCommentsAsWell = true;

then the validators validate, and the code SqlDataSource1.Insert()
executes properly.

- if I run the code as it is, with the confirmation script and the
if (HiddenField1.... lines, the validators DON'T VALIDATE, so
therefore SqlDataSource1.Insert() inserts whatever I have entered in
the gridview. Of course, if I skip entering some cells, it will
attempt to insert NULLS, which could fail, depending on the fields.

Therefore, my question is - why don't the validators validate when I
have an extra javascript in the code ? I would have expected to have
the validators validate BEFORE the cmdAdd_OnClick starts executing...
Besides, the Javascript (ShowConfirm1) has nothing to do with them....

Thanks a lot
Alex.
[/QUOTE]

Verification