|
Hello,
I have a C# program that reads data from an Excel sheet, and creates an Xml file from it. The Excel sheets are not modified, and the Excel app is hidden from the user.
Everything works fine exept when I quit my program before it finishes. When I do this, Excel stays open. The only way to tell this is to look in the task bar; the first time I did this I was surprised to see 8 Excel processes running!
There must be a way to tell Excel to quit when the process that started it quits... anybody know how I can do this? Thanks!
Jeremy O
PM Logic
http://www.jeremyo.com
|
|
|
|
|
If you using Excel automation com library from MS then it should be very simple. If your running Excel in any other way then I guess you can just kill the process.
|
|
|
|
|
The ApplicationClass defines a Quit method.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles]
|
|
|
|
|
I have a question, that is probably really dumb to anyone who has any significant experience with C#, but I've searched for an answer and tried several different things (a few hours worth of trying different things!), so
I've elected to display my ignorance and ask for help from more experienced C# programmers:
To wit: I'm putting together two different services to run under XP/etc. To avoid any extra overhead and keep the resulting module small, I want to use just one executable w/o referencing any .dll(s) or other resources. To this end, though, I need to share one source file which will contain common code for both services. I have tried everything I can possibly think of to make C# (both .NET 2003 and C#Express 2005) use a single file in the construction of both 'projects'. If I do an 'add existing item', a copy gets moved in under the project. I can't do an 'add reference' to a .cs file. If I make it a 'miscellaneous' file, I can't get C# to find the namespace/class/etc.
There has to be a way to do this ... We used to do it routinely a hundred years ago when I started programming by the use of 'include' statements and the like ...
If someone could spare a few minutes, drop me an email and let me know how to do this.
Thanks,
toml@direcwayREMOVETHIS.com
|
|
|
|
|
You can't just reference a file. What you can do is create a shared assembly. Or just have a copy of your C# file like you mentioned.
If you don't want to have an assembly reference you can use "late binding". Then the C# term your looking for might be Reflections. Search MSDN if u have no experience with it.
|
|
|
|
|
Why not take care of this with a simple Visual Studio macro? Update to/from the file in the other project whenever it is changed.
Matt Gerrans
|
|
|
|
|
I guess many people coming from a C++ background try to do this thing. I wanted to do it myself, when I started with my first C# project.
After a few trials and errors and a little reading I found the following most logical way out:
(1) The code which you want to make common should either be a base class or a utility class.
(2) If not, make it so. Then you will have either BaseClass.cs or UtilityClass.cs file. Have a project for this class.
(3) Now I don’t know your case but typically, you have a single solution with multiple projects. Whichever projects require the BaseClass or UtilityClass functionality, do an ‘Add reference’ of the BaseClass or UtilityClass.
This works for me, do let me know your experience. 
|
|
|
|
|
If you're using Sourcesafe, you can easily have files shared between multiple projects - that's probably the most straightforward way to do it (and means if you change the interface slightly in one project, it won't automatically break the other until you get the latest changes)
--
Help me! I'm turning into a grapefruit!
Phoenix Paint - back from DPaint's ashes!
|
|
|
|
|
How can I export data from database to an excel or word file in a non-web application with C#?
Tks
Thiago
|
|
|
|
|
You can use the COM libraries that MS provides. In your project go to add reference to the COM tab. If you have office installed you should be able to find a library similar to "Microsoft Excel 11.0 Object Library". This library allows you to automate Excel. The object model is very easy to learn. Notice that almost everything in the library is an interface. You can get started by going through the ApplicationClass class. Search MSDN for more information...
Same goes for Word
|
|
|
|
|
|
I know that .NET MUST to have a way to do this. But I don't know how.
1)On COM+, we can install a Component Server on a machine and our application on another. Then on the application Server we can access dll's running over Component Server and the our dll access de DB. There's a way to do it in C#?
2)I read some about MarshallByRef, some proxy dll samples (that doesn't work because it needs a physical path like d:\dlls\mydll.dll or a shared folder).
3)Can anybody help me? Please a step-by-step explaining how to do this....
thank you guys!!!
Wender Oliveira
.NET Programmer
|
|
|
|
|
You can still use COM+ using System.EnterpriseServices classes in .NET, and there's always Web Services and .NET Remoting, all of which are discussed in many articles here on CodeProject.
.NET Remoting is arguably the best route to go with .NET applications (use Web Services if you want to support legacy clients and clients on other platforms (like Java)). To get an overview of remoting, read the .NET Remoting Overview[^]. A couple of good books to read about .NET Remoting are "Microsoft .NET Remoting" from MS Press[^] and "Advanced .NET Remoting" by Ingo Rammer[^] (the former is probably better if you're new to .NET Remoting).
BTW - this isn't specific to C# but is available to all .NET implementations, and you don't need the path to an assembly (the proxy, in this case) so long as the assembly is resolvable (like in the GAC if it is strongly named, and all assemblies should be). Read How the Runtime Locates Assemblies[^] for more information on assembly resolution.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles]
|
|
|
|
|
Thanks Heath,
I'm reading this Remoting overview. But, let me try to explain a few better. I know that maybe you will say to ask it on ASP.NET forum. I have an web application and for security reasons I need to access my components (layers) on another machine... My Web application will talk to a dll on my component server and this dll will talk with my db and return the result to my web application. How to do this with an easy way? At suffering times, with vb, it would be possible by adding a dll on component service and making its msi instalation and adding a refference to that dll on web application. This is made with connection spool, ssl, authentication, etc... Do you know if exists some way to do this with C#.NET dlls?
Wender Oliveira
.NET Programmer
|
|
|
|
|
You implement shared interfaces in separate DLLs with very little implement. Implement those interfaces in your Remoting DLL then consume those interfaces in your client (proxy).
Again, for how the runtime locates assemblies, see the last link I gave you in my previous post. Either one of those books will help explain Remoting better, since it is a very complex subject and the .NET Framework SDK doesn't go indo enough detail to really explain it well.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles]
|
|
|
|
|
When windows performs the shutdown procedure is there a process involved?
If there is what is it called? can it be stoped?
|
|
|
|
|
When Windows is shutting down is sends the WM_QUERYENDSESSION message to all top-level Windows. Fortunately, the .NET BCL has encapsulated this for you in the SystemEvents.SessionEnding event you can read about at http://msdn.microsoft.com/library/en-us/cpref/html/frlrfMicrosoftWin32SystemEventsClassSessionEndingTopic.asp[^]. Set SessionEndingEventArgs.Cancel to true to stop the shutdown.
If you'd like more information, click "Search comments" above and search for WM_QUERYENDESSION since I've covered this in more detail many times in the past.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles]
|
|
|
|
|
Hello ppl,
I need a message box with the following buttons.
Yes/No/YesToAll/Cancel.
MessageBoxButton class doesnot have option for this.
Currently i could think of one solution being having a form with its Form border style as FixedDialog and having four buttons in it..
Is there anyother way to do this?Any pointers/suggestions would be helpful.
cheers,
jagan
|
|
|
|
|
Defining your own dialog is best way to solve the problem. The alternative is messy, full of P/Invoked functions, managed struct representations, and Windows messaging.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles]
|
|
|
|
|
What you've come up with is the best way to do it.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Greetings!
I am trying to create a form dynamically by instantiating its class. Call this FormContainer. On construction, FormContainer creates a different form, Form2, and makes itself the owner of Form2 by calling AddOwnedForm.
Now, I would like to be able to fix Form2 so that it looks like a panel in FormConatiner, so that it moves and resizes along with FormContainer. Is there any way to do this without manually moving and resizing Form2 every time FormContainer is moved or resized?
LannieK
|
|
|
|
|
If Form2 was a usercontrol then you could just create an instance of Form2 and add it to the panel's component container and then set it to fill. On the original usercontrol you can put panels that also fill and have controls on that panel setup to do the same.
I have done this and it is working pretty well.
Steve Maier, MCSD MCAD
|
|
|
|
|
Hi,
I am writing a PocketPC program that want to use a binary string as encryption key.
Does anybody know where can I put the key securely?
Thx a lot! 
|
|
|
|
|
Securely? Nowhere. What are you doing that requires an encryption key and why must you ship the key with the application?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thx RageInTheMachine9532,
Well, the key is not ship with the application. But the encryption key(in binary) is generated from a human signature to encrypt file on PocketPC. Where can I store the key?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
