Re: Real Time Graph of COM port Data - C# Discussion Boards

compninja2528-Jan-09 5:56

28-Jan-09 5:56

I'm working on a program for some of my coworkers that take inventory with hand held scanners. I've been able to download the text file from the scanner and play around with that, but now I'm to the part where the users need to be able to view, edit, and update the records because sometimes the data isn't always accurate. I'm trying to set this up where the records are saved in an excel file. Using an OleDB data adapter I can access the xls file and place it nicely into the gridview, and I'm sure with a little bit of elbow grease I'll be able to wire up the events to update and save the modifiled cells back. My question here is, is there a better way to do this? For example, is there a way in which I can just start excel.exe and embed it into my windows form instead of using OleDB?

Thanks everyone!

"You're damned if you do, and you're damned if you dont" - Bart Simpson

Re: Just fishing for thoughts

Rob Philpott28-Jan-09 6:05

Rob Philpott

28-Jan-09 6:05

Might you not use some sort of database at the back end instead of Excel?

Regards,
Rob Philpott.

Re: Just fishing for thoughts

compninja2528-Jan-09 6:58

compninja25

28-Jan-09 6:58

Hi Rob,

I thought of just using a SQL server at first, but one of my objectives is to give the users the ability to export everything to an excel document. That's why I figured It would make the most sense to just read and write straight to the xls file rather than first importing everything into SQL to then turn around, read it all back out and then write it to the xls.

I think what I will eventually do is just use System.Diagnostic.Process to start up excel opening the file after I've done what I need to do with it.

"You're damned if you do, and you're damned if you dont" - Bart Simpson

Re: Just fishing for thoughts

Dave Kreskowiak28-Jan-09 7:21

Dave Kreskowiak

28-Jan-09 7:21

Excel makes for a lousy database. There's a limited number of rows you can put into an Excel sheet, and there is also the constraint of memory. You may eventually find out you made a mistake by going with Excel.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Re: Just fishing for thoughts

compninja2528-Jan-09 7:24

compninja25

28-Jan-09 7:24

Hi Dave,

Ah, I was unaware of the row limitations. Thanks for the warning. To make sure I don't cramp my programs room for growth I've decided to go with a SQL database and just add a button to allow the users to export the gridview to excel.

"You're damned if you do, and you're damned if you dont" - Bart Simpson

Re: Just fishing for thoughts

Ennis Ray Lynch, Jr.28-Jan-09 7:41

Ennis Ray Lynch, Jr.

28-Jan-09 7:41

Most of the times, "Export to Excel" as a requirement is made by persons who have no understanding of technical issues. Which is a bonus for programmers in this case, it is trivial to export to CSV and 99.99% of end-users don't know the difference and those that do don't care. With that issue out of the way embed into SQL Express, it will make your life easier.

Need software developed? Offering C# development all over the United States, ERL GLOBAL, Inc is the only call you will have to make.

If you don't ask questions the answers won't stand in your way.

Most of this sig is for Google, not ego.

Real Time Graph of COM port Data

johns42028-Jan-09 4:54

johns420

28-Jan-09 4:54

Greetings all,

I was curious if anyone knew how one would go about graphing data recieved from a serial port via rs232 in real time. I would just like to have a 2d line graph that would update upon every byte recieved from the serial port. The graph can have a static range as well, say from 0-255.

Any help would greatly be appreciated.

Re: Real Time Graph of COM port Data

Ennis Ray Lynch, Jr.28-Jan-09 4:58

Ennis Ray Lynch, Jr.

28-Jan-09 4:58

Use the serial port class and graph the result through a custom control overriding OnPaint would be the quickest.

http://msdn.microsoft.com/en-us/library/system.io.ports.serialport.aspx[^]

Re: Real Time Graph of COM port Data

johns42028-Jan-09 5:05

johns420

28-Jan-09 5:05

I should have said this in the first post, but I already have established a working com connection. I can send/recieve data through the port. What I really need help with is graphing the data.

With the custom control overriding, how exactly does that work? WOuld you be able to provide me with a sample code?

Re: Real Time Graph of COM port Data

Ennis Ray Lynch, Jr.28-Jan-09 5:12

Ennis Ray Lynch, Jr.

28-Jan-09 5:12

There are numerous articles on Code Project dealing with custom drawing in OnPaint for controls. The event argument contains a Graphics object which is very easy to use just by looking at the method signatures.

Re: Real Time Graph of COM port Data

johns42028-Jan-09 5:14

johns420

28-Jan-09 5:14

I will do some more research. thank you for the advice on the custom drawing controls.

Re: Real Time Graph of COM port Data

Rafone29-Jan-09 3:31

Rafone

29-Jan-09 3:31

Have you had a look at ZedGraph?

I'm not sure how to put a link in here but here goes....

http://www.codeproject.com/KB/graphics/zedgraph.aspx[^]

