Chapter 14, Problem 8AW

Explanation of Solution

LINQ Queries with data-bound control:

A data-bound control is a user interface control which is connected to the database.

• The data from the data source is displayed automatically by data-bound controls and that can be used to change the data that they are bound to.
• DataGridView control is one of the most powerful and simplest data-bound controls.
• An entire database table can be displayed in DataGridView control as a scrollable grid on an application’s form.
• An application can be created which uses LINQ to query a database table and the query results of the LINQ query can be displayed in a DataGridView control.
• Using LINQ user can retrieve rows from a database table, in addition to that LINQ allows the user to update rows, insert rows, and delete rows.

LINQ to SQL query that returns the Trading_Symbol column only from the rows where Selling_Price is greater than Purchase_Price and Num_Shares is greater than 100:

Using multiple where clauses:

  var results = from stock in db...