Reference no: EM13947807
Create an MS Access database called MemberLedger.mdb. Add a table called Members with the following columns. (Already done, see attachment).
For clarification, the instructions for the assignment require the creation of the MemberLedger.mdb database. The database should be created and saved as an Access 2007 database with the .accdb extension. The AccessDataSource server control does not recognize the .accdb extension so a SqlDataSource server control must be used to connect to the database. The database must be placed in the App_Data folder in order to create a relative path to the database. A relative path should be used because a relative path will work on any computer. A relative path to the database uses the |DataDirectory| token which is used in the value assigned to the Data Source key in the ConnectionString. The relative path is easily created by selecting the name of the database in the dropdownlist when selecting "Which data connection should your application use to connect to the database?" in the data source configuration wizard.
MemberID - This is the Primary Key with a data type of AutoNumber
FirstName - Data type of Text
LastName - Data type of Text
Add at least 5 rows to this table to facilitate testing of the application.
Create a Visual Studio 2008 ASP .NET Web Site with three Web Forms. The name of your Web site should be based on your last name. For example, if your last name is Jones, then assign the name Jones_IP3.
The first Web Form is a login page that contains a Login server control. Users cannot view the second Web Form unless they have successfully logged onto the application. Authentication and authorization should be implemented in the web.config file to provide this functionality. Three sets of credentials should be added to the web.config file. One set of credentials must use Student as the user name and ITP450-IP3 as the password.
The second Web Form allows the user to view and edit the data in the database. Place a GridView server control on the Web Form and connect it to the database. Configure the GridView server control to allow the user to view the records in the database and to edit a member's data.
The third Web Form allows the user to page through the records in the database and add a record to the database. Place a FormView server control on the Web Form and connect it to the database. Configure the FormView server control to allow the user to page through the records in the database and to add a new record to the database.
Zip the Web Site folder that contains the files
Attachment:- MemberLedger.zip
|
How long it take to send the file from source to destination
: Suppose the network is a packet-switched datagram network, and a connectionless service is used. Now suppose each packet has 2h bits of header. How long does it take to send the packet?
|
|
Estimate the soil friction angle
: The ground- water table was located at a depth of 2 m below the ground surface. Given, for the sand: gd 5 14.5 kN/m3 and gsat 5 19.8 kN/m3. The contact stress during the test was 260 kN/m2. Estimate the soil friction angle, f9.
|
|
How does water change to steam
: As you have learned throughout the course, engaging young students in hands-on science experiments will enhance their knowledge in a fun and interesting way. These simple experiments will prepare them for more complex science experiences in the fut..
|
|
Graph that illustrates a recent change in law
: Write a 5-paragraph essay that introduces the topic you've chosen, summarizes the various points of view, and concludes with the current status of the issue you are addressing. Be sure to use at least 2 citations to support your essay.
|
|
Create an ms access database called memberledger.mdb
: Create an MS Access database called MemberLedger.mdb. Add a table called Members with the following columns. (Already done, see attachment).
|
|
Determine the variation of the relative density
: 1. Refer to Problem 3.19. Using Eq. (3.51), determine the variation of the relative density with depth. Use Qc 5 1.
|
|
Prepare a schedule of after-tax cash flows for manual system
: Prepare a schedule of after-tax cash flows for the manual and robotic systems. Should the company invest in the robotic system?
|
|
Explain and reason how tcp congestion control will react
: Explain and reason how TCP congestion control will react: for example, describe what transmission rate TCP would give each of the connections.
|
|
Estimate the average peak friction angle
: Assuming the dry unit weight of sand to be 16 kN/m3, estimate the average peak friction angle, f 9, of the sand. Use Eq. (3.53).
|