Hi Calla, that sounds good. Thanks Frank

Hi, that's not the question. If you examine the service list you will find some services which have these options and some have not. In my case it make sense to suspend the service do something with the data and after this to continue the service. So, please where is the option to be set ? Thanks Frank

Hi!, where do I configure the option that my windows service can be suspended and continued and not only started and stopped ? (I meen that the options are shown and selectable in the service list menue). Is it a code option or a setup option ? Thanks Frank

Hello, I am using that code snippet to print a word document out of my application.

ProcessStartInfo startInfo = new ProcessStartInfo();
startInfo.FileName = @"c:\test.doc";
startInfo.Verb = "printto";
startInfo.Arguments = strPrinterName;
startInfo.CreateNoWindow = true;
startInfo.WindowStyle = ProcessWindowStyle.Hidden;
startInfo.UseShellExecute = true;
startInfo.ErrorDialog = true;
System.Diagnostics.Process.Start(startInfo);

It works fine but: The Problem is, that word pops up, print and quit. Is there an additional parameter to set, to tell word to do it in hidden mode like requested

startInfo.CreateNoWindow = true;
startInfo.WindowStyle = ProcessWindowStyle.Hidden;

to print silently in the backgound ? Thanks Frank

Thank you Dave, what you say I already know. But please say where to get these process information and how. Solutions ? Frank

Hi, using the smtpclient.SendAsync method, I want to know how much byte (or the percentage) has been sent out of total bytes. I didn't found a way to get status information from the client. Is there another way (for example over the sockets interface) to retrieve these missing information if yes, how ? Thank you for your time Frank

sorry I am in the wrong message board...

Hi all, is there a way to restrict the form.showdialog method (I mean the blockage) to the calling parent-window and not to the whole app ? thank you ! frank

modified on Wednesday, February 10, 2010 3:44 AM

Thank you, I also found this example, but the examples assume, that an Excel file already exists. But I remember, 5 years ago, I could generate a new file with the sql-sting above (within VB6) without an additional action. Why can't I do that today - or how can I do that today ? Tnx for your time Frank

Hi Richard, it's an interesting link - I will convert the code to C# - will take some minutes ;P I will let you know the result. Tnx Frank

Thank you, have tried your suggestions, but got some OLEDB-unknown errors, what ever that meens. (But I think,(not sure) the disadvantage is that the Excel-table must already exist) But thanks alot Frank

Thank you, I know what SQL normally does ... but I think you don't know what I am expecting from this query ... Thank Frank

Hi all, I want to export my data from a SQL-Server table to an Excel-File. The following code shows my routine.

oConnection.ConnectionString = "Provider=SQLOLEDB; Server=Servername; database=ABC; Trusted_Connection=yes; User ID=ABC_MAN; Password=secretABC";
oConnection.Open();
oCmd.Connection = oConnection;
oCmd.CommandTimeout = 60;
oCmd.CommandText = "SELECT id AS NO, name AS NAME INTO [Excel 8.0;DATABASE=Test.xls] FROM MyDataTable WHERE typ=1";
oCmd.ExecuteNonQuery();

But instead of an exel file the string creates a new table with the name Excel 8.0;DATABASE=Test.xls Where is my fault ? Different examples has shown that this should work :confused: Thanks Frank

Hi Henry, there are realy some more suggestions to solve the problem. I will follow your links. Will see what will happen. But i fear I can't deploy a .chm file with my application due to similar expected problems on the clients. Isn't there a more reliable (local) help technology on the market than .chm ? Thanks, Regards, Frank

Thank's for your suggestions, the .chm file was generated on the local computer and shall be opened there also. Thanks Regards, Frank

Hi all, I know this is not a C# relating question, didn't found a better forum .... but I read so much and I tried much more... The problem: I compiled a .chm helpfile with a correct linked html-file-site structur. Outside the .chm file everything works fine. I used different tools and I came always to the same result - the contens side stays blank (than means - the typical message ... there is no internet connection ....comes up) I registered the .chm file in the registry and controled that. I set the correct accesslevel in the registry to Nr. 2 (means that local rights are accepted) I decompiled my .chm file to see that the html-files are realy included - all seems to be fine. What more is to do that the .chm contens will be shown ??? Thanks Regards, Frank

Gareth, thank you for your answer, I see your problem was different, but I have the problem of a treeview lock when using BeginUpdate / EndUpdate. My program worked 4 years without error under .NET 1.1 and I got the problems changing to .NET 2.0 SP1 - why ever. I have nothing running in parallel tasks or threads which could interfere my program. I left BeginUpdate / EndUpdate unused - no problem any more. But that leaves no good feeling. Regards, Frank

Hi Gareth, I know your post is 3 month ago ... but I have the same problem seen right now. I can fill the tree a hundred time with no problem and then it happens after the third call. I didn't found a way to unlock the control - did you ? Until a better idea is supplied I don't use BeginUpdate() Regards, Frank

Hi all, I have an MDI window with a ButtonBar (defined as master) and from there I can call the child windows (outside the master). And from one child window I am calling an DialogWindow. And here comes the problem: :confused: When I am closing this dialog window, the FormClosing event (of the dialog) fires 34 times, and after that the FormClosed event fires 10 times. I am shure that the events are only initialized for one time. So you can say that 3 layers are opened. (MDI-Master --> MDI-->Slave --> DialogForm) It wouldn't be a problem at all, if the dialog window wouldn't hang up. The whole Program stops. in the FormClosing method is only a quiet simple code.

Dialog_FormClosing(.....)
{
try
{
Console.WriteLine("closing");
if(!can_close)
{
Messagebox.Show("You have to finish your app first");
e.Cancel = true;
}
else
{
e.Cancel = false;
}
}
catch
{
}
}

The question is: Why fires the event so often ? And why hangs up the dialog (the dialog does not close) Some ideas ? - using .NET 2.0.xxx Tnx Frank

Hi Jimmanuel, thanks for your answer. The VS2008 installer addeted automaticly the Prerequisite (but the wrong one) .NET v3.5 instead of .NET v2.0 (my app was compiled for .NET2.0) and left the componentID free. So I came back to my question - where to get this componentID (GUID) or what checks the installer to determine if the correct version is installer or not. - The article doesn't tells somthing about it. Thanks Frank