I have a database that logs certain events on my simulation. I need to create a timeline using VB then get the events from the database and plot them according to the log time that is stored in the database.
eventually the timeline will contain all the events according to the log time in the database and they will have details on each time plot.
Any idea how to start? was looking at MSchart but not something that i have in mind.
First put the data from the database in an array.
With this data You can write the code for the visualization of Your own chart layout.
Some questions to start:
Q1 Is it possible to attach in Bytes a GIF file or screen capture (a simple sketch) of the layout You want to see so we can have an idea in which direction we have to think?
(I have attached an example created with Paint).
Q2 Is it possible to attach an example of the data ?
Is it text ? how much char's,...
Q3 Must all the data be visible at once or if the mouse moves over the data-points, ...?
I have googled and found nothing we can use.
To build a custom timeline is not such a big deal: analyze how You want it and calculate the points of the elements(lines, datalabels,...) .
I have done some brainstorming (maybe more storm than brains) but anyhow, we must start with some questions:
Q1: is it necessary to have a horizontal timeline?
Because a vertical one has better possibilities for setting the labels (see attached GIF).
Maybe no need to zoom to read the data?
Q2: How many datalines are there mostly in a timeline ? 10 ? 50 ? 100 ? 200 ?...
Q3: Are the coordinates of the timeline always the same:
From 8:00 to 17:00
Or are they fluctuating:
once 8:00 to 17:00
next 9:30 to 18:30
next 1:00 AM to 9:00 AM
next 22:00 to 7:00 AM next day ???
Q4: In the data, the time is represented by "8:01:050".
I suppose that 8= hours, 01 = minutes and 050 are thousands of seconds ???
Is it necessary the work with 1/1000 of a second ?
It can be set in the label but I suppose it's not relevant for the timeline?
Calculating the coordinates on hours and minutes will be enough ?
Q5: I have placed the data in a textfile for myself for developing and testing the program.
At startup I read the data in an array.
I suppose it's no problem for You to read the data from Your database into the array so we can work further in the program on the data in the array? (see attachment)
These are the first tests.
It's with a vertical scale but for a horizontal one it's only calculating the LEFT instead of the TOP of the elements.
The datalabels are still overlapping but with a zoom of the hole scale can solve that.
Whats Your suggestions and remarks ?
I have not really looked at your codes yet. appreciate your help =).
My way of doing:
its not efficient coding but i will just use it if it works.
i load my data into a sqlDataAdpater. Then create a panel to act as the timeline. i did a difference between the last time and the start time, then divide them by the width of the panel. now i will have the number of seconds represented by each pixel. so buy doing some calculation i draw my lines and plot the events on this time line.
still working on the zooming in of the information. will post some pics when available. Thanks once again.
No need to ZOOM (resize) the label!
Just use two labels: a label Minimum size with nothing in and a Label with all the data.
Just flip-Flop on "Visible" beween the two labels.
The user gets the impression that it zooms!
See attachment:
- Click on the labelData or LabelDataMin with the right mouse button to +zoom or -zoom.
- Click with Left mouse button on the full sized label (LabelData) and drag-drop it to replace the label.
I am trying to run this code on a Windows 2003 Server.
I have ASP enabled. Any idea why it doesn't work?
<%
newDB = "new.mdb"
newDB = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & newDB
Set cat = CreateObject("ADOX.Catalog")
cat.Create newDB
hello I was wondering if someone could help me get a main going on
this project I've completed the header file that the professor started
us on but not really sure how to get the main going. If someone could
please give me some pointers it would greatly be appreciated. Again
thanks for the help.
Henry
headerfile:
Hi Everyone.
Thanks for Help.
Simply I want to create a file saved in it information but in the same
time when anyone try to read this information couldn't understand the
contents of the file.
As an example: this is a contents of a file like the one I want.
"]eŒ: B$m{ڑG ً ے ے ZG
How can I get a program in vs.net, when a user makes selections then
clicks a button, to create a results page like one might get from
google.com, yahoo.com or an ebay search?
like this:
photo | something | and some detail.......
photo | something | and some detail.......
photo | something | and some detail.......
I'm looking to create my own bootable CD. What I'd like to have on this
bootable CD is all the major hard drive manufacture's diagnostic utilities.
I was wondering how hard of a programming project this would be? I just
want a basic interface after booting from a CD. Just something to select
whatever tool necessary, from there, have the program start.
What programming language would best suite this type of program? Is this...
Quite often, when I modify my xml, I need locate the node, if the node
doesn't exist, I need create the node. But usually, the node is several
level deep, like
field/field/field
What is the best way to do that in C#?
thanks!
i have admin login form and status updation form. the admin get logged in and the update the status of the the customer smart card.
the status page have a gridview which is bound to sqldatabase table which has fields..
1. Application no.
2. apllication date.
3. customer name
4. status. ( in status column of the grid we have dropdowns holding 3 values. pending, produced, delivered). the status can be updated from the grid.
now the...
I want to create a website for my wedding and please I am new to flash, so make it simple for me
http://www.weddingorg.com/avant-garde/avant-garde.html
Hello,
I am trying to create a XML schema to validate a XML document. The XML document has recursive <Section> elements (as shown below). Can someone help me create the XSD for the recursive part (Section One and the children)
<?xml version="1.0" encoding="UTF-8"?>
<MenuHelp sectionHeading="" menuSpace="">
<Description>></Description>
<Sections>
<Section name="Application Help" url="" helpFileName="" isLegacy="1" code="">...
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system