Introduction to data filtering of grid parts interface

It is very convenient to measure the grid parts of the rapid development platform, which can be used to set the filter and find in the right property.
650) this.width=650; "id=" aimg_866 "src=" http://bbs.delit.cn/data/attachment/forum/201601/06/ 111711rkqfqz1pduujpfff.jpg.thumb.jpg "width=" "height=" 156 "alt=" 111711rkqfqz1pduujpfff.jpg.thumb.jpg "/>
in this way, users can easily filter the data that is queried in the database, in the interface.
The above is a simple setup method, we can also use the script to implement the interface data filtering, for other functions. For example, the data in the same grid, we have to export the XLS according to the category, we can use the script to filter the interface data, and then perform the export.
The following code is an example given:
'------------------Code starts-------------------------------------------

' derived from the WYSIWYG output of the mesh part

' through row filtering of grid parts

Mesh Parts 1.DataTable.DefaultView.RowFilter=" category = ' live -in personnel" ' "

Dim FilePath = "c:\expfile\ . xls"

Dim file

file= Mesh Part 1.ExportToExcel (FilePath)

‘-----------------------------------------------------------

Mesh Parts 1.datatable.defaultview.rowfilter= " category = ' medical staff '"

FilePath = "C:\expfile\ medical staff . xls"

file= Mesh Part 1.ExportToExcel (FilePath)

Mesh Parts 1.datatable.defaultview.rowfilter= "1=1"

Original address: http://bbs.delit.cn/thread-572-1-1.html

Reprint please specify the source:

Author: metric Technology http://www.delit.cn

Introduction to data filtering of grid parts interface