how to assign a Shortcut key for an Application ONLY in C#? - C# Discussion Boards

Re: exporting data to excel

lourensG4-Sep-07 23:42

lourensG

4-Sep-07 23:42

thank you but isnt there an easier way? I dont want to work with xml files. thanks again

Re: exporting data to excel

Giorgi Dalakishvili4-Sep-07 23:51

Giorgi Dalakishvili

4-Sep-07 23:51

You can use excel object library to convert the generated file to excel native format

#region signature
my articles
#endregion

Re: exporting data to excel

lourensG5-Sep-07 0:04

lourensG

5-Sep-07 0:04

I dont know how to do that sorry Im still new with programming so I dont know alot can you maybe send me some code if its possible please. Thanks again

Re: exporting data to excel

Giorgi Dalakishvili5-Sep-07 0:13

Giorgi Dalakishvili

5-Sep-07 0:13

You can use that article to generate xml file and then convert it to xls using this piece of code:

 <br />
private void savetoexcelformat(string currentpath, string pathtosave)<br />
{<br />
object missing = System.Reflection.Missing.Value;<br />
<br />
Excel.Application app = new Excel.Application();<br />
app.Visible = false;<br />
<br />
app.Workbooks.OpenXML(currentpath, missing,missing).SaveAs(pathtosave, Excel.XlFileFormat.xlWorkbookNormal, missing, missing,<br />
missing, missing, Excel.XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing, missing);<br />
app.Quit();<br />
<br />
}

#region signature
my articles
#endregion

Re: exporting data to excel

lourensG5-Sep-07 0:16

lourensG

5-Sep-07 0:16

Thanks for your help Ill try that. kind regards

txtBox_Leave

Assaf824-Sep-07 22:56

Assaf82

4-Sep-07 22:56

The leave event occure when i push the tab button
What happen with me is when i put the first digit the leave event is called

this the code:
private void txtNewExpDate3_Leave(object sender, EventArgs e)
{
string val = this.txtNewExpDate3.Text;
if (this.txtNewExpDate3.TextLength.Equals(1))
this.txtNewExpDate3.Text = "0" + val;
}
and the MaxLength for the txtNewExpDate3 is 2

I do the same code is the same event in other textbox and it work properly.

Thanks in advance

Assaf

Re: txtBox_Leave

I.explore.code5-Sep-07 0:05

I.explore.code

5-Sep-07 0:05

Hi Assaf

I tried to recreate the bug you stated...but on my machine the code given by u works just fine..i.e. only when u press "TAB" key, does the leave event fire and not in any other case..please retest your code.

thanks and regards

how to assign a Shortcut key for an Application ONLY in C#?

pdoy07084-Sep-07 22:21

pdoy0708

4-Sep-07 22:21

Hello sir/s, im pj.. how can i assign a shortcut key on a certain button, instead of putting an Ampersand ("&") besides the text of the button.. For exampe.. instead of pressing ALT + (the access key) for a button.. i would like only a single key.. like "ENTER" key to be associated with a certain button.. please Give me a sample code or any directions.. Thank you so much..

Re: Shortcut key for an Application ONLY?

Giorgi Dalakishvili4-Sep-07 22:28

Giorgi Dalakishvili

4-Sep-07 22:28

Trap the key you are interested in and invoke the event handler for the button or menu item

#region signature
my articles
#endregion

Re: Shortcut key for an Application ONLY?

pdoy07084-Sep-07 22:34

pdoy0708

4-Sep-07 22:34

Sir, Thank you so much for replying on my message. Can you give me a sample code? I'm really having a hard time figuring out the event handlers, because i tried putting up some codes on the "KeyPress" event, but i only ended up having more errors. Thank you again sir.

Re: Shortcut key for an Application ONLY?

Giorgi Dalakishvili4-Sep-07 22:44

Giorgi Dalakishvili

4-Sep-07 22:44

What errors are you getting? You can check it like this:

<br />
private void Form1_KeyPress(object sender, KeyPressEventArgs e)<br />
       {<br />
           if (e.KeyChar == (char)Keys.A)<br />
           {<br />
             //A was pressed<br />
           }<br />
<br />
           if (e.KeyChar == (char)Keys.B)<br />
           {<br />
             //B was pressed<br />
           }<br />
       }<br />

#region signature
my articles
#endregion

Re: Shortcut key for an Application ONLY?

pdoy07084-Sep-07 23:20

pdoy0708

4-Sep-07 23:20

Yes sir.. but i did it this way.. i was trying to designate the Keypress Event of a Button.. For example.. [Logout] Button..
if ( (e.KeyChar).ToString() == Keys.Escape)
{
if (MessageBox.Show("Do you wish to exit?", "Exit", MessageBoxButtons.YesNo) == DialogResult.No)
return;
this.Close();

}

But its not working..

