StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POFailed update on custom binding format datetime using EntityDataSource
primarykey
Id
19898448
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-11-11T03:41:33.930
FavoriteCount
0
LastActivityDate
2013-11-11T03:41:33.930
LastEditDate
LastEditorUserId
0
OwnerUserId
2399888
ParentId
0
PostTypeId
1
Score
2
ViewCount
523
LastEditorDisplayName
text
Body
Perhaps this is one of error that was made by a team of ASP.NET developers. I have made data model Celengan like this, format (ColumnName: Type) : <pre><code>Celengan CelenganID: System.Int32 [PK] .. // means other field .. // means other field TanggalPemberian: System.DateTime TanggalPengembalian: System.DateTime .. </code></pre> Then, i created very simple CRUD application on GridView by creating one GridView and EntityDataSource. This my entitydatasource design code from my page (Celengan.aspx) : <pre><code><asp:EntityDataSource ID="CelenganEntityDataSource" runat="server" ConnectionString="name=SmatContext" DefaultContainerName="SmatContext" EnableFlattening="False" EntitySetName="Celengans" Include="Perusahaan" EnableDelete="True" EnableUpdate="True"></asp:EntityDataSource> </code></pre> Looked, i enable two command: <code>EnableDelete="True"</code>, and <code>EnableUpdate="True"</code> And this is my GridView design code: <pre><code><asp:GridView ID="CelenganGridView" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" CellPadding="5" DataKeyNames="CelenganID" DataSourceID="CelenganEntityDataSource" ShowHeaderWhenEmpty="True"> <Columns> <asp:BoundField DataField="CelenganID" HeaderText="ID" ReadOnly="True" SortExpression="CelenganID" > <asp:TemplateField HeaderText="Tanggal Pemberian" SortExpression="TanggalPemberian"> <EditItemTemplate> <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("TanggalPemberian", "{0:dd/MM/yyyy}") %>' Width="80px"></asp:TextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label3" runat="server" Text='<%# Bind("TanggalPemberian", "{0:dd/MM/yyyy}") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Tanggal Pengembalian" SortExpression="TanggalPengembalian"> <EditItemTemplate> <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("TanggalPengembalian", "{0:dd/MM/yyyy}") %>' Width="80px"></asp:TextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label4" runat="server" Text='<%# Bind("TanggalPengembalian", "{0:dd/MM/yyyy}") %>'></asp:Label> </ItemTemplate> <asp:TemplateField ShowHeader="False"> <EditItemTemplate> <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Update" Text="Save" ></asp:LinkButton> <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel" ></asp:LinkButton> </EditItemTemplate> <ItemTemplate> <asp:LinkButton ID="LinkButton3" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit" ></asp:LinkButton> <asp:LinkButton ID="LinkButton4" runat="server" CausesValidation="False" CommandName="Delete" Text="Delete" OnClientClick="return confirm('Apakah celengan ini akan di hapus ?');"></asp:LinkButton> </ItemTemplate> </asp:TemplateField> </asp:TemplateField> </Columns> </asp:GridView> </code></pre> That its, because of my country (Indonesia) use non standard date time format (dd/MM/yyyy), i modified the binding function with <code>"{0:dd/MM/yyyy}"</code> format. But, now the big problem, the modified binding function made the <code>CelenganEntityDataSource</code> cannot update while i try click the <code>LinkButton1</code> with <code>CommandName=Update</code>. Here the following errors message while i try to update: <blockquote> Error while setting property 'TanggalPemberian': 'Cannot convert the value of parameter 'TanggalPemberian' to the type 'System.DateTime'.'. </blockquote> Source Error : <blockquote> An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below </blockquote> Stack Trace : <pre><code>[EntityDataSourceValidationException: Error while setting property 'TanggalPemberian': 'Cannot convert the value of parameter 'TanggalPemberian' to the type 'System.DateTime'.'.] System.Web.UI.WebControls.EntityDataSourceView.ConvertProperties(IDictionary values, PropertyDescriptorCollection propertyDescriptors, ParameterCollection referenceParameters, Dictionary`2 convertedValues) +74592 System.Web.UI.WebControls.EntityDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues) +355 System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) +87 System.Web.UI.WebControls.GridView.HandleUpdate(GridViewRow row, Int32 rowIndex, Boolean causesValidation) +1210 System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +738 System.Web.UI.WebControls.GridView.OnBubbleEvent(Object source, EventArgs e) +89 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37 System.Web.UI.WebControls.GridViewRow.OnBubbleEvent(Object source, EventArgs e) +88 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37 System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +121 System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +156 System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +9642610 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1724 </code></pre>
Tags
<c#><asp.net><date><datetime><gridview>
Title
Failed update on custom binding format datetime using EntityDataSource
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USFathoni Rokhman
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.