Re: Get Date And Time - C# Discussion Boards

AnnnS31-Jul-06 21:02

31-Jul-06 21:02

hI can anybody tell me how can i make a copy of one worksheet (excel) in the same work book .. i tried worksheets.copy method .. but it copies all the work sheets .. can any body suggest an idea???

Thanx

Akhil

Re: interop.excel

Abhishek Chatterjee7-Aug-06 3:26

Abhishek Chatterjee

7-Aug-06 3:26

u can point to the worksheet and then copy.. i think u r trying the worksheets object

regards,
abhishek

"If u believe in psychokinesis then raise my hand." Smile | :)

Ole object datatype in access database

Nagraj Naik31-Jul-06 20:40

Nagraj Naik

31-Jul-06 20:40

Hi All,
I am using Access database.
I want to store image/excel file for this purpose i decide to use OLE object datatype of access.But could not get sample code for my purpose.

If anyone know any link please pass to me.

Thanks,
Nagraj

installtion key

Shah Khalid31-Jul-06 20:08

Shah Khalid

31-Jul-06 20:08

I want my software to be installed only after the installtion key provided by me. please tell me how can i do that.
I have developed my project in C#.net and I am using Visual Studio.net 2003.

shah khalid

shah khalid

Re: installtion key

Vipin Venugopal31-Jul-06 20:32

Vipin Venugopal

31-Jul-06 20:32

hard code ur Key to ur program and check with the input. if the input matches the Key u hardcoded into ur project, execute it or else just pop up a message telling wrong product key! Try again.

Vipin

Re: installtion key

Kamal Sagar1-Aug-06 1:44

Kamal Sagar

1-Aug-06 1:44

Have you made any software if yes than please tell me which software you have made.

[Message Deleted]

Rahul.RK31-Jul-06 20:03

Rahul.RK

31-Jul-06 20:03

[Message Deleted]

Re: Get Date And Time

Vipin Venugopal31-Jul-06 20:34

Vipin Venugopal

31-Jul-06 20:34

probably u can get the time from the server from which ur web application is running which can be linked to ur window application.

Vipin

Re: Get Date And Time

Michael P Butler31-Jul-06 22:46

Michael P Butler

31-Jul-06 22:46

http://www.codeproject.com/cs/internet/ntpclient.asp[^]

Michael

CP Blog [^] Development Blog [^]

Time Based Operation

VenkataRamana.Gali31-Jul-06 20:00

VenkataRamana.Gali

31-Jul-06 20:00

Hi
in .NET 1.1 application, I did one alert application.

but i want to display this alert at perticular time (say to day 3:00 PM).

How to do this.?

any sounds appritiated

regards
GV Ramana

Re: Time Based Operation

Vipin Venugopal31-Jul-06 20:36

Vipin Venugopal

31-Jul-06 20:36

Just take the system time and check with the time u set in ur program. when both matches do so action.

Vipin

Re: Time Based Operation

VenkataRamana.Gali31-Jul-06 22:05

VenkataRamana.Gali

31-Jul-06 22:05

Hello

in my application, user choice to save alert time. When user will saves the alert time, at that time i am storing the time in xml file.

now i want to show the alert at perticular time. here my application still runs hiddenly(showing as taskbar icon)

i need long running timer?
how to do this?

regards
GV Ramana

Re: Time Based Operation

Kamal Sagar1-Aug-06 1:46

Kamal Sagar

1-Aug-06 1:46

Before alert Message check whether system is what you want

How does cab files work

JacquesDP31-Jul-06 19:54

JacquesDP

31-Jul-06 19:54

Hi all.

I want to use cab files with the installer, so that I only need to update the files that has changed.

Can anyone tell me how to do this or how it works??

Thanks in advance.

He who laughs last is a bit on the slow side

3D Model Viewer

eggie531-Jul-06 19:30

eggie5

31-Jul-06 19:30

I have no experience w/ directx. So, i'm looking to learn. In particular, I want to take a 3D model of an object and display it on my app using directx. Also, I want to feed that model X,Y,Z values and have it rotate itself respectively.

