>>dDel_date =DateTime.Parse(TRow["del_date"].ToString().Trim()).Date >>>>and it didn't work.
cDate = DateTime.Parse(TRow["del_date"].ToString()
I triedstrQry = "insert into customer (fname, lname, orddate) " strQry +="values ('"+cfname+"', '"+clname+"', '"+cDate+"')";Then after this
dDate =DateTime.Parse(TRow["del_date"].ToString().Trim()).DateI tried
strQry = "insert into customer (fname, lname, orddate) " strQry +="values ('"+cfname+"', '"+clname+"', "+dDate+")";Either way it won't go into a foxpro DATE field. However, they can both go into foxpro Character field.