plotting graph using ASP or VB script ? - ASP / Active Server Pages

Does any one know how to plot this kind of graph ? Go to this kind to see the graph?

http://www.ekopower.nl/index.htm

Help...help me !

Sep 8 '08 #1

Subscribe Post Reply

4901

DrBunchman

979

Expert 512MB

Hi Ugene,

Welcome to Bytes.com! Any of these any good to you?

Dr B

Sep 9 '08 #2

Ugene

hey DrBunchman ...thanks alot...this is a great site..

Sep 9 '08 #3

Ugene

hey DrBunchman but i wanted to change my graph from histogram/bar graph to the zig-zag kind of graph...i find mostly is pie charts..how ?

Sep 9 '08 #4

DrBunchman

979

Expert 512MB

How about this line graph example? Is that what you wanted?

Dr B

Sep 9 '08 #5

Ugene

Yes ! but i want to hardcode my figure in ..can i ?

Sep 10 '08 #6

Ugene

I tried by copying the database and the source code into the server side so then from the client side i unable to process the graph i saw it on the link u gave me ...how come ? Is it i have to change to file name and path and so on ?

Sep 10 '08 #7

Ugene

after i tried changing the path and stuff i only can get the graph by hardcoding the data..so i cannot get the data thru connecting the database given ..

but now i want to let it read the data from a excel file..how to read it ?how to set the connection ?

Sep 10 '08 #8

Ugene

hey DrBunchman do u know how to set the connection to read the figures on microsoft excel?i am able to set the and see the graph only when i hardcode in the figure...help !

Sep 12 '08 #9

DrBunchman

979

Expert 512MB

Hi Ugene,

What code have you got so far? I presume that it is possible to use these graph objects with a connection so it's probably just a case of getting it set up correctly.

Dr B

Sep 12 '08 #10

Ugene

hi DrBunchman,i currently have these codes
---------------------------------------------------------------------------------------------------------------

Expand|Select|Wrap|Line Numbers

 <!doctype html public "-//w3c//dtd html 4.0 transitional//en">
 
<%@ Language=VBScript %>

<%

' Set Connection Params

Set oConn = Server.CreateObject("ADODB.connection")

oConn.Open "Driver={Microsoft Excel Driver (*.xls)}; DriverId=790;" &_

"DBQ=C:\Inetpub\wwwroot\InfoWeb\14Apr08_NUS_hr_Data.xls;" &_

"DefaultDir = C:\Inetpub\wwwroot\InfoWeb\"
 
Set RS=Server.CreateObject("ADODB.recordset")
 
 ' Write the SQL Query
 
RS.open "SELECT * FROM my_range", oConn
 
do until RS.EOF

Response.Write ( RS("Item No") & " -- " & RS("Item Description") & "<br>")

RS.movenext

Loop
 
'Close the recordset/connection
 
RS.Close

oConn.Close

Set RS = Nothing

%>
 
<html>

<head>

    <title>Pressure Chart</title>

</head>

<body>
 
<applet codebase="new" code="linegraph.class" height=220 width=360>

    <param name="title" value="Sales">

    <param name="NumberOfVals" value="<%=sqlQuery.RecordCount%>">

    <param name="NumberOfLabs" value="<%=sqlQuery.RecordCount%>">

    <PARAM NAME=ymax VALUE=<%=(Fix(sqlQuery("M")/10000)+1)*10000%>>

    <PARAM NAME=ymin VALUE=0>

    <PARAM NAME=mode VALUE=0>

    <PARAM NAME=border VALUE="20">    <PARAM NAME=Grid VALUE="true">

    <PARAM NAME=LineColor_R_L1 VALUE=53>

    <PARAM NAME=LineColor_G_L1 VALUE=153>

    <PARAM NAME=LineColor_B_L1 VALUE=51>    

<%

i = 1

while (not sqlQuery.EOF) %>

    <param name="VAL<%=i%>_L1" value="<%=sqlQuery("SalesTotal")%>">

    <param name="LAB<%=i%>" value="<%=MonthName(Month(sqlQuery("Date")))%>">

<%

i = i + 1

sqlQuery.MoveNext

wend %>
 
