How to Bring back Data from an Adapter

Sometimes when you work on a customization you will need to retrieve some data from other table and to bring it to your form you will use the adapter of this table.

Let suppose you want to bring a part data (Part number, Part description) to your customization and you want to let the user to search for a part using the search dialog window.

I will show you how to do this easily.

·         Add the below controls from the Toolbox to your form:
        o   EpiButton and set the Text properties to “Part…”.
       o Two EpiTextBox and bind them to an available UD fields in your table (The table which I used in 

                  my customization is UD107 will use Character01 and Character02 fields).
             o      EpiLabel and set the Text properties to “Description”.

·         Arrange them to look like the below:

·         You want to bring the data from Part Adapter using search dialog window.  

From the main menu of the customization tools dialog window select Tools => Wizards => Customization Wizards as below:

·         The Customization Code Wizard dialog window appears.

Select Simple Search and click Lunch Wizard button.

·         The Simple Search Wizard window appears.

Click Get Adapters button to retrieve all adapters and then choose PartAdapter from the adapter list and then click Next button.

·         The choose Search Dialog  radio box and then select partNum field from Search Fields drop down list and select the Data View which you are working on in your customization ( For me UD107) and then select Character01 from Fields drop down list then click add button.

·         Repeat the last step to link PartDescription to UD107.Character02 and then click finish.

·         The SearchOnPartAdapterShowDialog method will be added automatically into the code editor.

This method open the search dialog window and allow the user search for a part and when the user choose the part from the result and press ok the partNum and PartDescription data will fill automatically in the text boxes.

·         You have to call this method from another method in custom code and will call it when the user clicks on the button which we added it in the first step. So first add the click method for the button ass below:

·         The Click method code will be added automatically in the code editor and to call the SearchOnPartAdapterShowDialog method add the below code into button click method:

·         From the main menu of customization tools dialog window select Tools => Test code or Press F5 for test your code.

·         If the code tested successfully then save the Customization and close all windows.

·         Reopen your customization and test your customization by adding a new line.