|
I am in need of some guidance of how to carry out a specific task I need to perform...
I have a database table that contains requests made by users for excel spreadsheets.
In that table there is a status column which indicates the step the request is in.
I need to write a service of some sort that will be able to keep checking the status column of that table.
When it finds a record that contains the status it is looking for, it should pull the data from the record and call another application which creates the excel spreadsheet.
(NOTE: I have written a program that contains a class which creates an excel spreadsheet and saves it to the local hard drive. All of this will be hosted on the same server)
Thanks in advance!
|
|
|
|
|
I'd do that with a Windows Service. I'd have it cycle every minute or so, query the table, do what it has to. Not a big deal.
|
|
|
|
|
|
I am trying to Trap a Windows Dialog that appears when a user exists PowerPoint and the system asks to save changes. The changes are not required and we don't want the dialog appearing.
We have managed to get the handle to the window and pass it the correct key to close the window but still have the window appearing for a second and the Window Beep sounding.
Is it possible to Catch this window and process it before it is displayed and the Beep sounds?
|
|
|
|
|
are you in Office 2007 ??
|
|
|
|
|
When the PP document is read-only, I expect PP won't let you change it and won't ask such question.
Luc Pattyn
Have a look at my entry for the lean-and-mean competition; please provide comments, feedback, discussion, and don’t forget to vote for it! Thank you.
Local announcement (Antwerp region): Lange Wapper? Neen!
|
|
|
|
|
Hi Thanks for the reply.
I am are targeting both Office 2003 and Office 2007.
I have managed a bit of a workaround.
We are giving the user the option to save changes by default of not.
If Save Changes is set we add the following to the SlideShowEnd Event.
CurrentPresentation.Save();
If not we use
CurrentPresentation.Close();
Application.Quit();
This seems to work well although when PowerPoint closes and the changes have not been saved and the show is being run from an open application as opposed to being run from a folder with (Right Click Show) the Save Changes dialog appears. We have managed to get a handle to this Dialog and pass it a "No" key press. The problem is that the dialog still appears for a second with a system beep. Would be nice to handle this more effectively. i.e trap it and action it to stop it appearing.
|
|
|
|
|
when the window created, it will show . you can't stop it.
but you can consider this.
1) if you can get the handle of the window,
why not monitor the messages of the window queue,
one window created, message must send out.
so pop this message from the queue, will success to stop window showing.
2) or you can 'hook' the function which create window in Win API.
April
Comm100 - Leading Live Chat Software Provider
modified 27-May-14 22:01pm.
|
|
|
|
|
Hi.
I'm developing a small Windows forms application on which I must apply logon security. I need to verify that the user exist in the AD, is part of a certain group and has the proper role.
I also need to take care of the fact that the computer might not be connected to the network hence no contact with the domain controller.
Does anyone have an idea on how to implement this in a simple way?
|
|
|
|
|
Well, use base credentials. Once the computer is connected to the network cache the credential to the client, and use it until the next login to server. Get Roles, groups etc data of that particular user which is connected through login to the local cache (might be in database) and use it until it gets online to network again.
![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
|
|
|
|
|
Allright, but how do I do this (I'm fairly new to C#). Is there some examples out there which I can take a peek at?
|
|
|
|
|
Hi.
I'm developing a small Windows forms application on which I must apply logon security. I need to verify that the user exist in the AD, is part of a certain group and has the proper role.
I also need to take care of the fact that the computer might not be connected to the network hence no contact with the domain controller.
Does anyone have an idea on how to implement this in a simple way?
Reply:
if you use 'socket' or other 'object'...,i think they always have a function like 'connect';
try like this way:
try
{
sokcet.connect();
}
catch
{
// not success.
// deal it.
}
April
Comm100 - Leading Live Chat Software Provider
modified 27-May-14 22:01pm.
|
|
|
|
|
Hi
working on my first ever project with c# in visual studio 2008 using net framework 3.5
i'm trying to work out how to display a list of AVI files from a fixed directry (c:\video) and have that list update itself everytime a new file is added and to highlight the latest flle.
been looking and trying things out for over 2 weeks and getting no where so any help would be great, even just getting the list of AVI files to display would be a great start
thanks
kenny
|
|
|
|
|
Searching for 2 weeks you must have encountered Directory.GetFiles() and FileSystemWatcher many times, and have become an expert in using them.
Luc Pattyn
Have a look at my entry for the lean-and-mean competition; please provide comments, feedback, discussion, and don’t forget to vote for it! Thank you.
Local announcement (Antwerp region): Lange Wapper? Neen!
|
|
|
|
|
yes came across them many times but every time i tried to use them i got errors 
|
|
|
|
|
That depends on where you search.
|
|
|
|
|
Google is a great place however even that doesn't always give you what you want in a format you understand, everyone got to ask to learn
kenny
|
|
|
|
|
Well, you just have to know WHAT to ask of Google and HOW to ask it. This is where the most important skill as a programmer comes into play. It's not the ability to write code or understand the language. It's the ability to do research and teach yourself.
|
|
|
|
|
why, high and low, of course.
Luc Pattyn
Have a look at my entry for the lean-and-mean competition; please provide comments, feedback, discussion, and don’t forget to vote for it! Thank you.
Local announcement (Antwerp region): Lange Wapper? Neen!
|
|
|
|
|
use
string[] files = Directory.GetFiles("path", "*.avi");
Path represents the path of the directory, in your case its C:\video
|
|
|
|
|
Hi
Being very very limited in my knowledge of this could you help me a little further as to what else i need to add to make that bit of code work, assume i'm starting with a blank form!
kenny
|
|
|
|
|
If you want a personal mentor, you'll have to earn one first. I suggest you start here[^].
Luc Pattyn
Have a look at my entry for the lean-and-mean competition; please provide comments, feedback, discussion, and don’t forget to vote for it! Thank you.
Local announcement (Antwerp region): Lange Wapper? Neen!
|
|
|
|
|
Didn't think asking a simple question was such a big deal!
|
|
|
|
|
The question itself is not a problem, assuming you are willing to learn and make an effort.
And if you want to be spoon fed all your life, that is your choice. No big deal except for yourself.
Luc Pattyn
Have a look at my entry for the lean-and-mean competition; please provide comments, feedback, discussion, and don’t forget to vote for it! Thank you.
Local announcement (Antwerp region): Lange Wapper? Neen!
|
|
|
|
|
Very easy.
C# 'FileSystemWatcher' object can help you.
//for example
FileSystemWatcher p = new FileSystemWatcher(@"c:\video");
p.EnableRaisingEvents = true;
p.IncludeSubdirectories = true;
p.Changed+=new FileSystemEventHandler(p_Changed);
p.Created+=new FileSystemEventHandler(p_Created);
p.Deleted+=new FileSystemEventHandler(p_Deleted);
April
Comm100 - Leading Live Chat Software Provider
modified 27-May-14 22:01pm.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