Statistics are like bikini's...
What they reveal is astonishing ...
But what they hide is vital ...

Re: Real Time Graph of COM port Data

johns42029-Jan-09 5:12

johns420

29-Jan-09 5:12

Thanks for the link. Have you used ZedGraph before?

Re: Real Time Graph of COM port Data

Rafone29-Jan-09 11:15

Rafone

29-Jan-09 11:15

Yes I am using it now for some data graphing.

It is Open Source and it has lots of potential. Another possible solution might be .. MS released a chart control a month or 2 ago. I've tried it but for what I'm doing there was just to much overhead but it might be worth giving it a shot.

Hope This Helps
Rafone

Statistics are like bikini's...
What they reveal is astonishing ...
But what they hide is vital ...

Re: Real Time Graph of COM port Data

Rutvik Dave29-Jan-09 8:31

Rutvik Dave

29-Jan-09 8:31

try Microsoft Chart Controls[^].

The sample code contains more than 200 examples.

[newbie] Converting to an integer

jon-8028-Jan-09 4:50

jon-80

28-Jan-09 4:50

The following snippet is intended to read the current maximum value and increment it by 1 so that it uses it to store in the database.

I need to convert the result of rawValue to an integer, increment it by 1, an, include it as a parameter.

any ideas?

object rawValue = getTaskRefSQL.ExecuteScalar();
                if (rawValue != DBNull.Value)
                { 
                    //convert rawvalue to System.Data.SqlTypes.SqlInt64
                   myValue = (System.Data.Sqltypes.SqlInt64) rawValue;  //explicit cast is not valid
                    //add
                    myValue++;

                }

cmdCreateNewTaskQuery.Parameters.AddWithValue("@taskID_PK", myValue);

Jon

Re: [newbie] Converting to an integer

J4amieC28-Jan-09 4:51

J4amieC

28-Jan-09 4:51

myValue = (long) rawValue;

Using this method to create your primary key isprone to errors, use an auto-incrememnting identity field where possible.

Re: [newbie] Converting to an integer

markymarky8-Apr-09 15:03

markymarky

8-Apr-09 15:03

this works good for me...int.Tryparse will try and convert to an integer, returning true if it succeeds and false otherwise, you can probably do long etc too

here i feed in a string, and try to convert to an int...

booResult = (int.TryParse(strSpO2, out intSpO2));//feed in string, and request an int out

if (booResult == true)//then it is numeric

Sort arrow indicator position in ListView header

kanchoette28-Jan-09 4:40

kanchoette

28-Jan-09 4:40

Is there a way to change the horizontal arrow symbol position in a sortable ListView column header? I want the arrow to be closer to the header text.

Unbound DataGridView copy to Unbound DataGridView

Lodeclaw28-Jan-09 4:36

Lodeclaw

28-Jan-09 4:36

Good Morning/Afternoon/Evening,

I'm trying to copy the contents of an unbound DataGridView of one form into an unbound DataGridView on it's child form. I've been looking all over for a solution, but I can't figure the darn thing out. It should be a simple task, should it not?

Please help!

Re: Unbound DataGridView copy to Unbound DataGridView

led mike28-Jan-09 4:43

led mike

28-Jan-09 4:43

Lodeclaw wrote:
It should be a simple task, should it not?

What should be simple? Copying the data probably is simple. Finding an example of it, probably not so simple since best practice would be to use an MVC design.

Re: Unbound DataGridView copy to Unbound DataGridView

Lodeclaw28-Jan-09 4:48

Lodeclaw

28-Jan-09 4:48

I don't know if it's simple or not, which is why I asked. I'm hoping someone can point me in the right direction so I can figure it out. All I want is an exact copy of a datagridview in one form to appear on another form.

Re: Unbound DataGridView copy to Unbound DataGridView

led mike28-Jan-09 4:57

led mike

28-Jan-09 4:57

Lodeclaw wrote:
I'm hoping someone can point me in the right direction

Well if I were planning on copying a DataGridView, I wouldn't do that but if say for some hypothetical insane reason I was planning on it, I would start at the documentation for the DataGridView class.

Re: Unbound DataGridView copy to Unbound DataGridView

Lodeclaw28-Jan-09 5:09

Lodeclaw

28-Jan-09 5:09

I've looked through the documentation already. Since there's no help to be had here, I'll try a different route. Thanks anyway, Mike.

Re: Unbound DataGridView copy to Unbound DataGridView

led mike28-Jan-09 5:38

led mike

28-Jan-09 5:38

Lodeclaw wrote:
I've looked through the documentation already

Did you find this?[^]

I'm not saying that's a good way to go about this, however it does seem to have some possibilities doesn't it?

Last Visit: 31-Dec-99 18:00 Last Update: 24-Jun-24 21:47

Refresh

ᐊ Prev 1...5777 5778 5779 578057815782 5783 5784 5785 5786 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.