StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POConverting a string into date format in the code behind
primarykey
Id
6128622
data
AcceptedAnswerId
0
AnswerCount
3
ClosedDate
2013-07-02T17:04:55.570
CommentCount
0
CommunityOwnedDate
CreationDate
2011-05-25T17:48:11.880
FavoriteCount
0
LastActivityDate
2011-05-26T04:09:25.063
LastEditDate
2011-05-25T17:57:22.240
LastEditorUserId
535583
OwnerUserId
535583
ParentId
0
PostTypeId
1
Score
0
ViewCount
4982
LastEditorDisplayName
text
Body
I am pulling a date using the Jquery date picker and storing it in a textbox using the following code In the head section <pre><code><script src="Scripts/jquery.ui.datepicker.js" type="text/javascript"></script> <script type="text/javascript"> $(function () { $("#<%= TxtDatepicker_start.ClientID %>").datepicker(); }); </script> <script type="text/javascript"> $(function () { $("#<%= TxtDatepicker_end.ClientID %>").datepicker(); }); </script> </code></pre> In the body section Start Date: <pre><code> &nbsp;&nbsp;End Date: <asp:TextBox ID="TxtDatepicker_end" runat="server" Width = 125px > </asp:TextBox> &nbsp;&nbsp;&nbsp;&nbsp;<asp:Button ID="Button_daterecords" runat="server" Text="Show records" OnClick ="SQLDisplay_Date_records" /> </code></pre> Now the questions is how do I get the value in the text box and convert it to a date (YYYY-MM-DD) format in the code behind ? I tried typecasting it but then I get this error in the code behind cannot implicitly convert system.datetime to system.common.dbparameter The code I am using in the code behind is <pre><code>protected void SqlDataSource2_Selecting(object sender, SqlDataSourceSelectingEventArgs e) { e.Command.Parameters["@username"].Value = HttpContext.Current.User.Identity.Name; e.Command.Parameters["@Txt_selected_start_date"] = DateTime.Parse(TxtDatepicker_start.Text); } </code></pre> Thanks
Tags
<c#><asp.net>
Title
Converting a string into date format in the code behind
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USMervin Johnsingh
UserOwnerUserId
1. USMervin Johnsingh
plurals
PostLinksPostIdRelatedPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
2. PL
 singulars
 LinkTypeLinkTypeId
 LTDuplicate
PostLinksRelatedPostIdPostId
1. PL
 singulars
 LinkTypeLinkTypeId
 LTLinked
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
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.