How to turn off executing Load event at design time feature? - C# Discussion Boards

Acheive_it20-Feb-06 17:30

20-Feb-06 17:30

Hi guys,

Repeatedly am posting this question..But each time hopeful of getting solution from you.....

I have to export datas to Excel database...If i want to specify the Format of the data(that's:General,Number,Currency.....)..How can i do it?

Also,now am managed to assign a custom format for the cells like,
mExcelRange.EntireColumn.NumberFormat="#,###";(for integers...)...

Am exporting the data and setting the format for them ,each seperately provided that datas are in a datatable...If i set the range,then asssign the (custom)format for each datacolumn..the result is tht the format that has been set for the lastly iterated column is been set to all other columns too..

Please help me in tackling these two problems...
1.Setting Format for cells..
2.Setting Range...

Thanx

Re: Excel in C#

ChevyVanDude21-Feb-06 5:00

ChevyVanDude

21-Feb-06 5:00

Hmmmmm...... i don't know much about it, but try:
http://msdn.microsoft.com/vstudio/products/compare/default.aspx
There you can find what options you have in differant versions of VB.

How use Paging DataGird in WinForms

AnhTin20-Feb-06 17:02

AnhTin

20-Feb-06 17:02

I want Paging for DataGird in WinForms. i use Dataset/DataTa D'Oh! | :doh:

ble fill Data on DataGird
can u move solve this problem to me. The Best if u give Example to me

So I think to syntex Select Top but it unable.

I try to use syntax ds.table["name"].Select , ds.table["name"].Rows['number'] but unSuccessful

it dose'nt get 10 rows in dataset

thanks

Mr AnhTin

DirectX Compiler Error

Leo Smith20-Feb-06 16:18

Leo Smith

20-Feb-06 16:18

I am having a problem compiling DirectX in my C# apps. I get the following error during compile time.

type or namespace name 'DirectX' does not exist in the class or namespace 'Microsoft' (are you missing an assembly reference?)

I installed the DirectX 9 SDK after installing Visual Studios. Am I missing something. When I enter "using Microsoft." DirectX does not come up on the list.

Thanks,

Leo T. Smith

Re: DirectX Compiler Error

Judah Gabriel Himango20-Feb-06 16:29

Judah Gabriel Himango

20-Feb-06 16:29

Leo Smith wrote:
DirectX

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

row and column count of excel file

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

Judah Gabriel Himango

20-Feb-06 16:31

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

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

t800t820-Feb-06 13:57

t800t8

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

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

[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

t800t8

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

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

Dave Kreskowiak20-Feb-06 17:35

Dave Kreskowiak

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

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

t800t820-Feb-06 17:57

t800t8

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

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

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

Dave Kreskowiak

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

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

t800t821-Feb-06 13:28

t800t8

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

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

Dave Kreskowiak21-Feb-06 15:57

Dave Kreskowiak

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

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

t800t821-Feb-06 16:05

t800t8

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

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

Dave Kreskowiak22-Feb-06 1:52

Dave Kreskowiak

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

Judah Gabriel Himango

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

Dynamically registering events with a remote object

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

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.