|
I wrote an application that writes to disk a certain excel document from sql database, then opens it edit.
After user finished editing the document in Excel, the application asks in a dialog if user wants to update the changes to DB. If yes, updates the file in the database.
The problem is, that after Excel window is closed and file updated to db, the Excel process is still running. It can be seen in Process Manager,
and causes incorrect behaviour of new Excel windows. After opening 50 documents, there are 50 processes. That causes serious errors in Excel, up to "OLE library error", which can be cured so far by re-installing Office. 
The question is: How to kill Excel properly?
TIA
Here is the code:
private void OpenExcel(string filename)
{
System.Diagnostics.Process myproc = new System.Diagnostics.Process();
myproc.EnableRaisingEvents = true;
//a special exitbox is assigned to each document
ExitBox windowAfterExit = new ExitBox(filename,this,myproc);
myproc.Exited+=new EventHandler(windowAfterExit.Excel_Exited);
myproc.StartInfo.WorkingDirectory = Environment.CurrentDirectory;
myproc.StartInfo.FileName = filename;
myproc.StartInfo.Verb = "open";
//open excel
myproc.Start();
// at a moment we can work with one document only
myproc.WaitForExit();
}
public class ExitBox : System.Windows.Forms.Form
{
...
public void Excel_Exited(object sender,EventArgs e)
{
this.Visible = true;
}
private void Exit()
{
myproc.Dispose();
DeleteFile(filename);
this.Close();
}
}
|
|
|
|
|
I am looking for a way to get the equivalent functionality of WIN32's DrawText() API function when used with DT_CALCRECT and DT_WORDBREAK.
I am writing a control that will resize itself vertically on a form when its Text property is changed. I have tried using the Graphics.MeasureString() method and I cannot figure out how to get it to return the height of a string to a fixed width.
Any help would be appreciated.
Happy Holidays,
Shane
|
|
|
|
|
See the StringFormat class (the defaults should do, but you can create your own) and the Graphics.DrawString method, which you can use in the OnPaint method override (always override methods instead of handling events in derived classes, but make sure to call the base class's method in most cases):
protected override void OnPaint(PaintEventArgs e)
{
RectangleF rectF = GetRectFBoundsForControl();
e.Graphics.DrawString("Some multi-line text",
this.Font,
new SolidBrush(SystemColors.ControlText),
rectF,
StringFormat.GenericDefault);
}Otherwise, you can always just P/Invoke DrawText, define the DT_CALCRECT and DT_WORDBREAK constants (or enum values) based on the preproc def values, and call the method using the control's HDC, which you can get during the Paint event (override OnPaint when deriving from Control instead):
protected override void OnPaint(PaintEventArgs e)
{
base.OnPaint(e);
IntPtr hdc = e.Graphics.GetHdc();
DrawText(hdc, "Some Text", ...);
e.Graphics.ReleaseHdc(hdc);
}You'll also need to define the RECT structure to use in managed code. See the StructLayoutAttribute for details.
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
Thanks for responding but you did NOT read what I was asking for.
I wasn't asking how to output text. I am asking how to get the SIZE of the text BEFORE it is displayed (i.e. in WIN32, DrawText(Handle,string,string length,RECT *,DT_WORDWRAP | DT_CALCRECT)).
I have NOT had any luck with the Graphic's class MeasureString() method.
Happy Holidays,
Shane
|
|
|
|
|
ShaneStump wrote:
I have NOT had any luck with the Graphic's class MeasureString() method.
Specifically what problems are you having with MeasureString()? Have you tried to P/Invoke DrawText()?
- Nick Parker
My Blog
|
|
|
|
|
MeasureString() doesn't return what I want (or I can't get it to).
I want it to return the # height of the string if wrapping occurs (if the string requres 5 lines, I want the returned height to be for the 5 lines). I am probably NOT using the right method.
Happy Holidays,
Shane
|
|
|
|
|
ShaneStump wrote:
I want it to return the # height of the string if wrapping occurs (if the string requres 5 lines, I want the returned height to be for the 5 lines). I am probably NOT using the right method.
Hmm, the MeasureString method is overloaded, and if you know the maximum width in pixels that your control will represent (I don't know if you will know this?) then you can make a call as such which will take into account wrapping.
private SizeF MyMeasureMethod(PaintEventArgs e)
{
string s = "Nick";
Font f = new Font("Arial", 12);
int width = 300;
SizeF strSize = new SizeF();
strSize = e.Graphics.MeasureString(s, f, width);
return strSize;
}
- Nick Parker
My Blog
|
|
|
|
|
Thank you very much (I didn't realize passing in just a width would return the calculated height)!
Happy Holidays,
Shane
|
|
|
|
|
I'm fairly new to C# and WinForms programming.
How does one programmatically "select" a node in a TreeView.
IE: the user clicks a button which spawns a child process, the output of which is displayed in a TextBox. Each time the user clicks that button, a new process is kicked off and I attach a new node to the TreeView to represent said process. If the user clicks on any given node, that node's associated process output TextBox is brought to the foreground - whre you can watch the output.
Adding the node to the TreeView is straightforward, but hilighting it or "selecting" it programmatically is not so easy.
Suggestions?
-Luther
|
|
|
|
|
Isn't there a:
treeview.setActiveNode(node) method?
if you create the node as a variable first, then add it, and set the variable to the active node, it should do it.
I had this problem with seting the active node of a tree view when it first gets control.
Cata
|
|
|
|
|
Active and Selected are two completely different things. Active just means that the node has the focus, such as what it gains when you right-click the node. Selected means that the node has been left-clicked at some point. To select a node programmatically, just use the following:
treeview.SelectedNode = someNode;
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
That's what I was looking for.
|
|
|
|
|
The obvious escaped me.
Thank you both.
-LutherB
|
|
|
|
|
After doing this - indeed the "selected" image appears to the left of the tree node (from the ImageList index used when creating the node) but, the actual text of the node is not "highlighted. IE: the folder opens, but the folder name is not highlighted.
This is even more obvious when working with a ListView. I've selected a particular ListViewItem, but no rectangular, reverse color block around the text of the item appears onscreen.
Maybe I am doing something wrong - or missing something? Without the highlighted text, its not really obvious which element has been selected.
Thanks,
-Luther
|
|
|
|
|
Out of curiousity, does the rectangular marquee (the dotted lines) around the text appear? If so, the TreeView no longer seems to have the focus. Set TreeView.HideSelection to false and see if the rectangular selection region is at least gray (or whatever the default system color for inactive selected text is).
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
Excellent - a grey "highlight" block appears around the text now - for both the visible ListView and TreeView.
Its not the normal (per my theme) "blue" highlight, but its a clear indication to the user - which is my real goal.
Thanks Again,
-LutherB
|
|
|
|
|
Aha ...
I understand now. Makes perfect sense. The issue of "focus" that is.
One more line, TreeView.focus() does the final trick.
Thanks,
-Luther
|
|
|
|
|
I'm trying to run midl, however, I am encountering error after error.
Cl.exe was not located in the correct location.
when i moved it, there was no mspdb70.dll to support CL.exe.
These components were all in different folders.
Is this right? Or is my instalation of .NET completely knackered?
Is it worth moving all the tools and associated DLL's into one directory? As it's really annoying.
Cata
|
|
|
|
|
I've copied all the stuff in the Vc7\bin folder to the common7\tools\bin folder.
I've moved the objidl.idl file into the tools\bin directory.
It's still not building objidl.idl. I get the error "Cannot open unkwn.idl"
help! 
Cata
|
|
|
|
|
What does your .idl file look like?
- Nick Parker
My Blog
|
|
|
|
|
its the objidl.idl file, taken from the platform SDK Folder in VS.net.
I'm moving the post to the COM forum.
My bad.
Cata
|
|
|
|
|
This is not C# any more, move to the COM forums. ANyways, you are getting that error because your command enviroment is not setup correctly.
leppie::AllocCPArticle("Zee blog");
Seen on my Campus BBS: Linux is free...coz no-one wants to pay for it.
|
|
|
|
|
Which is why I've been trying to get Catalyst to understand that in a separate thread. I mean, if you can't even understand environment variables, why would anyway think to tackle COM? That's like trying to climb Everest or K2 without making it up the front steps to the lobby (if it has one?)!
-----BEGIN GEEK CODE BLOCK-----
Version: 3.21
GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++
-----END GEEK CODE BLOCK-----
|
|
|
|
|
Just run the vcvars32.bat found in "Microsoft Visual Studio .NET 2003\Vc7\bin" in the command line before trying to run MIDL
|
|
|
|
|
I'd like to use the TlbImp.exe program to build some managed COM objects. This seems to be the most efficient way of doing things.
The problem I have is that, what I am looking for resides in the objidl header file. DOesn't this compile to a DLL?
While there are many type libraries, I do not know which one would contain the data I need, if any. Which would it be?
If they are not located there, How do i extract data from an unmanaged DLL?
Cheers
Cata
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
