How to convert Integer value to Datetime value? - C# Discussion Boards

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...

Re: static keyword like C++

Guffa31-Jul-06 13:23

Guffa

31-Jul-06 13:23

There are no static local variables in C#.

Declare it in the class. It's stored exaclty the same as a static local is in C++. The only thing that differs is the scope.

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

Re: static keyword like C++

Kamal Sagar1-Aug-06 2:05

Kamal Sagar

1-Aug-06 2:05

If you write a variable in a method and does not make it global it will be static only for that function not for all classes.

my INSERT is not working

Tom Wright31-Jul-06 10:40

Tom Wright

31-Jul-06 10:40

I'm not getting an exception when my code runs thru this method, but it's also not writing out this record. Any suggestion?

<br />
		private void WriteRecord(byte[] ByteBuffer, int TrackNumber)<br />
		{<br />
			//Get Query record and write response to it. <br />
			SqlConnection myConnection = new SqlConnection(strConnect);<br />
			SqlDataReader myReader = null;<br />
			SqlTransaction transaction = myConnection.BeginTransaction();<br />
			try<br />
			{<br />
				myConnection.Open();<br />
				SqlCommand myCommand = new SqlCommand("SELECT * FROM DMV2 WHERE DMV2_TRACK_NO = " + TrackNumber + " AND DMV2_RCD_TYPE = 'Q'", myConnection);<br />
				myCommand.Connection = myConnection;<br />
				myReader = myCommand.ExecuteReader();<br />
				myReader.Read();<br />
			<br />
<br />
				String DMV2_T_KEY = myReader["DMV2_T_KEY"].ToString();<br />
				String DMV2_UNIT_NO = myReader["DMV2_UNIT_NO"].ToString();<br />
				String DMV2_QUERY_TYPE = myReader["DMV2_QUERY_TYPE"].ToString();<br />
				String DMV2_TRACK_NO = myReader["DMV2_TRACK_NO"].ToString();<br />
				String DMV2_ORG_DTTM = myReader["DMV2_ORG_DTTM"].ToString();<br />
				String DMV2_ORG_WORKSTATION = myReader["DMV2_ORG_WORKSTATION"].ToString();<br />
				String DMV2_ORG_ID = myReader["DMV2_ORG_ID"].ToString();<br />
				String DMV2_RCV_WORKSTATION = myReader["DMV2_RCV_WORKSTATION"].ToString();<br />
<br />
				String myText = "INSERT INTO DMV2" +<br />
					            "(DMV2_RCD_TYPE, DMV2_QUERY_TYPE, DMV2_TRACK_NO, DMV2_T_KEY, DMV2_UNIT_NO, " +<br />
					            "DMV2_ORG_DTTM, DMV2_ORG_WORKSTATION, DMV2_ORG_ID, DMV2_RCV_DTTM, DMV2_RCV_WORKSTATION, " +<br />
					            "DMV2_RCV_STATUS, DMV2_DATA_TEXT)" +<br />
					            "VALUES ('R', '" + DMV2_QUERY_TYPE + "', '" + DMV2_TRACK_NO + "', '" + DMV2_T_KEY + "', '" + DMV2_UNIT_NO + <br />
                                 "', '" + DMV2_ORG_DTTM + "', '" + DMV2_ORG_WORKSTATION + "', '" + DMV2_ORG_ID +<br />
					             "', CURRENT_TIMESTAMP, '" + DMV2_RCV_WORKSTATION + "', 'P','" + ByteBuffer.ToString() + "')";<br />
				myCommand = new SqlCommand(myText, myConnection, transaction).ExecuteNonQuery();<br />
				transaction.Commit();<br />
			}<br />
			catch(SqlException sqlError)<br />
			{<br />
				MessageBox.Show(sqlError.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);<br />
				transaction.Rollback();<br />
			}<br />
			<br />
			myConnection.Close();<br />
		}<br />
<br />
<br />

Tom Wright
tawright915@yahoo.com

Re: my INSERT is not working

Empires31-Jul-06 12:22

Empires

31-Jul-06 12:22

You should switch to stored procedures if possible. One thing I see is this 'ByteBuffer.ToString()', this is going to return System.Byte[] -- thats all I see from here, the problem is probably a datatype. Copy the myText to your clipboard during an execution and try to run that query exactly as it was copied into SQL Query Analyzer, or use SQL Profiler to see whats happening.

Empires

Re: my INSERT is not working

Tom Wright31-Jul-06 12:30

Tom Wright

31-Jul-06 12:30

Yeah I'm seeing System.Byte[]. Thanks for the heads up on that. However, if I put a messagebox(I can't step thru it on my pc so I have to use message boxes to see where I am at in the code) before the string is put together, but after the select statement is run, nothing pop's up. It's like it just dropping out of the method with out returning an exception. It's strange.

Would an SP work faster since it's server side? Or does it just make it easier to insert rows?

One other thing. Is looks like the primary key is a seeded key. Would this be something that could be causing the problem?

Thanks

Tom Wright
tawright915@yahoo.com

Re: my INSERT is not working

Colin Angus Mackay31-Jul-06 12:36

Colin Angus Mackay

31-Jul-06 12:36

Tom Wright wrote:
Would an SP work faster since it's server side? Or does it just make it easier to insert rows?

Or even make your application more secure - which is the primary reason I use stored procedures.

Scottish Developers events:
* .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy
* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog

Re: my INSERT is not working

Colin Angus Mackay31-Jul-06 12:39

Colin Angus Mackay

31-Jul-06 12:39

Tom Wright wrote:
private void WriteRecord(byte[] ByteBuffer, int TrackNumber)

Tom Wright wrote:
SqlCommand myCommand = new SqlCommand("SELECT * FROM DMV2 WHERE DMV2_TRACK_NO = " + TrackNumber + " AND DMV2_RCD_TYPE = 'Q'", myConnection);

I don't see how this even compiles as TrackNumber is an int.

You should read about SQL Injection Attacks because this code is perfect for attacking. Here is an article that tells you What a SQL Injection Attack is, how it works, how to spot code that is susceptable and how to write better code[^]

Re: my INSERT is not working

Christian Graus31-Jul-06 19:18

Christian Graus

31-Jul-06 19:18

Colin Angus Mackay wrote:
I don't see how this even compiles as TrackNumber is an int.

C# will work this out for you, if you concatenate a string and an int.

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

Re: my INSERT is not working

Colin Angus Mackay31-Jul-06 20:32

Colin Angus Mackay

31-Jul-06 20:32

Christian Graus wrote:
C# will work this out for you, if you concatenate a string and an int.

I just tried it. So it does.

Re: my INSERT is not working

Tom Wright3-Aug-06 10:48

Tom Wright

3-Aug-06 10:48

Learn something new everyday.

By the way I haven't read that link yet, but I did move all of the SQL statements to a SP. It works much better and seems like less of a headache. I should have done that a long time ago. I think I will still change how I'm passing my parameters to the SP as I'm still concatenating them together and do an ExecuteNonQuery. I think I'll look in to the parameters way of passing them, as well as read the link you sent me.

Thanks

Tom Wright
tawright915@gmail.com

Compressing directrory tree into single zip file

Ilia Blank31-Jul-06 10:09

Ilia Blank

31-Jul-06 10:09

What is a best approach for compressing directories structure witch contains multipile files into single zip file using c#.

Re: Compressing directrory tree into single zip file

Dustin Metzgar31-Jul-06 10:42

Dustin Metzgar

31-Jul-06 10:42

SharpZipLib[^]

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

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