RE: ObjectDataSource DateTime isuue with en-gb culture

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,

It's a simple private field with public accessors:

private DateTime _CreateDate;

public DateTime CreateDate
{
get { return _CreateDate; }
set { _CreateDate = value; }
}

Any ideas?

Thanks,

Anne.
"Phillip Williams" wrote:

> Hi Anne,
>
> How do you define the "CreateDate" within the
> "B3.Mailer.BusinessEntities.Campaign" class?
> --
> HTH,
> Phillip Williams
> http://www.societopia.net
> http://www.webswapp.com
>
>
> "Anne Catterick" wrote:
>
> > Hi,
> >
> > I have an british ASP.Net 2.0 application which is doing what (should) be
> > very simple. But I am having issues.
> >
> > On my page I have a GridView as follows (some tags excluded for easy reading):
> >
> > <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
> > DataSourceID="ObjectDataSource1" DataKeyNames="Id"
> > OnRowUpdated="GridView1_RowUpdated">
> > <Columns>
> > <asp:BoundField DataField="CreateDate" HeaderText="Create Date"
> > SortExpression="CreateDate"
> > DataFormatString="{0:d}" ApplyFormatInEditMode="True"
> > ReadOnly="True" HtmlEncode="False">
> > <HeaderStyle Wrap="False" />
> > </asp:BoundField>
> > <asp:CommandField ButtonType="Image"
> > CancelImageUrl="~/images/manager/false.gif"
> > EditImageUrl="~/images/manager/edit.gif"
> > ShowEditButton="True" UpdateImageUrl="~/images/manager/true.gif" />
> > </Columns>
> > </asp:GridView>
> >
> > This is bound to an ObjectDataSource defined as follows:
> >
> > <asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
> > SelectMethod="GetCampaigns"
> > TypeName="B3.Mailer.BusinessEntities.Campaign"
> > DataObjectTypeName="B3.Mailer.BusinessEntities.Campaign"
> > InsertMethod="Insert" UpdateMethod="Update">
> > <SelectParameters>
> > <asp:SessionParameter Name="clientId" SessionField="ClientId"
> > Type="Int32" />
> > </SelectParameters>
> > </asp:ObjectDataSource>
> >
> > The update method is defined as:
> >
> > public static void Update(Campaign campaign)
> > {
> > }
> >
> > However, when I edit a row in the GridView and press the update button I get
> > the following error:
> >
> > [InvalidOperationException: Cannot convert value of parameter 'CreateDate'
> > from 'System.String' to 'System.DateTime']
> > System.Web.UI.WebControls.ObjectDataSourceView.ConvertType(Object value,
> > Type type, String paramName) +485
> > System.Web.UI.WebControls.ObjectDataSourceView.BuildObjectValue(Object
> > value, Type destinationType, String paramName) +217
> > System.Web.UI.WebControls.ObjectDataSourceView.BuildDataObject(Type
> > dataObjectType, IDictionary inputParameters) +548
> > System.Web.UI.WebControls.ObjectDataSourceView.ExecuteUpdate(IDictionary
> > keys, IDictionary values, IDictionary oldValues) +1520
> > System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values,
> > IDictionary oldValues, DataSourceViewOperationCallback callback) +179
> > System.Web.UI.WebControls.GridView.HandleUpdate(GridViewRow row, Int32
> > rowIndex, Boolean causesValidation) +1137
> > System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean
> > causesValidation, String validationGroup) +835
> > System.Web.UI.WebControls.GridView.OnBubbleEvent(Object source, EventArgs
> > e) +162
> > System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +56
> > System.Web.UI.WebControls.GridViewRow.OnBubbleEvent(Object source,
> > EventArgs e) +118
> > System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +56
> > System.Web.UI.WebControls.ImageButton.OnCommand(CommandEventArgs e) +106
> > System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String
> > eventArgument) +200
> >
> > System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +31
> > System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> > sourceControl, String eventArgument) +32
> > System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +72
> > System.Web.UI.Page.ProcessRequestMain(Boolean
> > includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3840
> >
> > This appears to be caused by the date being in UK format (dd/mm/yyyy - which
> > is correct for this application) as dates which could also be in US format
> > (i.e. 12/12/2005) do not throw this error.
> >
> > Both my browser and development machine are set to en-gb but there is no
> > Culture attribute set on the @Page tags on the page.
> >
> > Is this a bug in the ObjectDataSource not conforming to globalization or am
> > I missing somthing?
> >
> > Any help you can give will be much appreciated. Thanks in advance for your
> > help.
> >
> > Regards,
> >
> > Anne.
> >
.

Quantcast