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.

Attachments:

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. 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. The LineItem class will represent an individual

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

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of