StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POUnable to cast String to DateTime
primarykey
Id
18546124
data
AcceptedAnswerId
18657775
AnswerCount
4
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-08-31T08:24:39.057
FavoriteCount
0
LastActivityDate
2013-09-06T12:21:28.320
LastEditDate
LastEditorUserId
0
OwnerUserId
2349358
ParentId
0
PostTypeId
1
Score
0
ViewCount
706
LastEditorDisplayName
text
Body
I've following TextBox with ajax calender extender and on TextChanged event I am calling "txtFromDate_TextChanged" function. asp code: <pre><code><asp:TextBox ID="txtFromDate" runat="server" AutoPostBack="True" ontextchanged="txtFromDate_TextChanged"></asp:TextBox> asp:CalendarExtender ID="txtFromDate_CalendarExtender" Format="dd/MM/yyyy" runat="server" Enabled="True" TargetControlID="txtFromDate"> </asp:CalendarExtender> </code></pre> c# code: <pre><code>protected void txtFromDate_TextChanged(object sender, EventArgs e) { if (txtFromDate.Text != "") { DateTime fromdate = Convert.ToDateTime(txtFromDate.Text); Query = Query + "And CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, ord_del_date))) >= '" + fromdate.ToString("yyyy'-'MM'-'dd") + "'"; } } </code></pre> This code is working all fine when i debug through visual studio and even when I host the site on my local IIS server. The problem is that when I host the site on my online hosting server and when I pick a date from calender and calls a textchanged event it gives following error: Error: <pre><code>String was not recognized as a valid DateTime. </code></pre> I know it is giving error because of line: <pre><code>DateTime fromdate = Convert.ToDateTime(txtFromDate.Text); </code></pre> But I am not finding anything wrong in this code. This code is working perfectly fine from visual studio or when hosted on IIS but I am totally confused why it isn't working when hosted on hosting server. I am totally confused. Please help me out.
Tags
<asp.net><c#-4.0><datetime><ajaxcontroltoolkit><textchanged>
Title
Unable to cast String to DateTime
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USSaurabh Palatkar
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. 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. COWell what's the value of `txtFromDate.Text`? And why are you building up SQL dynamically rather than using parameterized SQL? My guess is that the problem is the server using the system-local culture, and that you should use `DateTime.ParseExact` specifying the invariant culture.
 singulars
 PostPostId
 POUnable to cast String to DateTime
 UserUserId
 USJon Skeet

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.