</APPLET><p>
 
</body>

</html>

-------------------------------------------------------------------------------------------------------
So how do i set my range which i underline? there are error in the codes could you point out to me ?

this is the error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'

[Microsoft][ODBC Excel Driver] The Microsoft Jet database engine could not find the object 'my_range'. Make sure the object exists and that you spell its name and the path name correctly.

/Infoweb/pressure.asp, line 15

Sep 18 '08 #11

Ugene

hey DrBunchman..

Now i have got the connection correct..and now its able to display the data in the excel file on a browser in a table form..so now i have to plot it i alraedy got the applet working but now is how to get the connect between the applet with the data ?

below is the correct data for the connection between excel and ASP..so if any 1 need it can play around with it..

This is the working code between my ASP and excel..
------------------------------------------------------------------------------------------------------------

Expand|Select|Wrap|Line Numbers

 <% Option Explicit %>

<html>

<body>
 
<%

Dim objConn, objRS, strSQL

Dim x, curValue
 
Set objConn = Server.CreateObject("ADODB.Connection")

objConn.Open "DRIVER={Microsoft Excel Driver (*.xls)}; IMEX=1; HDR=NO; "&_

    "DBQ=C:\Inetpub\wwwroot\InfoWeb\14Apr08_NUS_hr_Data.xls;"
 
strSQL = "SELECT * FROM D1:D170"

Set objRS=objConn.Execute(strSQL)

Response.Write("<table border=""1"">")

Response.Write("<tr>")

For x=0 To objRS.Fields.Count-1

   Response.Write("<th>" & objRS.Fields(x).Name & "</th>")

Next

Response.Write("</tr>")

Do Until objRS.EOF

    Response.Write("<tr>")

    For x=0 To objRS.Fields.Count-1

        curValue = objRS.Fields(x).Value

        If IsNull(curValue) Then

            curValue="N/A"

        End If

        curValue = CStr(curValue)

        Response.Write("<td>" & curValue & "</td>")

    Next

    Response.Write("</tr>")

    objRS.MoveNext

Loop

objRS.Close

Response.Write("</table>")
 
objConn.Close

Set objRS=Nothing

Set objConn=Nothing

%>
 
</body>

</html>

--------------------------------------------------------------------------

Below is the code of applet to plot the graph how to connect it?
that is a hardcoded in the applet.how to use this graph with the data displayed?
hope u could help me .
-------------------------------------------------------------------------

Expand|Select|Wrap|Line Numbers

 <APPLET CODE="linegraph.class" HEIGHT=220 WIDTH=360>

<PARAM NAME=NumberOfVals VALUE=36>

<PARAM NAME=NumberOfLabs VALUE=4>

<PARAM NAME=KeyWidth VALUE=70>
 
<PARAM NAME=LineColor_R_L1 VALUE=0>

<PARAM NAME=LineColor_G_L1 VALUE=0>

<PARAM NAME=LineColor_B_L1 VALUE=200>
 
<PARAM NAME=LineColor_R_L2 VALUE=200>

<PARAM NAME=LineColor_G_L2 VALUE=0>

<PARAM NAME=LineColor_B_L2 VALUE=0>
 
<PARAM NAME=yMax VALUE=30>

<PARAM NAME=yMin VALUE=-10>

<PARAM NAME=Mode VALUE=0>

<PARAM NAME=Lines VALUE=2>

<PARAM NAME=Title VALUE="NET PROFIT (K$)">

<PARAM NAME=Border VALUE="30">

<PARAM NAME=Grid VALUE="true">
 
<PARAM NAME=VAL1_L1 VALUE=10.3>

<PARAM NAME=VAL2_L1 VALUE=11.0>

<PARAM NAME=VAL3_L1 VALUE=14.5>

<PARAM NAME=VAL4_L1 VALUE=12.20>

<PARAM NAME=VAL5_L1 VALUE=15.0>

<PARAM NAME=VAL6_L1 VALUE=12.5>

<PARAM NAME=VAL7_L1 VALUE=20.5>

<PARAM NAME=VAL8_L1 VALUE=22.5>

<PARAM NAME=VAL9_L1 VALUE=18.8>

