I have a project to make a GUI using VB.net and retreiving data from an excel spreadsheet every three minutes and draws a graph in real time. The excel file is filled every 3 minutes by a new value (level of water in a tank).As I made started making this interface and I have a problem with retrieving data from a cell of the excel spreadsheet and update this action automatically every three minutes.
View 3 RepliesCurrently, my circuit is connected to a power supply and is connected to the computer via a RS232 cable. Voltage level is extracted and the real-time voltage level is plotted (see attached image) and it will keep movingBut you will realise that there isnt any time shown on the X-axis. I would like to display time in such a way:Each long marker will represent 1 second and there are 4 long marker, which will represent up to 4 seconds.When the (5th second) voltage is sense and the real-time voltage is drawn, i would like the new time (5th second) to replace into the 1st marker postion, the (6th second) to replace the 2nd marker position, so on and so forth. The replacement will continue
View 19 RepliesI want to draw graph in visual basic 2010 form which changes with time. Just like the CPU usage history graph in the "Windows task manager" dialog box. Thats time vs. usage graph. I want to make applications with that kind of graph.
View 3 RepliesI'm trying to create a label that displays sensor output readings. These are small labels inside a picturebox that has a real time graph of the sensors. I'm trying to make the labels transparent or semi-transparent in order to see the entire graph. Setting the labels background color property to transparent only gives the labels the same color property of the picturebox not the actual images of the picture box. I have set the label.parent = picturebox1.
View 1 Repliesi have a program that function as a DAQ System.i have input channel to gather information from sensors. The reading of each sensor such as voltage, current and temperature are displayed in the textbook. As we all know, DAQ system is involve taking data real-time measurement.My problem is:
1. how to update each row automatically as time goes on. the value in the textbook is updated by each second.Below figure shows how the excel can be written automatically row by row, as time ticking for a sec. this update will stop as the timer stop.
I am working on a project that is able to display real time data from sensors from micro-controller. I am able to do so by sending the data through the serial port and then use vb 2005 to show the data. However, I want to save those data from vb 2005 to excel. How am I able to do it ? I am able to use vb to insert data to excel step by step, cell by cell using the following codes.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim oExcel As Object
Dim oBook As Object
Dim oSheet As Object
[code]....
Lets say TextBox1.Text and TextBox2.Text is my real time data. How do I save it to the excel sheet displaying the data in cell A2, A3, A4 when the time goes by. Eg. If I want to save TextBox1.Text to excel it would be, the data in the 1st seconds in cell A2, data in the 2nd seconds in A3, 3rd seconds A4, 4th seconds in A5, A6 and so on...
I m into automation development of FMCG products using Micro-controllers. I get real time data Barcode 2D from TCP/IP connection. My task is to compare the result do some Computation with them and Store the incoming Barcode and results into a Excel sheet in a folder. I m successful with the basic working. Am currently working at slow speed of 1 barcode(22 char info) per second from the TCP/IP data (barcode scanner). Now, comes the real issue. I need to process atleast 5 barcodes per sec ( <200ms per process). I m partially successful with 3 Barcode per second(300 ms per process). so, thats like 300ms per processing. I need to achieve less than 200ms for entire processing. I have used threads and timers. but I m unable to achieve. Seems like storing in Excel takes more than 250ms. Since i come from micro controllers background 1msec is a lotta time to process for me. I m not sure how much time does it take and trust me i find it difficult to guage the time here.
View 1 RepliesI have an Excel based algo-trading app that needs to take in lots of real-time data, and make trading decisions based on the calculations driven by the data. It is not one of those "read-only" stock ticker kinda spreadsheets.I created a COM object with VB.NET that runs in its own thread space which collects data from a socket, and when the data is read it raises an Event with data attached. In Excel VBA, the event handler parses the data, puts them to the right places on the spreadsheet to feed calculations (so far it sounds like a stock ticker app), and then, based on the results of the various calculations it does something.The problem is that when the user starts to click around the spreadsheet while there is large amount of data coming, the event handler's cell updating breaks apart. If the app is left alone without user action, it stands well. My frustration comes from not understanding what happens to the main thread when a user clicks around. Either the event handler blocks the user action, or the user action blocks the event handler (under which case I will put in some queuing facility). But I just don't see how user action can break the code (like causing VBA to stop executing)
View 9 RepliesIs there any open-source component for VB.NET that offers real-time spelling (i.e., as you type) much like word? I found some free and open source components but without that ability.
View 2 RepliesHow can I display a running stopwatch on my form? I am creating a timer but I do not want to use the timer class.
View 4 RepliesI making a simple online chat using an ftp server by downloading and uploading text. I use a thread to update the chat log continuously. But it doesn't update in real time. Is there a way to create a server that clients can upload to and download from extremely quickly? How do programs like MSN messenger or better online multiplayer games do it?
View 1 RepliesWhat would be the proper way to get the cursor position while the mousebutton is held down? I've tried using a do while loop with a background worker, but it freezes up the application.
View 1 RepliesI'm working on a windows forms application (.NET 4.0).My form contains a 'Fast Line' chart using the Microsoft chart control included in VS2010.The chart gets filled with about 20,000 datapoints.My application then starts receiving market data from a server via DDE (Dynamic Data Exchange) in real-time and adds it the chart.
View 5 RepliesI have to send a sequence of video frames over UDP as fast and real-time as possible and while I got the basics working, I am running into all sorts of difficulties. Some of my goals:Data will normally be sent over dial-up (hence UDP instead of TCP), but also needs to support fast Ethernet.It's OK to occasionally drop frames (hence UDP instead of TCP).Need low latency. The frame the remote receives should be one that was recently sent (no more than a few frames waiting in buffers).I need to be able to detect the effective bandwidth so that I can compress the frames more or less to keep frame rate up.I break up frame data into one or more datagrams of about 500 bytes and each has a sequence number and other info. The receiver reassembles the entire frame and detects if any datagrams are missing.If the receiver detects more than a certain percentage of dropped frames (e.g. 50% over the last 10 frames), I send a TCP message to the sender to slow down by 50%. Sender than slowly increases speed by 5% each subsequent frame.Using System.Net.Sockets.UdpClient to send and receive the data.I have a separate TCP channel used for control messages back to sender.My main difficulty right now is detecting the effective bandwidth and dealing with latency, especially over dial-up (max ~4,000 bytes/sec). For example, if I try to send 100,000 bytes/second using TcpClient.Send() they ALL seem to arrive (no dropped datagrams) but with large latency by the time last datagram arrives. I think the TcpClient.Send() function is blocking until the buffer is able to send which messes up my current algorithm.
Can anybody point me to any sources of information for how to:Detect actual bandwidth over UDP.A better algorithm for dynamically adjusting bandwidth to suit the available pipe.Send data smoothly at the desired bandwidth.A way to detect and keep latency down to a minimum.I have been spinning my wheels over the last week and every time I solve one problem it seems another rears up is head.
Make real time chart?
View 1 RepliesI created a form with MS Access with some dropdown menus and some check boxes. The main reason is for when the user select a check box or an option from the dropdown menu a specific phrase will appear on a Note box I created on the bottom of the form. Where I am having the problem is because I added a Text Box in Access where the user can type something in it. What I need is when something is typed inside of the text box the content should be mirrored inside of the Note Box on the bottom of the form. I was able to create the functions using VB for the dropdown menus and the check boxes but for the Free Form Text Box I dont know how to mirror the real time texting.
View 3 Repliesare there any ways that i can extract my data from database and display it into my listbox in real-time? which means that whatever is updated in my database must immediately be inserted into the listbox without the need of refreshing or pressing any buttons. Immediate display.
View 3 Repliesmethods/procedures for sending real time data from a VB.net app to a web server (asp.net) for real time display. My question relates to the best method to send the data from the desktop app and the best way to receive and handle the data on the server. I'm not asking for sample code, just some idea of what methods to research. I am currently using a text file upload method but I'm sure there is a more efficient way of achieving this.
View 2 RepliesI am converting an application to work with SQL.I need the application to monitor a specific table, so it can instantly pick up on changes.The sql server database is on the same machine.The table it needs to monitor is called MaintenanceRecords and it is inserted into via web service.I need to display a message in my VB project when an insert occurs in MaintenanceRecords table.
View 2 RepliesIt is possible to create a real-time application where 2 or more pc will operate on it, for e.g, a cinema ticketing system, when a seat is occupied, all the other machine will be updated in realtime accordingly.
View 2 RepliesI work for a company that produces accident reconstruction software. We have a vehicle dynamics program that realistically simulates the motion of a vehicle (position and rotation of car and steer angle of individual wheels, etc).
All the positions of the car are stored into an array called AMTN. The vehicle dynamics program can calculate positions at time steps finer than .005 secs (200 FPS).
I need to represent this data in real time, and so far I have not been able to accomplish this. I have tried doing this in Excel/VBA, VB6, and am currently trying to do it in VB.NET.
I have used a whole plethora of timers and counters as well as different methods of drawing lines on graphics linked to images linked to picture boxes, etc. My animation program writes/clears the screen correctly, but there is clearly some sort of lag in either the timer or writing method. I have scaled it down to 25 FPS and there is still a lag.
Here is an example of what I am trying to do with each tick of the timer:
Code:
Sub Timer1_Tick1(ByVal sender As Object, ByVal e As System.EventArgs) Handles Timer1.Tick
MyGraphic.Clear(Color.White)
[Code].....
With each tick of the timer, the graphic is cleared, lines representing each side of the car are drawn onto the graphic, and the picturebox is then assigned to the image, which is linked to the graphic. This is just like how your asteroids program works.
Do I need to change my method? Should I use sprites? Or would it be better for me to create images/bitmaps of the animation beforehand and simply flip through them with a timer?
I'm thinking that creating the images beforehand might work because I do not have to calculate the vehicle's position as it is predetermined by my AMTN matrix.
if there is a more efficient way of displaying my vehicle on the screen that would allow for greater FPS, etc.
I am having a problem trying to get a real time back from this code.
Code:
Public Sub Time()
Dim StartTime As TimeSpan = TimeSpan.Parse(txtStart.Text)
Dim EndTime As TimeSpan = TimeSpan.Parse(txtEnd.Text)
[Code]....
I am using a start time of 09:25 and an end time of 10:15 to test this with. I would like it to return 50, as 50 real world minutes went by. I am getting -1331385.
This is mostly someone else's code from a different forum. I have never used a TimeSpan method before and they keep telling me it works "like what I asked for".
I've been a mangler of various types of code for a while now, I love doing PHP stuff but have found the need for some stand alone .exe stuff just recently and am using Microsoft Visual Basic 2008 express edition.Things have been going well so far with all my problems solved by Googling and since so many of the best solutions have come from here, I thought this would be a good place to come with this particular
View 2 RepliesI'm wanting to do a real time graph, as a test i'm going to set up a timer to increment x and y values and then plot them every second on the graph.
I've got hold of Zedgraph, which is quite a nice add-in that i came across, does anyone have experience of doing this?
I have made an application where I connect a VB.NET program to a PLC. I read and write to/from PLC variables.I would like any read value to be updated real time in my VB.NET program. Is there a good way of doing that? For now I update a variable by a button click.
View 7 RepliesI recieved a gift recently visual studio 2010 ultimate a nice suprise I have been repairing and building PC's and networks for years working in local shops and buisnesses, but always wanted to learn programming so my GF purchased this for me nice suprise. So here is my beginner question. I am making a program that will take check info ( check number, amount, date and person or buisness wrote to). I have no plans on using it just trying to learn variable structures and arrays and thought this type of program was a good start. Now I would like to take the text of a text box in runtime and use that to input a new check number into the variable structure. Just so I am not confusing anyone I will write the basic code
[Code]....
So what I would like to do is use a textox labeled check number to add check numbers into the checkrecord structure instead of having to add them into the code manually is this possible?
I've already wrote a simple program for connecting to a serial port that can send data to the microcontroller, do some basic arithmatic and transmit it back to my Form. This was just to see if I could set up the conection.I have a PIC Microcontroller giving an 8-bit number thats is taken from an external sensor device.What I want to do now is to present this data from the microcontroller in a textbox as a number either in real time (as the sensor output changes) or if not possible, on request (using a button).
View 15 RepliesI'm using EF version 4.1, and would like to have the data from the database in realtime, i.e. if you open the application it detects if there is new data in the database, and update the above it! is It possible to do this? I am using EF 4.1 code first time
View 1 RepliesI have Desktop Application by which i want to upload file to the web server. All thefunctionality are going smoothly.Now i want a real time progress bar for representing uploading file status.
View 6 RepliesI have finally made the switch VB.net and I am using VS2010 .NET 4.0 with WinForms. I want to generate a real time 2D plot with autoscaling and update the graphics/picturebox/form/<insert control here> from another thread so when I click a menu the device doesn't halt. The graphics are intensive in that a function is continually reading from hardware and drawing the data. I have been able to do this in VB6 (minus the multithreading) with GDI API and it ran great. Now in VB.NET GDI+ is used which is extremely slow. So my questions are as follows:
1) Should I go back to GDI commands or will this be outdated soon.
2) Should I use Direct2D, if so do I need to switch to WPF and are there any WinForm examples
3) Best approach to multithread this, if I double buffer can I have the GUI thread periodically read the buffer and display it. How can I tell the drawing thread to post an update and the UI thread displays it when it has the chance, similar to using InvalidateRect()