Question: I am programming a web application for my advanced programming class and I am having some trouble with this assignment. How do I create the

I am programming a web application for my advanced programming class and I am having some trouble with this assignment. How do I create the display that shows each bug that is updated. Any help would be appreciated. This is being programmed in Visual Studio and with C# coding.

Create a web application that will help a development team to keep track of software bugs. Please complete the following steps to accommodate all the features.

1. Download the BugTrack database from Moodle.

2. Create a new ASP.NET Empty Web project.

3. Create a folder called App_Data. Copy the downloaded database into this folder. (5 pts)

4. Create a master page named MasterPage.master (1pt)

5. The master page must have a heading at the top and also display the current date. (4 pts)

6. The master page must have a content placeholder. (2 pt)

7. The master page must have two links/buttons to navigate to each of the content pages. View All, Create New Bug (6 pts)

8. The master page must have a GridView at the bottom of the page that will persist on all the other content pages. This grid view should display the 3 most recent bugs from the list. This List should include the date created, description and the full name of the person the bug is assigned to. (You might have to join the bug entry table with FullName view) (15 pts)

9. Create a content page called ViewAll. (2 pts)

10. Make sure this page's title is set to View All. (2 pts)

11. Add a GridView to this page to display a list of all the bugs. Make sure to have pagination and sorting enabled. (10 pts)

12. Create a content page named NewBug. (2 pts)

13. Set the title of this page to Create New Bug (2 pts)

14. Add appropriate fields to this page to allow the user to add a new bug to the bugEntry table. Follow below guidelines for this page:

14a. Provide a drop-down field for created_by column. (look up data from FullName view) (5pts)

14b. Provide a drop-down field for Category column. (lookup data from the category table) (5pts)

14c. Provide a drop down field for Status Column (lookup data from the status table)) (5pts)

14d. Use a textbox for description field. (Add a required field validator for this field) (5pts) Make sure to add this to web.config for validation to work:

14e. Use a multiline text box for details. (2pts)

14f. You can use a SqlDataSource control to generate the appropriate insert command.

Once you create the SqlDataSource, you can go to the properties of the control and click on the InsertQuery. You should be able to use getDate() as the value for the[whencreated] column. You can also bound every column to a control you created on the form. Once you set everything up. You can add a button and the click handler for the button will actually add the record in the database by calling the insert method of the SqlDataSource. (15 pts)

if (sqlDatasource1.Insert()>0)

{

lblMessage.Text = "Success!";

}

15. Make sure that the buttons on your master page View All and Create New Bug open the appropriate pages. (5 pts)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!