C# Discussion Boards - CodeProject

row and column count of excel file

20-Feb-06 16:29

Leo Smith wrote:
DirectX

Add a reference in your project references to Microsoft.DirextX.dll

edel_ong20-Feb-06 14:24

edel_ong

20-Feb-06 14:24

how do i get the row and column count of an excel file using C#?

Thanks very much!

Re: row and column count of excel file

Judah Gabriel Himango20-Feb-06 16:31

How to turn off executing Load event at design time feature?

20-Feb-06 16:31

You'll probably want to start by looking into the Microsoft Visual Studio Tools for Office[^].

t800t820-Feb-06 13:57

Re: How to turn off executing Load event at design time feature?

20-Feb-06 13:57

I try to write a class that extends Form like that:

<br />
    public partial class BaseForm : Form<br />
    {<br />
<br />
        public BaseForm()<br />
        {<br />
            InitializeComponent();<br />
        }<br />
<br />
        private void BaseForm_Load(object sender, System.EventArgs e)<br />
        {<br />
            MessageBox.Show("Hello, World!");<br />
        }<br />
<br />
    }<br />

And then I write a class that extends class BaseForm

<br />
    public partial class MyForm : BaseForm<br />
    {<br />
<br />
        public MyForm()<br />
        {<br />
            InitializeComponent();<br />
        }<br />
<br />
    }<br />

I rebuild project and open MyForm to design, it suddenly appears "Hello, World!" message box.

I think it is a stupid feature in VS 2005 (I didn't check it in VS 2002, 2003 yet). How can I turn off this feature?

http://t800t8.blogspot.com/2006/02/thc-thi-s-kin-load-khi-ang-design-form.html

I'm ...
a fan of Manchester United
a fan of Ozzy Osbourne
a King of Nothing

-- modified at 19:58 Monday 20th February, 2006

[Marc]20-Feb-06 14:20

[Marc]

20-Feb-06 14:20

private void BaseForm_Load(object sender, System.EventArgs e){
protected override void OnLoad(System.EventArgs e){
  if (!base.<a href = "http://msdn2.microsoft.com/en-us/library/system.componentmodel.component.designmode.aspx" rel="nofollow">DesignMode</a>[<a href = "http://msdn2.microsoft.com/en-us/library/system.componentmodel.component.designmode.aspx" target = "_blank" rel="nofollow">^</a>]){
    MessageBox.Show("Hello, World!");
  }
}

"..Commit yourself to quality from day one..it's better to do nothing at all than to do something badly.."
-- Mark McCormick

|| Fold With Us! || Pensieve || VG.Net ||

-- modified at 20:20 Monday 20th February, 2006

Re: How to turn off executing Load event at design time feature?

t800t820-Feb-06 14:30

Re: How to turn off executing Load event at design time feature?

20-Feb-06 14:30

This code, it works. Thanks! Smile | :)

private void BaseForm_Load(object sender, System.EventArgs e){<br />
  if (!base.DesignMode){<br />
    MessageBox.Show("Hello, World!");<br />
  }<br />
}

I'm ...
a fan of Manchester United
a fan of Ozzy Osbourne
a King of Nothing

Dave Kreskowiak20-Feb-06 17:35

Re: How to turn off executing Load event at design time feature?

20-Feb-06 17:35

You think this is a stupid feature? How do you think controls work when you drop them on your form? There's nothing that magically renders them at design time without running the code that's in them. You MUST run code in the controls in order to see them on the form!

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

t800t820-Feb-06 17:57

Re: How to turn off executing Load event at design time feature?

20-Feb-06 17:57

Render? Did you forget InitializeComponent() method in constructor?

I just have some questions for you.

+ Do you like it shows a message like in my example at design time?
+ Do you like to get an error message and can not design your form when you only want to load the picture at runtime like this button1.Image = Image.FromFile(Constant.IMAGES_DIRECTORY_PATH + "Back.jpg"); ?

These only some simple cases. If you like them, this stupid feature is for you!

I'm ...
a fan of Manchester United
a fan of Ozzy Osbourne
a King of Nothing

J4amieC20-Feb-06 21:47

J4amieC

20-Feb-06 21:47

This is exactly why the form exposes a DesignTime property as pointed out above

Re: How to turn off executing Load event at design time feature?

Dave Kreskowiak21-Feb-06 13:23

Re: How to turn off executing Load event at design time feature?

21-Feb-06 13:23

If you code your components correctly, this isn't a problem!

Yes, I've written many of my own components, and yes, this "stupid feature" as you call it, is what made developing these components remarkably easy.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

t800t821-Feb-06 13:28

Re: How to turn off executing Load event at design time feature?

21-Feb-06 13:28

Can you show me the correct way to write a component? I want to see if it is correct or not. Wink | ;-)

I'm ...
a fan of Manchester United
a fan of Ozzy Osbourne
a King of Nothing

Dave Kreskowiak21-Feb-06 15:57

Re: How to turn off executing Load event at design time feature?

21-Feb-06 15:57

Funny! What do you think we've been trying to tell you!?

Why is it so hard to accept that when you drop a component on a form, the code in it runs at design time?!

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

t800t821-Feb-06 16:05

Re: How to turn off executing Load event at design time feature?

21-Feb-06 16:05

I told you the reason why I think this feature is stupid. But you, nothing.

I just want to give you an opportunity to defend your idea. And if you cannot defend it, I will keep my idea until I find it fail.

Don't wasting my time! Wink | ;-)

I'm ...
a fan of Manchester United
a fan of Ozzy Osbourne
a King of Nothing

Dave Kreskowiak22-Feb-06 1:52

22-Feb-06 1:52

