I have an ASPX page that is retrieving data from a database using the following;
<script language="VB" runat="server">
Dim oDR as System.Data.SQLClient.SQLDataReader
Dim oCom As System.Data.SQLClient.SqlCommand
Dim oConn as System.Data.SQLClient.SQLConnection
oConn = New System.Data.SQLClient.SQLConnection ("server=ServerName; initial catalog=DATABASE;uid=USERID;pwd=PASSWORD")
oCom = New System.Data.SQLClient.SqlCommand()
oCom.Connection = oConn
oCom.CommandText = "SELECT department, count(emp_no) as count, Round(sum(fte),2) as fte FROM Dashboard_CurrentStaff group by department order by department "
oDR = oCom.ExecuteReader()
Response.Write("Error:" & err.Description)
oDR = Nothing
oCom = Nothing
oConn = Nothing
This shows a simple table with 5 departments, the number of people and the sum of the fte for each department.
I would love to create a chart to represent this but i simply cannot understand what I'm reading online. I don't need anything fancy, just a simple starting point.
Can someone help me to build a chart to display on this page?