Performing Advanced Filtering

Chia sẻ: Tuan Nghia | Ngày: | Loại File: PDF | Số trang:1

Thêm vào BST

Báo xấu

84
lượt xem 6
download

Download Vui lòng tải xuống để xem tài liệu đầy đủ

Performing Advanced Filtering The RowFilter property of a DataView is similar to a WHERE clause in a SELECT statement. You can therefore use very powerful filter expressions in your DataView.

Chủ đề:

Bình luận(0) Đăng nhập để gửi bình luận!

Lưu

Nội dung Text: Performing Advanced Filtering

Performing Advanced Filtering The RowFilter property of a DataView is similar to a WHERE clause in a SELECT statement. You can therefore use very powerful filter expressions in your DataView. For example, you can use AND, OR, NOT, IN, LIKE, comparison operators, arithmetic operators, wildcard characters (* and %), and aggregate functions. Note For full details on how to use such filter expressions in your DataView objects, refer to the DataColumn .Expression property in the .NET online documentation. Here's a simple example that uses the LIKE operator and the percent (%) wildcard character to filter rows with a CustomerName that starts with Fr: string filterExpression = "CompanyName LIKE 'Fr%'"; customersDV.RowFilter = filterExpression; Notice that the string Fr% is placed in single quotes-which you must do for all string literals. When this code replaces the existing code in the UsingDataView.cs program shown earlier in Listing 13.1, the output is as follows: FRANK Frankenversand Germany FRANR France restauration France FRANS Franchi S.p.A. Italy Note I've made this change in the UsingDataView2.cs program (the listing is omitted from this book for brevity). Feel free to examine and run this program.