Simulating a Bar Graph Using Simple HTML and a DataSet...
发表于2004/10/6 19:57:00 701人阅读
You may have seen web pages that include a horizontal bar graph showing responses to a questionaire or other numeric results without the use of a graphing tool. This article will demonstrate how to build such a graph using html and a dataset.
By: John Kilgo Date: July 28, 2003 Download the code. Printer Friendly Version
It really is not difficult to create a horizontal bar graph using an HTML table. All you need to do is compute a percentage of a total for each item and then set <td width= to the value of the percentage. Use a background color for the percentage and no color for the difference between 100 and value's percentage and you have your bar graph. In this example we will graph UnitsInStock from the Northwind Products table.
We will do all the computations in a code behind file (BarGraph.aspx.vb) which means we must also build our HTML in the code behind file. To accomodate this we include on a <div>...</div> in our .aspx file shown below. In our code behind file we will, at the end, set the InnerHtml property of the Div to produce all of the HTML for the .aspx page. The code for BarGraph.aspx is shown below without any further explanation.
|<%@ Page Language="vb" AutoEventWireup="false" Src="BarGraph.aspx.vb" Inherits="DotNetJohn.BarGraph"%>|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" content="Visual Basic .NET 7.1">
<meta name=vs_targetSchema content="http://schemas.microsoft.com/intellisense/ie5">
<form id="Form1" method="post" runat="server">
<div id="ShowTable" runat="server">Our table appears here</div>
To make our graph a little more interesting we will color code the bars. We will (arbitrarily) set 125 as the maximum UnitsInStock for any product and base our percentage on it. In other words, if there 25 units in stock of a certain product, the colored <td> will have a width of 20% (25 / 125) * 100. Any product with a percentage of less than 20% will be colored red, products with percentages between 20% and 80% will be blue, and products with a percentage over 80% will be in green.
The code behind file is not very long but we will display it in three sections for ease of discussion. This first section is just the declarations and the database access to obtain the data and create the DataSet.
Public Class BarGraph
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim objConn As New SqlConnection(ConfigurationSettings.AppSettings("NorthwindConnection"))
Dim strSql As String = "Select ProductName, UnitsInStock From Products Order By ProductName"
Dim da As New SqlDataAdapter(strSql, objConn)
Dim ds As New DataSet()
This next section just establishes our html table and defines the table header.
Dim strHTML As String
strHTML = "<table width='80%' border='1'>"
strHTML &= "<tr>"
strHTML &= "<td>ProductName</td><td>Percentage of 125 | red <20% | blue 20-80% | green >80% |"
strHTML &= "</td><td>UnitsInStock</td>"
strHTML &= "</tr>"
This last section is where most of the work gets done to produce our bar graph. intValue is the percentage of the total (125) that gets plotted in color. intBlank is the right-most portion of the graph and is the difference between 100 and intValue. We then start the body of the table. The first <td> contains the product name. Within the the next <td> we have an embedded table containing intValue, color coded, and intBlank colorless. In that section of code we check the value of intValue. If it is less than 20 we color it red. If it is greater than 80 we color it green, otherwise we color it blue. We might want to do something like this to show that the red products need to be re-stocked and that the green items may be overstocked and we might want to hold a sale on these items. We then finish out the table with the actual UnitsInStock count (the actual count, not a percentage). Finally we set ShowTable's InnerHtml to the strHTML variable that we have built withing the code behind file. Remember that "ShowTable" was the ID we gave the <Div> tag on the .aspx page. We can do this because we included the runat="server" attribute in the <Div> tag on the .aspx page.
Dim dr As DataRow
Dim intValue, intBlank As Integer
For Each dr In ds.Tables("Products").Rows
intValue = 100 * (dr("UnitsInStock") / 125)
intBlank = 100 - intValue
strHTML &= "<tr><td width='30%'>" & dr("ProductName") & "</td>" & _
"<td width='60%'><table width='100%'><tr>"
If intValue < 20 Then
strHTML &= "<td width=" & intValue.ToString & "% bgcolor=red>"
ElseIF intValue > 80 Then
strHTML &= "<td width=" & intValue.ToString & "% bgcolor=green>"
strHTML &= "<td width=" & intValue.ToString & "% bgcolor=blue>"
strHTML &= " </td>" & _
"<td width=" & intBlank.ToString & "% </td>" & _
"</tr></table></td>" & _
"<td width=10%>" & dr("UnitsInStock").ToString & "</td></tr>"
strHTML &= "</table>"
ShowTable.InnerHtml = strHTML
I hope you have learned a new techinque you can put in you bag in case you need it in the future. You may also have learned something about cycling through a DataSet using the Rows collection. Best of luck.
Hadoop Streaming Made Simple using Joins and Keys with Python
jiedushi 2012-04-12 17:02 1068
A simple application using I/O Completion Ports and WinSock
weicaijiang 2017-08-24 13:55 0
Ajaxify a simple HTML page using a web service
jlkgis2008 2009-06-02 11:41 0
两个用C实现遗传算法的程序 an example of a very simple genetic algorithm in C and a GA implementation using binary and real coded variables
amu0421 2011-05-26 18:23 788
Real-Time Hair Simulating And Rendering
ems13579 2016-01-27 11:54 1369
Professional JS(13.4.7HTML5 /device/Touch/Gesture Event/Memory&Performance/Simulating Events/Canvas)
m0_37851778 2017-07-31 08:58 565
Build a Contacts Management App Using HTML5, JS, CSS3, and Wakanda Studio
napoleonjk 2014-08-05 15:30 1135
Preview Word files (docx) in HTML using ASP.NET, OpenXML and LINQ to XML
nowgoant 2011-06-10 22:20 876