<PARAM NAME=VAL10_L1 VALUE=24>

<PARAM NAME=VAL11_L1 VALUE=27.8>

<PARAM NAME=VAL12_L1 VALUE=29>

<PARAM NAME=VAL13_L1 VALUE=26.9>

<PARAM NAME=VAL14_L1 VALUE=22.4>

<PARAM NAME=VAL15_L1 VALUE=18.0>

<PARAM NAME=VAL16_L1 VALUE=14.8>

<PARAM NAME=VAL17_L1 VALUE=7.5>

<PARAM NAME=VAL18_L1 VALUE=3.2>

<PARAM NAME=VAL19_L1 VALUE=-4.6>

<PARAM NAME=VAL20_L1 VALUE=-2.0>

<PARAM NAME=VAL21_L1 VALUE=1.8>

<PARAM NAME=VAL22_L1 VALUE=2.5>

<PARAM NAME=VAL23_L1 VALUE=-1.1>

<PARAM NAME=VAL24_L1 VALUE=2.5>

<PARAM NAME=VAL25_L1 VALUE=11.9>

<PARAM NAME=VAL26_L1 VALUE=16.6>

<PARAM NAME=VAL27_L1 VALUE=12.6>

<PARAM NAME=VAL28_L1 VALUE=18.7>

<PARAM NAME=VAL29_L1 VALUE=23.9>

<PARAM NAME=VAL30_L1 VALUE=19.9>

<PARAM NAME=VAL31_L1 VALUE=19.5>

<PARAM NAME=VAL32_L1 VALUE=23.5>

<PARAM NAME=VAL33_L1 VALUE=19.0>

<PARAM NAME=VAL34_L1 VALUE=22.5>

<PARAM NAME=VAL35_L1 VALUE=22.9>

<PARAM NAME=VAL36_L1 VALUE=24.6>
 
<PARAM NAME=VAL1_L2 VALUE=14.3>

<PARAM NAME=VAL2_L2 VALUE=12.0>

<PARAM NAME=VAL3_L2 VALUE=11.5>

<PARAM NAME=VAL4_L2 VALUE=17.20>

<PARAM NAME=VAL5_L2 VALUE=12.0>

<PARAM NAME=VAL6_L2 VALUE=13.5>

<PARAM NAME=VAL7_L2 VALUE=25.5>

<PARAM NAME=VAL8_L2 VALUE=21.5>

<PARAM NAME=VAL9_L2 VALUE=11.8>

<PARAM NAME=VAL10_L2 VALUE=14>

<PARAM NAME=VAL11_L2 VALUE=17.8>

<PARAM NAME=VAL12_L2 VALUE=19>

<PARAM NAME=VAL13_L2 VALUE=16.9>

<PARAM NAME=VAL14_L2 VALUE=22.4>

<PARAM NAME=VAL15_L2 VALUE=28.0>

<PARAM NAME=VAL16_L2 VALUE=24.8>

<PARAM NAME=VAL17_L2 VALUE=9.5>

<PARAM NAME=VAL18_L2 VALUE=6.2>

<PARAM NAME=VAL19_L2 VALUE=4.6>

<PARAM NAME=VAL20_L2 VALUE=12.0>

<PARAM NAME=VAL21_L2 VALUE=8.8>

<PARAM NAME=VAL22_L2 VALUE=9.5>

<PARAM NAME=VAL23_L2 VALUE=11.1>

<PARAM NAME=VAL24_L2 VALUE=7.5>

<PARAM NAME=VAL25_L2 VALUE=14.9>

<PARAM NAME=VAL26_L2 VALUE=15.6>

<PARAM NAME=VAL27_L2 VALUE=16.6>

<PARAM NAME=VAL28_L2 VALUE=11.7>

<PARAM NAME=VAL29_L2 VALUE=21.9>

<PARAM NAME=VAL30_L2 VALUE=16.9>

<PARAM NAME=VAL31_L2 VALUE=13.5>

<PARAM NAME=VAL32_L2 VALUE=25.5>

<PARAM NAME=VAL33_L2 VALUE=19.9>

<PARAM NAME=VAL34_L2 VALUE=22.9>

