datetime - .Net DataTable Date problem -

i working on project , not having database. using dataset of ado.net , store data write xml file , read xml file , load dataset again. xml file project file , have move file system system.

in data set, there column of datetime.

i want store date in field in specific format ( dd/mm/yyyy ).

currently, problem that, detects system's date format , read date. system's date format can vary system system. people use mm/dd/yyyy , use dd/mm/yyyy. so, when format changed, throws exceptions. solution it?

can force datatime field of data table accept date in custom format?

thanks in advance.

i've had similar issues serializing date time in past.

i'd recommend drop datetime field , use string instead. way have full control on format date time object entered dataset.

once have entered in string, need record culture , format datetime recorded in. can either hard code 2 values inside software , hope don't change (not ideal). drop .config file (better).

or

you add additional fields dataset.

mydatefield   - datetime string format.       - "dd/mm/yyyy hh:mm:ss" (for example) culture       - "en-us"  

so when read date dataset instantiate datetime object use.

var datetime = datetime.parseexact([mydatefield], [format], new cultureinfo([culture])); 

*note fields inside [] values retrieved row in dataset.

this way can use datetime field on machine specifying in dataset culture , format provider use.

you need refactor everywhere instanciating datetime field dataset use datetime provider , culture information.

personally, i'd go reading format , culture information .config file these not change on row row basis in dataset.