|
Hello i have a C# program which loads a excel file and read its contents. I want to know how can my program be notified if some one modifies the file i am using so that i get the new data. I can handle events for excel object which opened through my program but what if some other user opens the files and modifies and i want that notification. Is there way i can send a remoting message from excel event handlers to C# application?. If so any help or code snippets will be great help
venky
|
|
|
|
|
Why don't you just use a FileSystemWatcher to watch files in that directory?
Logifusion[^]
|
|
|
|
|
well,i can try that but is there any other way? Is there a way to send a remoting call from Excel event handlers?
|
|
|
|
|
what should i do to make my label accepting multiple line of text.
I remember in vb5 we can resize the label the way we want to and the text will wrap automatically too.
Donkaiser
|
|
|
|
|
set autosize to false
Donkaiser
|
|
|
|
|
Hey, I know there is suppose to be a class System.Runtime.Serialization.Formatters.SOAP.SoapFormatter
but I don't even have the namespace System.Runtime.Serialization.Formatters.SOAP, what's the problem?
NaNg.
|
|
|
|
|
You need to reference a separate assembly, with a name like System.Runtime.Serialization.Formatters.SOAP
Josh
|
|
|
|
|
|
Is there any way possible to post a small icon in a cell when your view property on your listview is set to "details". I was trying to highlight my cells but the color doesn't hold when i scroll over it or select it(it reverts back to white) so I thought maybe i could just add an icon.
|
|
|
|
|
|
lulu0441 wrote: do it in C++
You posted this same question in three different forums. Why? It's clearly a homework assignment to be done in C++. 
"The largest fire starts but with the smallest spark." - David Crow
"Judge not by the eye but by the heart." - Native American Proverb
|
|
|
|
|
Can you do it in any ways ?
|
|
|
|
|
lulu0441 wrote: Can you do it in any ways?
Probably, but I won't. If people enable you to cheat now, things will only be rougher for you later on. Be responsible and do your own homework.
"The largest fire starts but with the smallest spark." - David Crow
"Judge not by the eye but by the heart." - Native American Proverb
|
|
|
|
|
Go away. 
|
|
|
|
|
static void Main()
{
System.Console.Writeline("I am trying to cheat on my homework");
}
|
|
|
|
|
Yeah, Lulu - that should do the trick. 
|
|
|
|
|
hello everybody .
iam testing NAT Traversal through UPNP technology to negotiate with the NAT Router and Firewall but there is a problem in the Com Component that iam using from microsoft Which is located at System32 in your windows installation folder called UPNP.dll and Hnetcfg.dll
the problem is that i always have the collection with value Null that is why i can't be able to iterate through all static ports and ip address in my router (iam using Dial up connection not DSL)
here is the code that raise the problem
<br />
using System;<br />
using NatUpnp;<br />
<br />
namespace SnoutoOverride<br />
{<br />
class Nat<br />
{<br />
public Nat(){<br />
<br />
<br />
}<br />
<br />
private void InitializeNat(){<br />
<br />
IUpnpNat NatMgr = (IUpnpNat)new UpnpNatClass();<br />
<br />
foreach(IStaticPortMapping portmap in CurrentCollection)<br />
{<br />
}<br />
}<br />
}<br />
}<br />
The line Of code that has the many asterisks has the problem in which this returned collection is always be null that is why i can't iterate through the available external ip addresses or ports . so is there any solution regarding that . AT Msdn explains that but it doesn't seem that this collection returned with value null with them at all . If this problem is solved the whole problem will be vanished.
Is there any Solutions Freaks.
Human knowledge belongs to the world.
|
|
|
|
|
There could be many issues.
You should be discovering devices, not creating them. Do a DISCOVER for all nat devices on the network, then iterate to the correct one, and use that instance, to get more info (yes, the design of UPnP requires another call at this stage). then you should have the correct info.
That said, many UPnP devices arent using strict HTTP spec's and the UPnP.dll can fail sometimes. In that case you will have to write your own.
Other than that, have you looked ta Intel's UPnP tools? They written for .NET 
|
|
|
|
|
thanks leppie for your great answer .
it is obviously clear that i can iterate through all Nat Devices on the network and it is really easy task but the problem in which --->what device i can choose (if i had many) and on what basis i choose my specific Nat Device that i will use for negotiatation in the network to open the ports
Human knowledge belongs to the world.
|
|
|
|
|
I'm doing development for a C# Windows Forms application. Currently, users are complaining of copy and paste problems on multiple forms. People are unable to copy and paste in some or all areas of the forms. It either throws an exception (see below) or the copy/paste box is grayed out.
System.Threading.ThreadStateException: The current thread must set to Single Thread Apartment (STA) mode before OLE calls can be made. Ensure that your Main function has STAThreadAttribute marked on it.
at System.Windows.Forms.Clipboard.GetDataObject()
at C1.Win.C1Input.C1TextBox.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
I have researched this alot and it seems to be some sort of Windows threading issue. The application is run via No Touch Deployment, which I think defaults to Multi Threaded Apartment, even if you start the app on a STA thread. I have a solution for the copying but I need to know how to hook it up to the Copy / Paste event in Windows forms....Is there a way you can override the Copy and Paste functions in a windows form? For example when you right click on a textbox and choose copy from that little context menu, Can I handle that click event on that menu some how? Could I override the Ctrl C key down call and hook up my own copy??????
This would be of MUCH help!!! Thanks guys
Daniel Gruszka
|
|
|
|
|
I have a couple of DataGridView refreshing problems.
The first one is how to get the datagrid to refresh the data the fastest. I used dataGridView1.Refresh() to refresh the data as it is coming in, but it causes the mouse to lag, without doing the refresh() the mouse and clicking capabilities are fine, but I cant see anything on the DataGridView unless I minimize the window and restore it (or anything that forces the control to redraw. I would like a faster method of updating the data that the DataGridView is using than the dataGridView1.Refresh().
The other problem I am having is when the DataSet table exceeds the size of the DataGridView. The sliders dont show up unless I resize the window. Even the dataGridView1.Refresh() doesn't update that. I want a way to explicitly tell the DataGridView that the size of the DataSet has exceeded its control size.
Any advice or help is much appreciated.
|
|
|
|
|
Well you hit it on the head, the refresh forces the repaint. When you minimize and resize it does pretty much the same thing.
I know of no other alternative than a refresh.
Are you populating the data in the grid in the same form? Is it a long operation to get the data? Watch out for a long operations in any method of the main form, it causes delays in the repaint logic. The application acts like it's dead for a while.
You can use delegates, and invoke.required checks to make it work better if it's a long operation.
|
|
|
|
|
Are you binding a DataGridView directly to a DataSet table instead of going through a BindingSource?
--
I've killed again, haven't I?
|
|
|
|
|
hello all,
I have been trying to make a program to shutdown my computer, i have the program on a timer and at a certian time i would like the program to shutdown my whole computer. i am planning on using it for when i am Burning dvds or listening to music before bed.
i know that the command prompt has a command to shutdown a computer:
/shutdown -s
where u can also use [-t XX] where XX is the time till it shutdowns.
Can someone please help me in this, either by using C to open and use command prompt by itself, or another way.
Thank you Very much.
- Droz -
___ ___
/\/\ /\ | |
|
|
|
|
|
In C#, you could simply call:
System.Diagnostic.Process.Start("shutdown.exe", "-s -f -t 00");
For more info, check this out: click here.
- It's easier to make than to correct a mistake.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
