Loading

instead of now i want the details keyed in the form

rus tan

7y585

string insert =

@"INSERT INTO Leave( LeavesTaken,Days,Reason,StartDate,EndDate,Status,UserId, Ishalfday) VALUES

( '{0}', '{1}', '{2}','" + DateTime.Now.ToString("yyyy-MM-dd") + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "', 0,'{3}',0)";

how do i change instead of now simply just convert it to string

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Salman Beg7y ago
Hi. We can use DateTime.Parse or DateTime.TryParse etc. For more you can follow up with this link, https://stackoverflow.com/questions/3477735/how-to-convert-datetime-to-from-specific-string-format-both-ways-e-g-given-fo/3477768
0