Bug-Tracking Application Using what you have learned about databases, ASP.NET co

Question

Bug-Tracking Application

Using what you have learned about databases, ASP.NET controls, CSS styles, and master-

detail pages, create an application that helps a development team track software

bugs. Use the SQL Server database file BugTrack.mdf, located in the chapter examples

folder. Study the database structure and match the data in the tables to the screen images

shown in this description.

When the application runs, as shown in Figure 10-57, the master page displays the bar

along the top and the menu on the left. The content area with the program title is supplied

by a page named About.aspx. It is the same page displayed when the user clicks

the About menu item on the left. The content area on the bottom is a GridView control

located directly in the master page.

Figure 10-58 shows the master page in Design view. The ContentPlaceHolder at the bottom

of the page contains a GridView control that displays default content. In other

words, when the user navigates to the content pages, the contents of the lower ContentPlaceHolder

(Latest Bug Reports) stay the same.

When the user selects View all from the menu, the upper pane displays a list of all bug

reports, as shown in Figure 10-59. When the user chooses Select by category from the

menu, the upper content pane displays a list of categories, as shown in Figure 10-60.

When the user selects a category and clicks the Go button, the upper grid displays a list

of matching bug reports.

This is more information about ealier question, I need help to create this.

Explanation / Answer

To Answer this question we need to Write DAO's and W need to Design the each Page and you need to Maintain Database also

For this you need to take One Global Method Clled BindGridView();

//Place this Method in Page Load 10.58 Picture Page

protected void BindGridview()

{

DataSet ds = new DataSet();

using (SqlConnection con = new SqlConnection("Data Source=***;Integrated Security=true;Initial Catalog=***"))

{

con.Open();

SqlCommand cmd = new SqlCommand("select * from TableName", con);

SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(ds);

con.Close();

gvDetails.DataSource = ds;

gvDetails.DataBind();

}

//If You click on Search by category

protected void BindGridview()

{

DataSet ds = new DataSet();

using (SqlConnection con = new SqlConnection("Data Source=***;Integrated Security=true;Initial Catalog=***"))

{

con.Open();

SqlCommand cmd = new SqlCommand("select * from TableName where Cateory='"+CatID+""", con);    //Here CatID Means thw value which is selected in drop downlist

SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(ds);

con.Close();

gvDetails.DataSource = ds;

gvDetails.DataBind();

}

//For Getting the Latest Bugs Details

protected void BindGridview()

{

DataSet ds = new DataSet();

using (SqlConnection con = new SqlConnection("Data Source=***;Integrated Security=true;Initial Catalog=***"))

{

con.Open();

SqlCommand cmd = new SqlCommand("select top 5 * from TableName order by Entrydate Desc", con);

SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(ds);

con.Close();

gvDetails.DataSource = ds;

gvDetails.DataBind();

}

For Displaying the Time Above The Page You need to The As Following:

In Master Page Place One Label and Give the ID as lblTime

Now Go to the each Page And In Each Page Find the You need to Place Following Code

Label lbl=(Label)Master.FindControl("lblTime");

lbl.Text=DateTime.Now.Date(); //By this You Can Get The Date in each Page Header Part if You applied the Master Page

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.