<PARAM NAME=VAL35_L2 VALUE=22.1>

<PARAM NAME=VAL36_L2 VALUE=24.1>
 
<PARAM NAME=LAB1 VALUE="1999">

<PARAM NAME=LAB2 VALUE="2000">

<PARAM NAME=LAB3 VALUE="2001">

<PARAM NAME=LAB4 VALUE="2002">
 
<PARAM NAME=Key_L1 VALUE="ABC Corp">

<PARAM NAME=Key_L2 VALUE="XYZ Corp">
 
</APPLET>

-----------------------------------------------------------------------

Sep 23 '08 #12

Ugene

hey DrBunchman,

did u miss my post?

Sep 29 '08 #13

DrBunchman

979

Expert 512MB

Hi Ugene,

I've not used an applet like this before but I presume that you can build the applet dynamically using your asp code the same way that you have built a table from quering the excel spreadsheet.

Does this make sense?

Dr B

Sep 29 '08 #14

Ugene

DrBunchman ,

It sounds logical..to display in a table form is via <tr> & <td>. So what are the tags to display it into a line graph? It would be much easier as i don't have to pass it to another method. But do u konw how to go about doing this way ?

Sep 30 '08 #15

DrBunchman

979

Expert 512MB

You have the tags already in your applet example.....rather than using <tr> & <td> you could maybe build the applet tags (e.g. <param />) using the server side code.

I don't know if this is actually possible - any other experts got any experience with this?

Dr B

Sep 30 '08 #16

Ugene

hey DrBunchman ,
i manage to get the code out after playing around with it..thanks so much for the help and advise you gave me ! you have been a great help..

Oct 2 '08 #17

DrBunchman

979

Expert 512MB

Hey Ugene, I'm really pleased to hear you got it working. Perhaps you could let us know how you did it in case anyone else has a similar problem?

Thanks

Dr B

Oct 3 '08 #18

Ugene

This is the final code which able to let user retrieve data from selected range of the excel file and plot it on a line graph. its here for any 1 that need :)

Expand|Select|Wrap|Line Numbers

 <% Option Explicit %>

<html>

<HEAD><TITLE>Line Graph Of Wind Speed</TITLE></HEAD>

<body>
 
<APPLET CODE="linegraph.class" HEIGHT=400 WIDTH=900>
 
<%

Dim objConn, objRS, strSQL

Dim x, i, curValue
 
Set objConn = Server.CreateObject("ADODB.Connection")

objConn.Open "DRIVER={Microsoft Excel Driver (*.xls)}; IMEX=1; HDR=NO; "&_

    "DBQ=C:\Inetpub\wwwroot\InfoWeb\14Apr08_NUS_hr_Data.xls;"
 
%>
 
<PARAM NAME=NumberOfVals VALUE="24">

<PARAM NAME=NumberOfLabs VALUE="24">
 
<PARAM NAME=LineColor_R_L1 VALUE=0>

<PARAM NAME=LineColor_G_L1 VALUE=0>

<PARAM NAME=LineColor_B_L1 VALUE=255>
 
<PARAM NAME=ymax VALUE=4>

<PARAM NAME=ymin VALUE=0>

<PARAM NAME="lines" VALUE=10>

<PARAM NAME="borderright" VALUE=20>

<PARAM NAME="borderleft" VALUE=30>

<PARAM NAME="bordertop" VALUE=20>

<PARAM NAME="borderbase" VALUE=20>

<PARAM NAME="bg_r" VALUE=220>

<PARAM NAME="bg_g" VALUE=240>

<PARAM NAME="bg_b" VALUE=255>

<PARAM NAME="border_r" VALUE=100>

<PARAM NAME="border_g" VALUE=100>

<PARAM NAME="border_b" VALUE=250>

<PARAM NAME="linewidth" VALUE=2>

<PARAM NAME="showpoints" VALUE=1>

<PARAM NAME=fontsize VALUE=13>

<PARAM NAME=Title VALUE="Wind Speed (m/s)">

<PARAM NAME=Border VALUE="30">

<PARAM NAME=Grid VALUE="true">
 
