|
oledbcommand cmd=new oledbcommand(@"select F1,F2,F3 from [sheet1$]",con);
F2 datatype string when execute command get F2 values Null
please i need why get F2 null
but if values integer can get data
|
|
|
|
|
You asked this same question in the SQL Forum, please do not cross post.
"Try asking what you want to know, rather than asking a question whose answer you know." - Christian Graus
|
|
|
|
|
just want automated e-mail which sends mails to another person.
i have created a console application which will log my current work and history activities at regular time.
so i extended my idea that console also can send mail to another person on a specified time,
eg: every three hours it sends a mail to another person. notice that as it mail it collects the logged contents from log file , but not as attachment, (person mail address is already specified in the code)
thanks and great for helping me.
so much of happy ending...
|
|
|
|
|
|
hi, thank you so much and for understanding. i'll go through this.
so much of happy ending...
|
|
|
|
|
Sorry, what is your question?
Me: Can you see the "up" arrow?
User:Errr...ummm....no.
Me: Can you see an arrow that points upwards?
User: Oh yes, I see it now!
-Excerpt from a support call taken by me, 08/31/2007
|
|
|
|
|
so here i have created a console application in c sharp which logs my activities done on documents and others.
i want add a new task on this console application. thats mail service as in my article.
my question here is is it possible to:
- mail should collect my logges contents and
- mail to someone automatically on regular time
i hope you understand. thanks
so much of happy ending...
|
|
|
|
|
well, i suppose to create a simple program which logs my history documents activities. but i seen it working only when i open console which should be run automatically and in background.
so i want consoler to run automatically and it should be hidden in background processing.
thanks and great for who help me right now.
so much of happy ending...
|
|
|
|
|
It should be possible to hide the console window using the function ShowWindow.
Add these lines of code before (or at least outside) the Main() method:
[System.Runtime.InteropServices.DllImport("user32.dll")]<br />
public static extern void ShowWindow(IntPtr hWnd, int nCmdShow);<br />
<br />
[System.Runtime.InteropServices.DllImport("user32.dll")]<br />
public static extern IntPtr FindWindow(string lpClassName, string lpWindowName);
Then add these lines of code at the top in your Main method:
<br />
IntPtr hWnd = FindWindow("ConsoleWindowClass", null);
ShowWindow(hWnd, 0);
And that's it.
Edit: Yup, it works 
Oh, I almost forgot. You wanted it to run automaticly. Just place the exe-file in the Start Menu\All programs\Start folder. Then it will be run everytime you log on to Windows.
-- modified at 5:38 Sunday 23rd September, 2007
Virtual1ty
--
"Any fool can learn from his own mistakes, but a wise man learns from mistakes of others"
|
|
|
|
|
thank you so much for trying to help me. but there was a error on the following line im using visual studio 2005.
IntPtr hWnd = FindWindow("ConsoleWindowClass", null); // retrieve a handle to the console window
ShowWindow(hWnd, 0); // hide the window
Error 1 Class, struct, or interface method must have a return type .
so can you look at the code more closely?
thanks
so much of happy ending...
|
|
|
|
|
That's weird. The code works fine here, and I'm also using Visual Studio 2005.
Make sure you defined both functions correctly:
[System.Runtime.InteropServices.DllImport("user32.dll")]
public static extern void ShowWindow(IntPtr hWnd, int nCmdShow);
[System.Runtime.InteropServices.DllImport("user32.dll")]
public static extern IntPtr FindWindow(string lpClassName, string lpWindowName);If that doesn't work, try this:
[System.Runtime.InteropServices.DllImport("user32.dll")]
public static extern int ShowWindow(IntPtr hWnd, int nCmdShow);Instead of:
[System.Runtime.InteropServices.DllImport("user32.dll")]
public static extern void ShowWindow(IntPtr hWnd, int nCmdShow);
Hope that works.
Virtual1ty
--
"Any fool can learn from his own mistakes, but a wise man learns from mistakes of others"
|
|
|
|
|
Virtual1ty, its working fine as you hoped, thanks and you are great, so much for helping.
so much of happy ending...
|
|
|
|
|
No problem
Virtual1ty
--
"Any fool can learn from his own mistakes, but a wise man learns from mistakes of others"
|
|
|
|
|
This one should work:
[System.Runtime.InteropServices.DllImport("user32.dll")]
public static extern bool ShowWindow(IntPtr hWnd, int nCmdShow);
Did you get an error on both lines?
Virtual1ty
--
"Any fool can learn from his own mistakes, but a wise man learns from mistakes of others"
|
|
|
|
|
If you don't want the console at all, just create a windows application and don't open form.
---
single minded; short sighted; long gone;
|
|
|
|
|
Guffa, can you please read my article carefully and it is just a log files into a specified location make sure you dont need any GUI application.
thanks for reply Guffa.
so much of happy ending...
|
|
|
|
|
What article? You haven't submitted any articles here, so I suppose that you mean the forum posting?
Reading your posting carefully only made it less clear. If your program isn't working, what happens exactly when it's "not working"? When you are talking about opening a console window, do you mean the windows command promt?
---
single minded; short sighted; long gone;
|
|
|
|
|
Maybe he's mixing up post and article?
I am not sure what he means by article, either.
"Try asking what you want to know, rather than asking a question whose answer you know." - Christian Graus
|
|
|
|
|
mixing it, yeah if you think maybe you are right.
but articles is console in c sharp and post is what we post article contents into the forum right?
if im wrong pls help me1
so much of happy ending...
|
|
|
|
|
If you look at the top of the page in the menu, to the left of "Message Bords" is "Articles". There is where articles are in The Code Project.
The word "article", however, can be used in several different ways, like for example in "an article of clothing". I don't know which way you are trying to use it, but if it's something other than whats usually regarded as an article here, you have to specify what you mean or it's only confusing.
---
single minded; short sighted; long gone;
|
|
|
|
|
yeah thats true and thank you for helping.
kind regards
zafar
so much of happy ending...
|
|
|
|
|
zafax4 wrote: can you please read my article carefully
What article? Do you mean your post?
"Try asking what you want to know, rather than asking a question whose answer you know." - Christian Graus
|
|
|
|
|
thanks you. im sorry. we use sometimes common sense to understand what is posted in this forum . not to challange ones cleverness.
kind regards
zafar
so much of happy ending...
|
|
|
|
|
Articles have a lot of paragraphs and sometimes pretty pictures.
"Try asking what you want to know, rather than asking a question whose answer you know." - Christian Graus
|
|
|
|
|
thanks paul. you are right and i appreciate you.
and do you know what im asking for here in this post?
so much of happy ending...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
