Posted on: 3/15/2015 11:48:42 PM | Views : 618

It is such that I have no date in the database, and if it is less than the time / date as we have now so it must go in and refresh the use of the will rank 2. This means that we have, for example. the time is now and if it is not right than he who is in the database so it should not go in and do anything at all.
That means if the date looks like this is it too old.
3/15/2015 09:34:42 AM (it is now.) and 3/15/2015 04:34:42 AM
So it must go into the code to update the user to get rank 2
while (readerBrugere.Read()) { string brugerid = readerBrugere["id"].ToString(); DateTime brugerdato = Convert.ToDateTime(readerBrugere["trydato"].ToString()); conn1.Close(); if (Convert.ToDateTime(DateTime.Now.ToString("ddmmyyyyHHmmss")) > Convert.ToDateTime(brugerdato)) { int rankid = 2; cmd1.CommandText = "UPDATE brugere SET r ...

Go to the complete details ...