<PARAM NAME=LAB1 VALUE="0100">

<PARAM NAME=LAB2 VALUE="0200">

<PARAM NAME=LAB3 VALUE="0300">

<PARAM NAME=LAB4 VALUE="0400">

<PARAM NAME=LAB5 VALUE="0500">

<PARAM NAME=LAB6 VALUE="0600">

<PARAM NAME=LAB7 VALUE="0700">

<PARAM NAME=LAB8 VALUE="0800">

<PARAM NAME=LAB9 VALUE="0900">

<PARAM NAME=LAB10 VALUE="1000">

<PARAM NAME=LAB11 VALUE="1100">

<PARAM NAME=LAB12 VALUE="1200">

<PARAM NAME=LAB13 VALUE="1300">

<PARAM NAME=LAB14 VALUE="1400">

<PARAM NAME=LAB15 VALUE="1500">

<PARAM NAME=LAB16 VALUE="1600">

<PARAM NAME=LAB17 VALUE="1700">

<PARAM NAME=LAB18 VALUE="1800">

<PARAM NAME=LAB19 VALUE="1900">

<PARAM NAME=LAB20 VALUE="2000">

<PARAM NAME=LAB21 VALUE="2100">

<PARAM NAME=LAB22 VALUE="2200">

<PARAM NAME=LAB23 VALUE="2300">

<PARAM NAME=LAB24 VALUE="0000">
 
<%

strSQL = "SELECT * FROM G2:G26"

Set objRS=objConn.Execute(strSQL)
 
i=1

Do Until objRS.EOF
 
    For x=0 To objRS.Fields.Count-1

%>        

    <PARAM NAME="VAL<%=i%>_L1" VALUE="<%=objRS.Fields(x).Value%>">

<%    Next

    i = i + 1

    objRS.MoveNext

Loop

objRS.Close

%>
 
<%

objConn.Close

Set objRS=Nothing

Set objConn=Nothing

%>
 
</APPLET>
 
</body>

</html>

Oct 7 '08 #19

Similar topics

HELP: cpu load graph plotting program

by: KevinGPO | last post by:

I am making a monitor program for the PC. My monitor program will grab statistics about CPU and memory every 1 or 5 seconds. Then I want to store this data so I have a history and hence be able to...

C / C++

Options for real-time plotting of server-side data?

by: Russ | last post by:

I'm interested in setting up a web page where live data can be displayed in real-time on the web page. For example: I would like to display a (nice looking) graph of some data value versus time...

HTML / CSS

Plotting Graph in C

by: Chapman | last post by:

Is it possible to plot the graph as an output of my program in C? It can be a simple graph as quadratic curves for example or a correlation between 2 variables only. Thanks

C / C++

graph plotting

by: wayne | last post by:

i want to plot a line graph. The values that I obtain are the RGB value of a TIFF image. i m plotting RGB values vs value(1,2,3..) so when generated the RGB values, there will b a column of values...

.NET Framework

Plotting a graph using an array of relatively linked nodes

by: i | last post by:

Hi, I'm working with an array of nodes, numbering roughly in the thousands. Each node has at least one, but up to four, references to another node - North, South, East, or West. I'm trying to...

C# / C Sharp

Automated Graph Plotting in Python

by: diffuser78 | last post by:

My python program spits lot of data. I take that data and plot graphs using OfficeOrg spredsheet. I want to automate this task as this takes so much of time. I have some questions. 1. Which is...

Python

Plotting a thumbnail of line graph

by: Gouri | last post by:

Hi, Got a query regarding plotting a preview / thumbnail for a graph which reads data from a binary file. The preview should should take very less time, look exactly like the original graph i.e....

C# / C Sharp

Plotting Graph in C++

by: 9966 | last post by:

Greetings, I'm currently having problem in plotting a simple graph in C++. I learned that we can actually use koolplot to do it. My question is whether it is possible to plot, let's say the...

C / C++

matplotlib: Plotting a graph against time

by: Durand | last post by:

Hi, I'm trying to plot a simple graph against date or time using matplotlib. I've read about date_plot but I'm not really sure how to use it. At the moment, I have some data arranged into lists,...

Python

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General