Save and read back stored Stopwatch object

Question

1.00/5 (1 vote)

See more:

Hello

I need to store the System.Diagnostics.Stopwatch in database.

I managed to store it (as blob(byte)) and i can read it back as byte, but then i have problem to convert it back to the System.Diagnostics.Stopwatch object.

Any one that can help ?

I think the real issue is how to get the bytes back to the stopwatch object.

With Kind Regards

Heino

Posted 30-Jun-11 2:21am

henur

Updated 30-Jun-11 2:54am

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

#realJSOP · Answer 1 · 2011-06-30T02:28:00

Solution 1

Try something like this:

C#

Stopwatch stopWatch = (StopWatch)DataTable.Rows[0]["StopWatch"];

EDIT (after comment) ===========

Let me ask you this - why are you trying to save an entire object when you only need one or two properties? Can't you just change the column from a blob to a bigint in your db and make it easier on yourself? In fact, all you really need is the ElapsedTicks property, and you should be gold.

Posted 30-Jun-11 2:28am

#realJSOP

Updated 1-Jul-11 11:57am

v3

Comments

henur 30-Jun-11 8:39am

Well...i tried following
Stopwatch stw = (Stopwatch)(reader["sw"]); (I use MySql)
but then i get error: Unable to cast object of type 'System.Byte[]' to type 'System.Diagnostics.Stopwatch'.

So...i dont know how to get further.

Heino

Christian Graus · Answer 2 · 2011-07-01T14:11:00

Solution 2

Your issue is two fold. First, John is right, storing an object like this is stupidity. What if your UI layer changes how it shows this data ? The only data you need, is the ticks. However, if you have used serialisation to get a byte presentation of the object, then you need to reverse that process to build the object out of the stream of bytes. If you didn't do that, I doubt the data you have in your DB represents a stopwatch object in the first place.

Posted 1-Jul-11 14:11pm

Christian Graus

Comments

henur 3-Jul-11 5:26am

Ok :-)

Maybe it's stupid....

I am open for suggestions. Let me describe the needs instead.

I have stopwatches (maybe severals) starting in a application.
As long as the applications runs i have no problem to pause and restart.
However.....when the application closes for the workingday and then starts next time i need to show the stopwatches and restart with saved values(milliseconds or ticks....) but as i understand it, i cant set values to a stopwatch.

So...i thought....save the object-read it back- and restart.

But as i said...i am open for suggestions.

With Kind Regards

Heino