show / hide menu

MS SQL DataSource

Working with MS SQL Tables/Views

Click on Toolbox, select Data and drag the search control into the designer area.

The properties window pops up on the right along with the Search.

Select Properties->DataSource-> DataSource Type to configure Search specifically from a source.

On clicking icon all data bases available are listed. Select a DB and click Next

On clicking next a list of all tables available in the selected db is displayed. Select table/tables and click Next
Select the columns which are to be displayed in Search from the tables selected and click Next

Set the criteria based on which the Search is to be populated by clicking Add. The first drop down will contain all the column names of the list into which Select is to be applied, second drop down will contain a list of operators that are applicable for criteria satisfaction and the third auto complete field when typed in will display the control name from which the list value is to be obtained.
Click on + icon to add more criteria.
The number of rows to be selected from the DB can be specified in the text field.

Click Next and the relationship can be set between tables selected. Select the primary table and the column in this table which has a reference at the child table. Click on Add to add the relationship which is displayed below.

Clicking on Next and all the columns which were provided as result columns are displayed here. The look and feel of search control can be configured here. The Column headers are by default given as the column names which can be edited. The column width can be changed, can be hidden, sorted, .

Add composite column
A composite column is a customized column created as a conjunction of two or more result columns. This can be specified under Add composite column and click button Add.

Configure column
Click on the icon to customize each column.

Column Footer Operators
Set the last column value to display total, average etc by selecting one of the options. Enable pagewise to display the footers specific to each operation set on a page. Expression signifies the calculation to be provided once the operation has been performed on the total.Eg. There is a search with 10 pages. For a column X in this search, Operator Total is selected and pagewise is ticked with Expression set as 10. In each page footer is displayed as (total of 10 rows)10.

Text Alignment
Text alignment of each column can be set by selecting the positions from the drop down.

Column Format
A format can be set for each column.

Add FillData trigger
Click on Add Trigger to create a rule automatically to initiate the fill of Search control based on criteria provided. Select a trigger and click on Create Rule to create rule with specific trigger.

Click on Finish and the Search configuration will be completed.
The rule created can be viewed from Rule tab with the trigger provided.

Dynamic Grid Configuration