How to: Validate Data When a New Row is Added to a ListObject Control

Users can add new rows to a ListObject control that is bound to data. You can validate the user's data before committing the changes to the data source.

Applies to: The information in this topic applies to document-level projects and VSTO add-in projects for Excel. For more information, see Features Available by Office Application and Project Type.

Whenever a row is added to a ListObject that is bound to data, the BeforeAddDataBoundRow event is raised. You can handle this event to perform your data validation. For example, if your application requires that only employees between the ages of 18 and 65 can be added to the data source, you can verify that the age entered falls within that range before the row is added.

Note
You should always check user input on the server in addition to the client. For more information, see Secure Client Applications.

To validate data when a new row is added to data-bound ListObject

1. Create variables for the ID and DataTable at the class level.

   C#

   VB

   C++

   Copy

   No code example is currently available or this language may not be supported.

2. Create a new DataTable and add sample columns and data in the Startup event handler of the Sheet1 class (in a document-level project) or ThisAddIn class (in an VSTO Add-in project).

   C#

   VB

   C++

   Copy

   No code example is currently available or this language may not be supported.

3. Add code to the list1_BeforeAddDataBoundRow event handler to check whether the age entered falls within the acceptable range.

   C#

   VB

   C++

   Copy

   No code example is currently available or this language may not be supported.

This code example assumes that you have an existing ListObject named list1 on the worksheet in which this code appears.

Extending Word Documents and Excel Workbooks in VSTO Add-ins at Run Time
Controls on Office Documents
Adding Controls to Office Documents at Run Time
ListObject Control
Automating Excel by Using Extended Objects
How to: Map ListObject Columns to Data