Visual Studio .NET - Trying to exit Update Command if text box value isn't valid

Here's my code, but it's not getting caught:

If Len(Trim(txtASBRes.Text)) > 0 And InStr(txtASBRes.Text, "|") = 0 Then

'Means there are characters for the person's code
' and no pipecleaner = didn't use ddl for name

lblResCodeWarn.Visible = True
lblResCodeWarn.Text = "* Use list!"
Exit Sub
End If

If the user just types something in and doesn't use the autosuggest text box, then I want to tell them via a warning they need to use the values from the dropdown list.  The above code isn't getting caught though.

Any suggestions are welcome!

Thanks!

The OnRowUpdating event gives you a "last chance" effort to abort the update. In this event, add your code above and also include an e.Cancel = True or whatever value you assing to your GridView event args.

...and....it's my datagrid update command.  Forgot to mention that before I think.

If the user tries to update a name, and doesn't use the autosuggest text box's dropdown list, then I wanna exit the sub and display the error message.

Gotcha, sorry about that.

Instead of using the DataGrid's build in update command, create your own link button and use the CommandName and CommandArgument properties to create your own update procedure. For instance, the CommandName might be "CCUpdate" and the CommandArgument is the primary key for that row.

Then consume the DataGrid.ItemCommand event and check for the "CCUpdate" command. From there you can determine whether or not they have done things properly and update/display label as needed.

I just copied / cut all the code from the UpdateCommand into the Itemcommand and it does the same thing.  The "Exit Sub" isn't getting caught.

With the ItemCommand, you can update or just display the labels. I'm envisioning seeing something like this:

Sub ProcessCommand(sender As Object, e As DataGridCommandEventArgs) Handles DataGrid.ItemCommand

   Select Case e.CommandName

      Case "CCUpdate"
         If Len(Trim(txtASBRes.Text)) > 0 And InStr(txtASBRes.Text, "|") = 0 Then

            'Means there are characters for the person's code
            ' and no pipecleaner = didn't use ddl for name

            lblResCodeWarn.Visible = True
            lblResCodeWarn.Text = "* Use list!"

         Else
            
            UpdateData(e.Item.Cells(2), e.Item.Cells(3))

      Case Else
         ' Do nothing.

   End Select

End Sub

Sean,

You gave me an idea, and it was related to my code.

If there was no "|", I wasn't handling it properly when I ran a database query to make sure the user didn't select a name, then try to edit it on the fly.

So, I needed to say if there's no "|" and the len() > 0, then "NO WAY" & exit the sub

else

if there is a "|" and the len() > 0, then do the db check.

Sorry for the confusion!

end of post