Select field using Ajax to reload select field
This example covers the development of a search application using the Ajax field reload.
Creating a new grid
1. Create a new grid application and choose I'd like to inform the SQL Select Statement option.
 |
 |
|
 |
||
 |
 |
2. Enter the SQL Select Statement as below:
SELECT
E.EmployeeID,
E.LastName,
E.FirstName,
E.Title,
E.TitleOfCourtesy,
E.BirthDate,
E.HireDate,
E.Address,
E.PostalCode,
E.Country,
E.CityID,
E.RegionID,
E.HomePhone,
E.Extension,
E.Photo,
E.Notes,
E.ReportsTo,
E.PhotoPath,
U.EmployeeID,
U.TerritoryID
FROM
employees E INNER JOIN employeeterritories U ON E.EmployeeID = U.EmployeeID
INNER JOIN territories T ON U.TerritoryID = T.TerritoryID
Note: It is possible to use the SQL Builder tool.
|
|
|
 |
||
|
|
3. Select the Select Fields option in application menu and choose U.EmployeeID, E.LastName, E.FirstName, E.Title, E.BirthDate, E.HireDate, E.RegionID, U.TerritoryID and E.Country fields.
|
|
|
 |
||
|
|
Starting Grid application by Search
4. Open Grid folder and click in Settings.
|
|
|
 |
||
|
|
5. Change the property Start by Search to Yes.
|
|
|
 |
||
|
|
Choosing Search fields
6. Open the Search folder and click in Select Fields.
|
|
|
 |
||
|
|
7. Choose E.RegionID and U.TerritoryID fields.
|
|
|
 |
||
|
|
Field Settings
8. Open U.TerritoryID field, in search fields.
|
|
|
 |
||
|
|
9. Change Data Type attribute to Select.
10. Open the Search Lookup block.
|
|
|
 |
||
|
|
11. Configure the settings according to the image below.
|
|
|
 |
||
|
|
12. Open E.RegionID settings, modify the Data Type attribute to Select configure it as following .
|
|
|
 |
||
|
|
Enabling Ajax to reload the field
13. Open the Ajax Processing block and mark the option "Use AJAX to reload...".
|
|
|
 |
||
|
|
| Rate this Tutorial | |||||||
|
|||||||
|
