autogenerate datetime in database

Posted by Saritha.rajeshkumar under C# on 4/25/2011 | Points: 10 | Views : 2836 | Status : [Member] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

hi this saritha, i have 3colums in database username,password,datetime. when i insert username and password, datetime should be generate automatically.

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Ndebata on: 4/25/2011 [Member] Starter | Points: 25

0	Use Getdate() in your query as field to insert it. Saritha.rajeshkumar, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Prabhakar on: 4/25/2011 [Member] [MVP] Starter | Points: 25

0	Hi Saritha.rajeshkumar i think date is automatically not insert in database . . u do this by ur query .. by System.Datetime.Now() Use it . . Best Regard's Prabhakar Saritha.rajeshkumar, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Gokul on: 4/25/2011 [Member] Starter | Points: 25

0	You can use the datetime property in C# by, DateTime dtm = DateTime.Now.Date; string currenttime = dtm.TimeOfDay.ToString(); now you can insert the string currenttime into the DB by Query as string query= insert into Table_Name values('"+txtfirstname+"','"+txtlastname+"','"+dtm+"'); Thanks and Regards GokulNithy. Thanks and Regards, GokulNath Nithy. Saritha.rajeshkumar, if this helps please login to Mark As Answer. \| Alert Moderator

You can use the datetime property in C# by,

DateTime dtm = DateTime.Now.Date;
string currenttime = dtm.TimeOfDay.ToString();

now you can insert the string currenttime into the DB by Query as
string query= insert into Table_Name values('"+txtfirstname+"','"+txtlastname+"','"+dtm+"');

Thanks and Regards
GokulNithy.

Thanks and Regards,
GokulNath Nithy.

Saritha.rajeshkumar, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Tijut2k on: 4/26/2011 [Member] Starter | Points: 25

0	The Best way is Set Default Value or Binding as GetDate() when you are creating the table . so you dont need to pass the date when you are inserting rows into particular table.. Default Value or Binding is located in Columns Properties Best Regard's Tiju Thankachan Saritha.rajeshkumar, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts