Date Difference in Datagridview [modified] - C# Discussion Boards

Alan N4-May-09 5:21

4-May-09 5:21

Byte order reversal?

Use System.BitConverter and System.Net.IPAddress.NetworkToHostOrder/HostToNetworkOrder.

One I did earlier:

/// <summary>
/// Byte reverse the value and write to the buffer at ofs
/// </summary>
/// <param name="i">value to write</param>
/// <param name="ofs">Write offset in the buffer</param>
internal void WriteUInt32(UInt32 i, Int32 ofs, Byte[] buffer) {
  Int32 j = IPAddress.HostToNetworkOrder(unchecked((Int32)i));
  Byte[] b = BitConverter.GetBytes(j);
  b.CopyTo(buffer, ofs);
}

Alan.

Re: convert uint to byte[]

harold aptroot4-May-09 5:30

harold aptroot

4-May-09 5:30

Nice! I'm going to remember that one

How can I use timers in BHO?

svt gdwl4-May-09 4:45

svt gdwl

4-May-09 4:45

present, and according to data availble as packet by packet.
I want to read the html elements obtained and change the innertext of each html element. I am able to do all these.
The main thing is I want the changed text should be visible to user directly instead of original text which is obtained in packets.
How can I do this?

If I had to use threading, How can I do that?
or If I can user timers, how can I do this?

Say correct solution. If there are any examples, it would be so much helpful for me...

[newbie] err

jon-804-May-09 4:39

jon-80

4-May-09 4:39

See anything wrong here? Pasted out of MSDN to a Console application (C#).

delegate int del(int i); //error?
del myDelegate = x => x * x;
int j = myDelegate(5); //j = 2

VS 2008 / .NET 3.5

Confused | :confused:

http://msdn.microsoft.com/en-us/library/bb397687.aspx[^]

Jon

Re: [newbie] err

Jimmanuel4-May-09 4:59

Jimmanuel

4-May-09 4:59

the //error? line needs to be in a class definition but not inside of a function

Badger | [badger,badger,badger,badger...]

How to Detect Advertisement from a Video file

pravat_SABAT4-May-09 3:31

pravat_SABAT

4-May-09 3:31

Hi There,

I am Using FFMpeg in my project and it was great going. I am struck in a position where I need to fetch the Time when a blank screen comes in between a video file. It will be great if you help me in this Issue.

Thanks & Regards

Re: How to Detect Advertisement from a Video file

Dave Kreskowiak4-May-09 5:13

Dave Kreskowiak

4-May-09 5:13

You're going to have to find a forum specific to the library you're using. What you're asking has nothing to do with C# or the .NET Framework at all.

A guide to posting questions on CodeProject[^]

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

Date Difference in Datagridview [modified]

nagendra.vk4-May-09 3:23

nagendra.vk

4-May-09 3:23

hi everybody

i m using C# Application

i have a 'date' and 'days' columns in datagridview

now i want to findout the no. of days between two dates
how can i calculate
pls help me

date days
--------------------------------------------
1/11/2008 0
1/12/2008 30
3/12/2008 2
--------------------------------------------

modified on Monday, May 4, 2009 9:32 AM

Re: Date Difference in Datagridview

stancrm4-May-09 3:45

stancrm

4-May-09 3:45

Example :

DateTime d1 = new DateTime(2008, 1, 1);
DateTime d2 = new DateTime(2009, 1, 1);
TimeSpan ts = d2.Substract(d1);

ts.TotalDays <- is the value you want.

sql error

michaelgr14-May-09 3:08

michaelgr1

4-May-09 3:08

Hello,

I use dataadapter to fill datagrid (using datatable).
dataAdapter =

new SqlDataAdapter(selectcommand3, connectionstring);

But my sql query command is too long. because i receive an error that sqlexception was unhandled (incorrect syntax near '='). But when i write another much shorter sql query it works fine. What can i do to solve it?

Re: sql error

Not Active4-May-09 3:20

Not Active

4-May-09 3:20

Use stored procs

only two letters away from being an asset

Re: sql error

michaelgr14-May-09 3:34

michaelgr1

4-May-09 3:34

What does it mean?

Re: sql error

Not Active4-May-09 3:49

Not Active

4-May-09 3:49

You don't know what stored procedures are? OMG | :OMG:

only two letters away from being an asset

Re: sql error

michaelgr14-May-09 3:51

michaelgr1

4-May-09 3:51

Re: sql error

Not Active4-May-09 4:20

Not Active

4-May-09 4:20

Then go away and don't come back until you do. Roll eyes | :rolleyes:

only two letters away from being an asset

Re: sql error

Dave Kreskowiak4-May-09 5:11

Dave Kreskowiak

4-May-09 5:11

That depends on the query. It's not really that the query is too long, but probably that the DataAdapter will only work with queries that return data from a single table with a primary key.

A guide to posting questions on CodeProject[^]

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

Re: sql error

I am BATMAN4-May-09 5:37

I am BATMAN

4-May-09 5:37

michaelgr1 wrote:
dataAdapter =

new SqlDataAdapter(selectcommand3, connectionstring);

Did you put one too many new lines after that = statement? at most the assignment should be the next line down, you shouldn't add any space between the 2 lines.

Re: sql error

riced4-May-09 5:50

riced

4-May-09 5:50

I am BATMAN wrote:
at most the assignment should be the next line down

Not according to the language spec. You can have as many white space chars as you like including multiple newlines. Smile | :)

I've just checked with a prog by adding multiple newlines - compiles without error. Smile | :)

Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis

Re: sql error

mohmeh834-May-09 20:34

mohmeh83

4-May-09 20:34

if what you say in currect you can use @"" string style:
SqlCommand mySqlComm = new SqlCommand();
mySqlComm.CommandText = @"

type your string here

";

but I think your sql statement is incorrect. Copy your SqlCommandText and paste in in sql Query analyzer and test it. if it has not that error what you said it correct.

Log when windows starts and shuts down

Mc_Topaz4-May-09 2:09

Mc_Topaz

4-May-09 2:09

Hi!

My work mate have asked me to program a software which he could see when he started his computer and when he shuts the computer down.
He would like a to save this information in a text file.

I have no problem creating a Console Application to run when Windows was started using Windows auto start folder in the Start/Program-meny.
But the opposite, when Windows is closing down, I have no clue how to do.

Any ideas? I would prefer to have both functions in the same program, if that could be arranged easily.

/Mc_Topaz

Re: Log when windows starts and shuts down

Michael Bookatz4-May-09 2:17

Michael Bookatz

4-May-09 2:17

create a service that writes a message when starting and stopping. The only probelm with this is if someone manually stops the service

Re: Log when windows starts and shuts down

Mc_Topaz4-May-09 2:38

Mc_Topaz

4-May-09 2:38

Do do I create a service?

Re: Log when windows starts and shuts down

MumbleB4-May-09 2:58

MumbleB

4-May-09 2:58

Easy - www.google.com and search for "windows services + c#" should give you enough references.

Excellence is doing ordinary things extraordinarily well.

Re: Log when windows starts and shuts down

Alan N4-May-09 4:17

Alan N

4-May-09 4:17

Hi,
Windows will run a script at startup, shutdown, login and logoff so all you require is a very simple command file.

e.g.

@echo %DATE% %TIME% %1 >> v:\syslog.txt

to generate the output

04/05/2009 14:53:03.25 SHUTDOWN
04/05/2009 14:54:33.25 STARTUP
04/05/2009 14:55:11.79 LOGON

The group policy editor gpedit.msc allows assignment of a script and the parameter (%1) which in this example are the strings SHUTDOWN, STARTUP and LOGON.

Alan.

Log when windows starts and shuts downs

Mc_Topaz4-May-09 2:09

Mc_Topaz

4-May-09 2:09

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