[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Binding Navigator - how do you get Validate to fire when someone clicks the add button more than once?

Posted on 2009-02-22
Medium Priority
Last Modified: 2013-11-26
I've been trying, once again, to do some of the simplest things with the BindingNavigator tied to a BindingSource and without generating errors.
One thing I can't seem to solve, it that if a user clicks the "Add" button on the BindingNavigator more than once, it attempts to save the previous record without firing the Validate event (and saves nulls even though they are trapped in the dataset partial class).
Clicking the Save icon, I can trap that click event and run a save routine and validation works just fine.
Since there seems to be no way to enforce validation rules (on the recordset) during this situation, I need to disable the add button after it is clicked once or somehow prevent the button from being active if the current record has not been saved or validated.
Code to follow - hopefully soon
Question by:bd9000
  • 2
LVL 11

Accepted Solution

PlatoConsultant earned 2000 total points
ID: 23707516
yaps binding navigator generated code  works fine with simple situations but in complex scenarios you have to write your own logic,

please delete the add new and save button and replace it with your own customized buttons,

 make your own logic and program it into the controls .  you will love the control you get on the database operations.


Author Comment

ID: 23707726
I made the add button invisible as soon as it is clicked - I have some of my own logic now.  I guess I'm still surprised that the 3rd generation of bound controls is still unusable for real-world situations.  Unfortunately, I think there are too many people out there wasting inordinate amount of time finding all the work-arounds than just doing it the old-fashioned way (binding your own controls, write your own navigators). I would have had the project done weeks ago had I taken the old route. Geez!
LVL 11

Expert Comment

ID: 23717034
Yaps Same with me i m using binding navigator but all the update and new record logic written by me.

actually it varies case to case,


Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

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

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses
Course of the Month20 days, 2 hours left to enroll

872 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