Homework 6 Submission: This is an individual homework assignment. Compress your complete VB project folder into a .zip file. The file name should have the format: 6_LastName_F.zip. Upload the .zip file to our homework submission site.

You will develop MyBroker v3.0 using a typed DataSet and LINQ queries.

Database File: Please use the StocksDB database file that I posted for Homework 5.

Alternatively, you can use your own database provided that the database design is correct.

Typed DataSet: Develop a typed DataSet application using the Drag-N-Drop technique.

(100 Points)

• Use the Drag-N-Drop technique to develop this application, which is used to browse, add, modify, delete, and save stock trading request records. The user interface, after applying the Drag-N-Drop technique, should look like the following screenshot. Please make sure that the three ComboBox Controls are used to display the stock ticker value, order type value, and request status value, respectively. You should drag the TradingRequests DataTable and drop it on the form. Do NOT drag individual fields from different DataTable (25 Points)

• Modify the data binding settings of the first ComboBox control showing stock ticker symbol. Instead of showing ticker symbol, the ComboBox controls should display the corresponding companys full name for the users convenience. (25 Points)

Parameterized Query: Create a parameterized query so that the user can search for trading requests by order type. The ability to conduct a partial search is not necessary. (10 Points)

• LINQ Query 1: Add a search TextBox, a search ToolStripButton, and a reset ToolStripButton on the BindingNavigator You should assign an appropriate icon image to each of the ToolStripButton objects. The user can use these newly created objects to search trading request records by ticker symbol. The user types a ticker symbol in the search TextBox. When the user clicks the search ToolStripButton, your program should use a LINQ query to search those trading requests made for the specified ticker symbol. When the user clicks the reset Button, your program should reset the search result to display all trading requests. (20 Points)

• LINQ Query 2: For the stock ticker currently selected in the company ComboBox control, create LINQ queries to display the total stock quantity of BUY tradining requests and total stock quantity of SELL tradining requests. Display both quantities on the user form by placing more Windows controls (e.g., TextBox and Label controls). (20 Points)