Unfortunately when writing to a dataset you need to write in American Date.
You will need to convert your date back to british and store.
DataSet.Tables["MyTable"].Rows[x]["mycolumn"] = Convert.ToDateTime(this.txtDob.Text).ToString("MM/dd/yyyy")
>I am storing the current date to a text box with the following code.
>
>
>this.txtDob.Text = System.DateTime.Today.ToString("dd/MM/yyyy") ;
>
>
>I am then trying to save the date into a dataset created from an XML file. When it tries to save this.txtDob.Text I receive the following error.
>
>An unhandled exception of type 'System.ArgumentException' occurred in System.Data.dll
>
>Additional information: Couldn't store
in db Column. Expected type is DateTime.
>
>I have tried using System.DateTime.Parse(this.txtDob.Text) but that causes another error.
>
>I think it's caused by the British date format.
>
>Any ideas on how to proceed?
>
>Thanks.
>
>John
Fred Besterwitch, MCP
The harder you work. The luckier you get.