Can somebody point me to an example or something that does something link this? Also, I don't know how to make my "model" either, i'd be happy if it was just a square. Do I create it in some 3d app and then load that file into directx?

For example, say I have a square model. I just want to show it in my C# win form and send it some Cartesian values X,Y,Z and have it rotate relative to some point.

/\ |_ E X E GG

Re: 3D Model Viewer

Dustin Metzgar1-Aug-06 5:22

Dustin Metzgar

1-Aug-06 5:22

Have you checked out the DirectX tutorials that come with the managed DirectX SDK?

Logifusion[^]
If not entertaining, write your Congressman.

Changing Skin

Harikrk31-Jul-06 16:20

Harikrk

31-Jul-06 16:20

I am doing a desktop application in C#. I want to change the appearance of the windows in the porject. It want to avoid the common windows appearance. I want to get a MAC like apperance. Can anyone please tell me an idea for achieving this in C#.
Thanks

Regards
Hari

Re: Changing Skin

Christian Graus31-Jul-06 19:16

Christian Graus

31-Jul-06 19:16

Your absolute best bet would be to use Avalon/WPF/.NET 3.0, a new framework ( still in beta ) that gives you a lot of control over how the UI looks.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Re: Changing Skin

Harikrk1-Aug-06 4:20

Harikrk

1-Aug-06 4:20

thanks for the reply
But from where i can get that framework?

How to convert Integer value to Datetime value?

bigeyed31-Jul-06 14:32

bigeyed

31-Jul-06 14:32

Hi..

I get 5 int values
For instance, they will look like the below...
int a = 2006; //year
int b = 3; //month
int c = 5; //day
int d = 1; //hour
int e = 3; //min
int f = 2; //second

but I want to put them in DB looks like "20060305010302" which means..
year has to be 4 digit, month has to be 2digit, day has to be 2digit..and so on...

so if I get the month data number 5, then I have to be able to convert number to 05 (because the DB column character is set for "yyyy:MM:dd:HH:mm:ss".

can I do this in one shot?? I can't think of anything good...
what i'm thinking is that comparing the length and if the length is shorter than 2 then, put the "0" in front of the number.... -_-...

please help... thanks

Re: How to convert Integer value to Datetime value?

chrismerrill31-Jul-06 15:54

chrismerrill

31-Jul-06 15:54

You can create a DateTime object and then use a Custom DateTime Format String.

For Example, this generates the output you want:
DateTime d = new DateTime (2006,3,5,1,3,2);
d.ToString ("yyyyMMddhhmmss");

MSDN Custom DateTime Format Strings

Hope this Helps,
Chris

Re: How to convert Integer value to Datetime value?

Guffa31-Jul-06 19:08

Guffa

31-Jul-06 19:08

Slight correction to the format string; "hh" gives hours in the range 1-12, use "HH" to get hours in the range 0-23:

DateTime d = new DateTime (2006,3,5,1,3,2);<br />
d.ToString("yyyyMMddHHmmss");

---
b { font-weight: normal; }

Detecting Ctrl + arrow keys

Libor Tinka31-Jul-06 12:36

Libor Tinka

31-Jul-06 12:36

I need to distinguish Ctrl and Ctrl+arrow key commands in my app. Using ProcessCmdMsg rather than OnKeyDown handler allows me to register arrow keys, but when user strikes and holds Ctrl key, there are lot of messages with key code equal to this Control key, bud I'm not able to detect both Ctrl as modifier key and arrow key at the same time.

Re: Detecting Ctrl + arrow keys

Jay Shankar31-Jul-06 15:34

Jay Shankar

31-Jul-06 15:34

You can please try the below:

private void Form1_KeyDown(object sender, System.Windows.Forms.KeyEventArgs e)
{
	if ( e.Control && e.KeyCode == Keys.Up )
	{
		this.Text = "Control key + Up Key pressed";
	}
	else
	{
		this.Text = "Other Key pressed";
	}
}

static keyword like C++

Maksymus00731-Jul-06 12:29

Maksymus007

31-Jul-06 12:29

how to do like it was in C++
int fun() {
static int i = 0;
i++;
}

in general - i want a static varible in method - not static for all class but static only for one method..

Ideal compilator compiling comments without code...

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