c# - Inserting multiple values between daterange into DB -

i have form collects 2 dates (start date & end date) in format mm/dd/yyyy

i want collect these 2 dates form, , create list of dates between these 2 days, insert them seperate rows in mt database. here code:

if(ispost){     var bookedfrom = request.form["datefrom"];     var bookedto = request.form["dateto"];      datetime datef = convert.todatetime(bookedfrom);     datetime datet = convert.todatetime(bookedto);      var dates = new list<datetime>();      (var dt = datef; dt <= datet; dt = dt.adddays(1))     {        dates.add(dt);     }      foreach(var dat in dates){         db.execute("insert property_availability (propertyid, bookeddate, bookednotes, bookedtype) values (@0, @1, @2, @3)", rpropertyid, dat, request.form["bookednotes"], request.form["bookedtype"]);     } } 

however, when try , post form, following error:

string not recognized valid datetime. datetime datef = convert.todatetime(bookedfrom);

any idea i'm going wrong?

thanks

just 2 cents in out, consider using debug know whether values passed / etc.

 if(ispost){     datetime pfrom = new datetime();     datetime pto = new datetime();      var bookedfrom = request.form["datefrom"];     var bookedto = request.form["dateto"];      if(datetime.tryparse(bookedfrom, out pfrom) && datetime.tryparse(bookedto, out pto))     {         datetime datef = pfrom;         datetime datet = pto;          var dates = new list<datetime>();          (var dt = datef; dt <= datet; dt = dt.adddays(1))         {            dates.add(dt);         }          foreach(var dat in dates){             db.execute("insert property_availability (propertyid, bookeddate, bookednotes, bookedtype) values (@0, @1, @2, @3)", rpropertyid, dat, request.form["bookednotes"], request.form["bookedtype"]);         }     }     else     {         response.write("<script language=javascript>alert('invalid date : " + bookedfrom + " , date : " + bookedto + "');</script>");      } }