1
DataView.RowFilter 属性
2
3 获取或设置用于筛选在 DataView 中查看哪些行的表达式。
4 命名空间:System.Data
5
6 程序集:System.Data(在 system.data.dll 中)
7 语法
8
9 Visual Basic(声明)
10
11 Public Overridable Property RowFilter As
12 String
13
14
15 Visual Basic(用法)
16
17 Dim instance As DataView
18
19 Dim value As String
20 value = instance.RowFilter
21 instance.RowFilter = value
22
23
24 C#
25
26 public virtual string RowFilter { get ; set ; }
27 JScript
28
29 public function get RowFilter () : String
30 public function set RowFilter (value : String)
31
32 属性值
33
34 用于指定行的筛选方式的字符串。有关更多信息,请参见备注部分。
35
36 备注
37
38 若要形成 RowFilter 值,请指定列的名称,后跟一个运算符和一个要筛选的值。该值必须用引号括起来。例如:
39 " LastName = 'Smith' "
40 有关更多信息,请参见 DataColumn 类的 Expression 属性。
41 若要只返回那些具有空值的列,请使用以下表达式:
42 " Isnull(Col1,'Null Column') = 'Null Column' "
43 示例
44
45 下面的示例创建 DataView 并设置它的 RowFilter 属性。
46 Visual Basic 复制代码
47
48 Private Sub MakeDataView()
49
50 Dim view As DataView = New DataView
51
52 With view
53
54 .Table = DataSet1.Tables( " Suppliers " )
55
56 .AllowDelete = True
57
58 .AllowEdit = True
59
60 .AllowNew = True
61
62 .RowFilter = " City = 'Berlin' "
63
64 .RowStateFilter = DataViewRowState.ModifiedCurrent
65
66 .Sort = " CompanyName DESC "
67
68 End With
69
70
71
72 ' Simple-bind to a TextBox control
73
74 Text1.DataBindings.Add( " Text " , view, " CompanyName " )
75
76 End Sub
77
78
79 C# 复制代码
80
81 private void MakeDataView()
82
83 {
84
85 DataView view = new DataView();
86 view.Table = DataSet1.Tables[ " Suppliers " ];
87
88 view.AllowDelete = true ;
89
90 view.AllowEdit = true ;
91
92 view.AllowNew = true ;
93
94 view.RowFilter = " City = 'Berlin' " ;
95
96 view.RowStateFilter = DataViewRowState.ModifiedCurrent;
97
98 view.Sort = " CompanyName DESC " ;
99 // Simple-bind to a TextBox control
100
101 Text1.DataBindings.Add( " Text " , view, " CompanyName " );
102
103 }
104
2
3 获取或设置用于筛选在 DataView 中查看哪些行的表达式。
4 命名空间:System.Data
5
6 程序集:System.Data(在 system.data.dll 中)
7 语法
8
9 Visual Basic(声明)
10
11 Public Overridable Property RowFilter As
12 String
13
14
15 Visual Basic(用法)
16
17 Dim instance As DataView
18
19 Dim value As String
20 value = instance.RowFilter
21 instance.RowFilter = value
22
23
24 C#
25
26 public virtual string RowFilter { get ; set ; }
27 JScript
28
29 public function get RowFilter () : String
30 public function set RowFilter (value : String)
31
32 属性值
33
34 用于指定行的筛选方式的字符串。有关更多信息,请参见备注部分。
35
36 备注
37
38 若要形成 RowFilter 值,请指定列的名称,后跟一个运算符和一个要筛选的值。该值必须用引号括起来。例如:
39 " LastName = 'Smith' "
40 有关更多信息,请参见 DataColumn 类的 Expression 属性。
41 若要只返回那些具有空值的列,请使用以下表达式:
42 " Isnull(Col1,'Null Column') = 'Null Column' "
43 示例
44
45 下面的示例创建 DataView 并设置它的 RowFilter 属性。
46 Visual Basic 复制代码
47
48 Private Sub MakeDataView()
49
50 Dim view As DataView = New DataView
51
52 With view
53
54 .Table = DataSet1.Tables( " Suppliers " )
55
56 .AllowDelete = True
57
58 .AllowEdit = True
59
60 .AllowNew = True
61
62 .RowFilter = " City = 'Berlin' "
63
64 .RowStateFilter = DataViewRowState.ModifiedCurrent
65
66 .Sort = " CompanyName DESC "
67
68 End With
69
70
71
72 ' Simple-bind to a TextBox control
73
74 Text1.DataBindings.Add( " Text " , view, " CompanyName " )
75
76 End Sub
77
78
79 C# 复制代码
80
81 private void MakeDataView()
82
83 {
84
85 DataView view = new DataView();
86 view.Table = DataSet1.Tables[ " Suppliers " ];
87
88 view.AllowDelete = true ;
89
90 view.AllowEdit = true ;
91
92 view.AllowNew = true ;
93
94 view.RowFilter = " City = 'Berlin' " ;
95
96 view.RowStateFilter = DataViewRowState.ModifiedCurrent;
97
98 view.Sort = " CompanyName DESC " ;
99 // Simple-bind to a TextBox control
100
101 Text1.DataBindings.Add( " Text " , view, " CompanyName " );
102
103 }
104