Let the user select a date from a DateTimePicker control. The program must display the first and last names, the phone numbers, and dates joined of all members who have joined before a given date or members who have joined on or after that date

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

 

Form 1 - Let the user select a date from a DateTimePicker control. The program must display the first and last names, the phone numbers, and dates joined of all members who have joined before a given date or members who have joined on or after that date

 

Note: You should create 2 dbcontext objects and LINQ queries, use one for each type of search.

At runtime, when the user switches between the radio buttons, their event handlers can assign one of the two binding sources to the DataSource property of the DataGridView control.

Form2 - The ListBox control displays a list of member names.

When the user selects a name in the ListBox, the DataGridView control on the same form displays the payment date and amount of all payments made by the selected member.

 

You will need two LINQ queries:

1. The first one selects ID and (Last_Name + ‘,’ + First_Name) from the Members table, ordered by Last_Name.
2. The second selects Member_Id, Payment_Date, and Amount from the Payments table listed in ascending order by Payment_Date.

The query returns payment rows that match a particular member ID value.

When the user selects a name from the ListBox, your event handler will obtain the SelectedValue property from the ListBox and assign its value to the query parameter for the query that fills the grid. In that way, the grid shows only payments by the selected member. In Design mode, when you bind the ListBox to the data source, be sure to assign ID to the ListBox’s ValueMember property.

Project 2 - Karate Member Dates  - Use DataSet and SQL

Form 1 - Let the user select a date from a DateTimePicker control. The program must display the first and last names, the phone numbers, and dates joined of all members who have joined before a given date or members who have joined on or after that date

 

Note: You should create two datasets, one for each type of search. After binding the grid to the first dataset, a component named MembersBindingSource is created. If you then bind the grid to the second dataset, a second component named Members-BindingSource1 is created.

At runtime, when the user switches between the radio buttons, their event handlers can assign one of the two binding sources to the DataSource property of the DataGridView control. That would be a good time to call the Fill method of the appropriate DataAdapter.

Form2 - add a new form that lets the user make modifications to the Payments table. The Details view works well for modifying the payments, but you also must add a DataGridView to the form that displays member names and ID numbers. This grid helps the user to associate member IDs with member names.

Form3 - The ListBox control displays a list of member names.

When the user selects a name in the ListBox, the DataGridView control on the same form displays the payment date and amount of all payments made by the selected member.

 

You will need two data sources for this form:

1. The first one selects ID and (Last_Name + ‘,’ + First_Name) from the Members table, ordered by Last_Name.
2. The second data source selects Member_Id, Payment_Date, and Amount from the Payments table listed in ascending order by Payment_Date. You will need to add a query to the TableAdapter of this dataset. The query returns payment rows that match a particular member ID value.

When the user selects a name from the ListBox, your event handler will obtain the SelectedValue property from the ListBox and assign its value to the query parameter for the query that fills the grid. In that way, the grid shows only payments by the selected member. In Design mode, when you bind the ListBox to the data source, be sure to assign ID to the ListBox’s ValueMember property.

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme