Re: How to hide the black console window - C# Discussion Boards

Re: C# + Excel

fly90425-May-09 23:34

fly904

25-May-09 23:34

Apologies, I used used the incorrect syntax:

string strCnn = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=\"Excel 8.0;HDR=No;\"", openFileDialog1.FileName);

My failometer is detecting vast quantities of FAIL!

"Its SQL - hardly programming..." (Caslen)

Re: C# + Excel

Socheat.Net26-May-09 15:33

Socheat.Net

26-May-09 15:33

Dear,

Thanks, it work well now

Socheat

How to hide the black console window

Rajdeep.NET is BACK25-May-09 22:31

Rajdeep.NET is BACK

25-May-09 22:31

Hi guys,

How can I hide the black window which appears during the execution of a console application? I want to hide it, becasue I have a program which doesn't accept any user input and just goes on performing some specific tasks which takes quite long time.

Thanks,
Cheers,
Rajdeep.NET Wink | ;)

Re: How to hide the black console window

stancrm25-May-09 22:45

stancrm

25-May-09 22:45

How about googling, see the first link in google :

http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/ea8b0fd5-a660-46f9-9dcb-d525cc22dcbd[^]

Re: How to hide the black console window

Tuwing.Sabado25-May-09 22:54

Tuwing.Sabado

25-May-09 22:54

No need to change your existing code just change your project output type as Windows Application instead of Console Application.

How to change your project output type
1. from your solution explorer right click your console project then choose Property menu.
2. from the application tab change the value of Output type dropdownlist.

Happy coding...

Re: How to hide the black console window

Rajdeep.NET is BACK25-May-09 23:32

Rajdeep.NET is BACK

25-May-09 23:32

Thanks Mark, that worked very well..... thanks for preventing me from implementing DLL calling codes to the project. Big Grin | :-D

Re: How to hide the black console window

Pete O'Hanlon25-May-09 23:06

Pete O'Hanlon

25-May-09 23:06

Rajdeep.NET wrote:
How can I hide the black window which appears during the execution of a console application? I want to hide it, becasue I have a program which doesn't accept any user input and just goes on performing some specific tasks which takes quite long time.

Don't run a console application then. If you have an application that doesn't require user interaction, write it as a service instead.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Re: How to hide the black console window

Rajdeep.NET is BACK25-May-09 23:34

Rajdeep.NET is BACK

25-May-09 23:34

Alright.... I will remember that.

Thanks,
Rajdeep.NET Big Grin | :-D

Re: How to hide the black console window

EliottA26-May-09 2:48

EliottA

26-May-09 2:48

Red flags all over all your posts.

Check out the CodeProject forum Guidelines[^]

Store neutral date in database

Casper Hansen25-May-09 21:33

Casper Hansen

25-May-09 21:33

Hello all

I am building a website and I want to store the current time in a database, thats not a problem.

But I also want to make the time format changable. For example if I have "May 2 2009" stored in the database and I decide I want to change the format to "5/2/2009", I need to either update the database or use a neutral date format that can be converted to the date format I want.

Any tips on this? I thought about using timestamp, but cant rellay see where it fits in

Thanks

Re: Store neutral date in database

stancrm25-May-09 21:35

stancrm

25-May-09 21:35

Just save the datetime in DateTime format in database, not in string.

Re: Store neutral date in database

Casper Hansen25-May-09 21:41

Casper Hansen

25-May-09 21:41

What do you mean?

Re: Store neutral date in database

Eddy Vluggen25-May-09 21:55

Eddy Vluggen

25-May-09 21:55

He means that a datetime is a number[^], and as such, is neutral. To quote;
SQL Server uses 8 bytes to store the datetime data type. The first 4 bytes make up an integer value that represents the number of days since January 1, 1900. The second 4 bytes are an integer value that represents the number of milliseconds since midnight.

When you send a date to the database, do you convert it to a string that get's included in your (text) command? If so, then you can get errors converting from/to the wrong format. If you send it as a number, then it will be interpreted as a "days past since date 1"-number.

Try casting a date to float/integer, and see what happens Smile | :)

I are troll Smile | :)

[Message Deleted]

vishal moharikar25-May-09 20:59

vishal moharikar

25-May-09 20:59

[Message Deleted]

Re: Message Handling in C#

stancrm25-May-09 21:13

stancrm

25-May-09 21:13

If you want to catch the messages, use this in your form class.

protected override void WndProc(ref Message m)
{
  // Do what you want here...
  base.WndProc(ref m);
}

Re: Message Handling in C#

vishal moharikar25-May-09 21:34

vishal moharikar

25-May-09 21:34

Hi there......
Thanks for your help. I need to know how to process a WM_CHAR message sent by other application using SENDMESSAGE API.
I want to receive any keyboard stroke. As you suggested I used :

protected override void WndProc(ref Message m)
        {
            // Do what you want here...
            base.WndProc(ref m);
            if (m.Msg == WM_CHAR)
                MessageBox.Show(m.Msg.ToString());

        }

But it gives an error for WM_CHAR. So please tell me how to catch any keyboard event.

Thanks a ton.....
Vishal Moharikar.

Re: Message Handling in C#

stancrm25-May-09 21:51

stancrm

25-May-09 21:51

See this example : you must define first WM_CHAR :

C# Validating TextBox Control[^]

In that site you can see WM_CHAR also.

Re: Message Handling in C#

vishal moharikar25-May-09 23:31

vishal moharikar

25-May-09 23:31

Hi there...
Sorry, if I am asking any stupid questions.. but just tell me how would I come to know whether the received message is a keyboard event or any other windows message.
I just want to handle the keyboard messages fired by any other application.

Thanks....
Vishal Moharikar.

Help me with formatted int32 strings. [modified]

Solid Green25-May-09 20:50

Solid Green

25-May-09 20:50

We can use int32.TryPrase("1231312",out tmpInt32Value) for normal situtations.

But the following code,
string outputString = (12345).ToString("ABCDE-0000000000");

I do not have a good idea to read such string ABCDE-0000012345 Cry | :((

Especially when the format string is "ABCDE-0066000880"

modified on Tuesday, May 26, 2009 3:09 AM

Re: Help me with formatted int32 strings.

stancrm25-May-09 21:05

stancrm

25-May-09 21:05

and... what is the question ?

Re: Help me with formatted int32 strings.

Solid Green25-May-09 21:11

Solid Green

25-May-09 21:11

Thank you. Smile | :)

I do not have a good idea to convert string ABCDE-0000012345 to int32 Cry | :((

Especially when the format string is "ABCDE-0066000880"

Re: Help me with formatted int32 strings.

stancrm25-May-09 21:15

stancrm

25-May-09 21:15

What kind of strings are that ?
Do you mean :

ABCDE-0000012345 = 12345
ABCDE-0066000880 = 66000880

???

Re: Help me with formatted int32 strings.

Solid Green25-May-09 21:29

Solid Green

25-May-09 21:29

when the format string is "ABCDE-000066000880";
int 1234 custom formated value is "ABCDE000066123884"

My question is how to get the int value by custom format string "ABCDE-000066000880" and formatted string "ABCDE000066123884".

Smile | :)

Re: Help me with formatted int32 strings.

Tuwing.Sabado25-May-09 21:27

Tuwing.Sabado

25-May-09 21:27

Your going to format your interger to a predefine format.

Example 1

<br />
string outputString = (12345).ToString("ABCDE-0000000000");<br />
//Output: "ABCDE0000000000"<br />

Example 2

<br />
string outputString = (12345).ToString("ABCDED-0000000000");<br />
//Output: "ABCDED-0000012345"<br />

If your are expecting that the output of Example 1 is ABCDE-0000012345 you are wrong because "E-0" means Scientific notation.

Note: If any of the strings "E", "E+", "E-", "e", "e+", or "e-" are present in the format string and are followed immediately by at least one '0' character, then the number is formatted using scientific notation with an 'E' or 'e' inserted between the number and the exponent. The number of '0' characters following the scientific notation indicator determines the minimum number of digits to output for the exponent. The "E+" and "e+" formats indicate that a sign character (plus or minus) should always precede the exponent. The "E", "E-", "e", or "e-" formats indicate that a sign character should only precede negative exponents.

See Custom Numeric Format String[^ for more details.

Happing Coding...

Re: Help me with formatted int32 strings.

Solid Green25-May-09 21:35

Solid Green

25-May-09 21:35

Thank you for your answer.

And ,i made a bad formatted sample. Sorry to everyone.

we know that code (1234).ToString("ABCD-000066000880") 's value is ABCD-000066123884.

And I want to get a int value from string "ABCD-000066123884" and formatted string "ABCD-000066000880"。

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