Insert todays date

[sdhawan]

HI guys how can i insert todays date in my query,my query is as follows:

myString = @"INSERT INTO wordTbl(word,text,date)  Values('" + (string)row["word"] + "','"+richTextBox1.Text+"','"+DateTime.Now.ToString()+"')";

[nsutton]

I dont know querys but C# has a DateTime.Now method that might help?

[sdhawan]

can i store this in a variable and then i ll be able to pass it in query

[kvprajapati]

Why don't you tell us what you're trying to do and we can tell you how to go about it. You must have to post your problem here.

[finito]

DateTime.Now.ToString("yyyyMMdd hh:mm:ss:fff")

[prajaktaran]

Take a timer contor,label on your form & write following code on timer

label1.Text = DateTime.Noe.ToString();
It cna store and display the current date time.

[domingo]

this website will help you understand better how the date Time and Time Span works
http://www.blackwasp.co.uk/CSharpDateManipulation.aspx

[sdhawan]

sorry for any misunderstanding guys.What i am trying to do is to add a word ina databse and the date that word was added to database. I am trying to write a query to input the word and current date with it.my query looks like this...

myString = @"INSERT INTO wordTbl(word,text,date)  Values('" + (string)row["word"] + "','"+richTextBox1.Text+"','"+DateTime.Now.ToString()+"')";

[finito]

myString = @"INSERT INTO wordTbl(word,text,date)  Values('" + (string)row["word"] + "','"+richTextBox1.Text+"','"+DateTime.Now.ToString("yyyyMMdd hh:mm:ss:fff")+"')";

[sdhawan]

Thanks That worked.Thanks a lot finito.