Re: Shortcut key for an Application ONLY?

Giorgi Dalakishvili4-Sep-07 23:36

Giorgi Dalakishvili

4-Sep-07 23:36

1. If you want to quit your application when escape button is pressed then set form's cancelbutton property will help you.

2. You can test it like this:

<br />
 if (e.KeyChar == (char)Keys.Escape)<br />
                MessageBox.Show("escape was pressed");<br />

It works in the same way for Enter key too

#region signature
my articles
#endregion

Re: Shortcut key for an Application ONLY?

pdoy07084-Sep-07 22:59

pdoy0708

4-Sep-07 22:59

Thank you so much sir.. I was trying to associate the "ENTER" and "/" key for the Event of a Button's Click.. But i could not make it work.. this is the error..
"Error 1 Operator '==' cannot be applied to operands of type 'char' and 'System.Windows.Forms.Keys' ".. I believe that the "Enter" Key is a windows forms key.. how can i CAST it to be something else..

Re: Shortcut key for an Application ONLY?

Giorgi Dalakishvili4-Sep-07 23:11

Giorgi Dalakishvili

4-Sep-07 23:11

Did you cast it to char as I showed in the example?

#region signature
my articles
#endregion

Re: Shortcut key for an Application ONLY?

pdoy07084-Sep-07 23:53

pdoy0708

4-Sep-07 23:53

Thank you so much for that sir.. It works.. Sir, how can i can assign a hotkey to a Button?.. Ahm, for example.. I want a Button_Click event to be associated with a shortcut key.. Instead of me Pressing the Button itself, i just have to press a key from the keyboard.. like; Pressing the F2 key to be associated with
the Event of a Click of a Button.. Im really sorry for this sir.. I ask a lot of questions. I'm just new to C#, and I'm only a student.

Re: Shortcut key for an Application ONLY?

Giorgi Dalakishvili4-Sep-07 23:59

Giorgi Dalakishvili

4-Sep-07 23:59

if (e.KeyChar == (char)Keys.F2)
Button_Click(null,EventArgs.Empty)

#region signature
my articles
#endregion

Re: Shortcut key for an Application ONLY?

pdoy07085-Sep-07 0:26

pdoy0708

5-Sep-07 0:26

Sir, i appreciate it so much.. Thank you very much for all the help that you have lend me.. Thank you so much sir..

Re: Shortcut key for an Application ONLY?

Giorgi Dalakishvili5-Sep-07 0:28

Giorgi Dalakishvili

5-Sep-07 0:28

You are welcome Smile | :)

#region signature
my articles
#endregion

Re: Shortcut key for an Application ONLY?

pdoy07085-Sep-07 0:24

pdoy0708

5-Sep-07 0:24

Sir, thank you so much for all the help that you lend me.. Smile | :)

.. until next time sir..

Re: how to assign a Shortcut key for an Application ONLY in C#?

Luc Pattyn5-Sep-07 0:09

Luc Pattyn

5-Sep-07 0:09

Hi,

for printable characters (letters, digits, punctuation) you should use the KeyPress event;
its event arg provides a KeyChar property which is a char, so don't compare it to
(char)Keys.A instead compare it to 'a' or 'A'.

special characters (escape, enter, ...) don't fire the KeyPress event; you should use
the KeyDown (possibly KeyUp) event for these; its event arg provides a KeyCode property
which is a Keys, so that one you can compare to Keys.Escape and others.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

this weeks tips:
- make Visual display line numbers: Tools/Options/TextEditor/...
- show exceptions with ToString() to see all information
- before you ask a question here, search CodeProject, then Google

Re: how to assign a Shortcut key for an Application ONLY in C#?

Dan Neely5-Sep-07 5:45

Dan Neely

5-Sep-07 5:45

For the specific cases of Enter and Escape there's an easier solution. The AcceptButton and CancelButton properties of the form can be given an event handler as a value (the buttons click handler).

--
If you view money as inherently evil, I view it as my duty to assist in making you more virtuous.

disabling hotkeys

tahir_makhdoom4-Sep-07 22:04

tahir_makhdoom

4-Sep-07 22:04

disable hotkeys ctrl, alt,del,win through c# and then enable code

tahir

Re: disabling hotkeys

Giorgi Dalakishvili4-Sep-07 22:14

Giorgi Dalakishvili

4-Sep-07 22:14

I've already replied to your first post which is the same as this one. It is rude to ask the same question twice. I have given a direction to explore, if you are lazy no one will do the work for you

#region signature
my articles
#endregion

Re: disabling hotkeys

Vasudevan Deepak Kumar4-Sep-07 22:23

Vasudevan Deepak Kumar

4-Sep-07 22:23

The veteran poster had also tried to start up this elite discussion thread in a rated PG non-programming forum (aka) Lounge. Smile | :)

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

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