Multiple choice technology programming languages

You use Visual Studio .NET to develop a Windows-based application called ABCApp. Your application will display customer order information from a Microsoft SQL Server database. The orders will be displayed on a Windows Form in a data grid named DataGrid1. DataGrid1 is bound to a DataView object. The Windows Form includes a button control named displayBackOrder. When users click this button, DataGrid1 must display only customer orders whose BackOrder value is set to True. How should you implement this functionality?

  1. Set the RowFilter property of the DataView object to "BackOrder = True".

  2. Set the RowStateFilter property of the DataView object to "BackOrder = True".

  3. Set the Sort property of the DataView object to "BackOrder = True".

  4. Set the ApplyDefaultSort property of the DataView object to True.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The RowFilter property accepts a filter expression and controls which rows are visible in the DataView. Setting RowFilter to "BackOrder = True" will show only backordered items. RowStateFilter filters based on row state (Added, Modified, Deleted, etc.) not data values. Sort is for ordering, not filtering. ApplyDefaultSort controls default sorting behavior. RowFilter is specifically designed for filtering data based on column values.

Keep practicing — related questions