I don't have to!

Just try and develop a control without that functionality! Of course, you can't turn it off, so, you'll just have to imagine that when you drop your control on a form to test it, nothing happens! You get a nice black hole where your control should paint itself. Why? Your rendering code doesn't run until you hit F5. You try changing a couple of properties to see if the rendering code is OK or see what the affects are, and nothing happens, until you hit F5. What a pain...

It makes developing controls much easier to write and debug. If your skills can't handle that, well, ...

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Media Player Control

Sean8920-Feb-06 13:57

Sean89

20-Feb-06 13:57

How do I get a windows media player control on my webpage?

Thanks Poke tongue | ;-P

Sean

Re: Media Player Control

Judah Gabriel Himango20-Feb-06 16:33

Dynamically registering events with a remote object

20-Feb-06 16:33

You can find all the necessary information over at Microsoft's Windows Media Player SDK pages[^].

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Connor's Christmas Spectacular!
Judah Himango

Steven Williamson20-Feb-06 12:21

Steven Williamson

20-Feb-06 12:21

Ok where do i begin...
well i am trying to come up with a solution to allow me to register event handlers with an event dynamically. Consider the following code

<br />
if (aEvent.Name.CompareTo("getFilesCalledEvent") == 0)<br />
{<br />
    Delegate myDel =Delegate.CreateDelegate(aEvent.EventHandlerType,<br />
                    this, "EventCalled");<br />
    aEvent.AddEventHandler(this, myDel);<br />
}<br />

As far as im concerned this should register the method EventCalled contained in the running instance of the object pointed to by (this).
When executed i get the exception "Object does not match target type", when i call the AddEventHandler Method.

As far as i can assume this is because im using remoting, see aEvent is actually an EventInfo type returned from a remote object. So im guessing the delegate im passing in is actually trying to point to a local instance. But im registering it with a remote object, so when it tries to call back to the class that holds EventCalled it does not know to go through the remoting framework? Ie The object is pointing to does not exist in the context of the remote object.

This is my best guess anyone who can help your a godsend!

Use VS2005 designer to create Panel?

Ravi Bhavnani20-Feb-06 11:57

Ravi Bhavnani

20-Feb-06 11:57

It's easy enough to craft a Form by dragging controls onto it from the toolbox, but can the same thing be done to create a standalone Panel class? I know I can drag controls onto a Panel that's part of a Form, but I'd like to design a reusable panel independent of its parent Form.

Thanks,

/ravi

My new year's resolution: 2048 x 1536
Home | Music | Articles | Freeware | Trips
ravib(at)ravib(dot)com

Re: Use VS2005 designer to create Panel?

SHaroz20-Feb-06 13:15

SHaroz

20-Feb-06 13:15

Add a new control to your project. Right click your project; select Add->New Item; then select User Control.

Hope this helps.
-SHaroz

Re: Use VS2005 designer to create Panel?

Ravi Bhavnani20-Feb-06 13:21

Ravi Bhavnani

20-Feb-06 13:21

Thank you, SHaroz! Rose | [Rose]

/ravi

My new year's resolution: 2048 x 1536
Home | Music | Articles | Freeware | Trips
ravib(at)ravib(dot)com

Remote Copy/paste

IceWater4220-Feb-06 11:55

IceWater42

20-Feb-06 11:55

I am trying to get a commercial program to copy it's text file to the clipboard.

This code activates the correct window, brings it to the foreground and processes the mouse clicks:

input.mi.dx = 950;
input.mi.dy = 300;

SetCursorPos(input.mi.dx, input.mi.dy);
SetForegroundWindow(commercialWindowHandle);

input.mi.dwFlags = (MOUSEEVENTF_ABSOLUTE + MOUSEEVENTF_LEFTDOWN);
resSendInput = SendInput(1, ref input, Marshal.SizeOf(input));

input.mi.dwFlags = (MOUSEEVENTF_ABSOLUTE + MOUSEEVENTF_LEFTUP);
resSendInput = SendInput(1, ref input, Marshal.SizeOf(input));

I have verified that the above code works all the time ... but the following code sometimes works ... mosttimes doesn't !!! :

SendKeys.Send("^{a}"); // Select all text
SendKeys.Send("^{c}"); // Copy to clipboard

(It would also be nice if i could set the mouseDown and mouseUp relative to the foreground window instead of to the absolute screen but that is not my primary concern right now)

Thanks in advance for any insight.

-- modified at 19:38 Monday 20th February, 2006

Re: Remote Copy/paste

Judah Gabriel Himango20-Feb-06 16:36

Re: Meta tag reading in c#

20-Feb-06 16:36

Try SendWait instead of Send. Also, if that doesn't work, make a call to Application.DoEvents after each SendKeys.SendWait call.

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Connor's Christmas Spectacular!
Judah Himango

Re: Remote Copy/paste

IceWater4221-Feb-06 2:14

IceWater42

21-Feb-06 2:14

Thanks for the suggestions, Judah

I tried them all ... but none worked. Surprisingly, this DID work ... the code has been working 100% of the time so far (knock on wood):

int pauseTime = 100;
System.Threading.Thread.Sleep(pauseTime);
SendKeys.Send("^(a)");
SendKeys.Send("^(c)");

It appears that the commercial program just needed some time between the mouse simulation and the keyboard simulation. Surprise! Surprise!

Meta tag reading in c#

rizwan_rashid20-Feb-06 11:25

rizwan_rashid

20-Feb-06 11:25

i want read a html and to extract the attribute's value given within tag.e.g .i want to extract values of attributes name and content.plz help me ...Rizwan

Judah Gabriel Himango20-Feb-06 16:41