Date format issue in asp.net application

Question

0.00/5 (No votes)

See more:

I am using ajaxtoolkit:calender extender for selecting date ,the date format for calender extender is mm/dd/yyyy and my machine date format is mm/dd/yyyy.When i select the any date less than 13 then data is saved in database but when i select the date greater than 12 then a messgae is showing in my application which says that my date format is wrong.

ASPX Code:

XML

<asp:TextBox ID="txtdob" runat="server" CssClass="textb" MaxLength="100" Width="150px"></asp:TextBox>&nbsp
                     <asp:Label ID="Label25" runat="server" CssClass="tranlbl" Text="mm/dd/yyyy"></asp:Label>
                     <ajaxToolkit:CalendarExtender ID="dob" runat="server" TargetControlID="txtdob" Format="MM/dd/yyyy" Enabled="True"></ajaxToolkit:CalendarExtender>
                     <asp:RequiredFieldValidator ID="rfddob" runat="server"  Text="DOB Can Not Be Blank" ControlToValidate="txtdob" CssClass=" validatortextcenter"></asp:RequiredFieldValidator>

CS Code

insert into table (dob) values ('" + datetime.parse(txtdob.text).TosSring("yyyy-MM-dd") + "')

When the date is 03/08/2014 the date is inserting into database but when i select the date greater than 12 then i got error.Please help me !!!

Posted 10-Mar-14 9:01am

Sandip Paul 491984

Add a Solution

Comments

joshrduncan2012 10-Mar-14 15:16pm

insert into table (dob) values ('" + datetime.parse(txtdob.text).TosSring("yyyy-MM-dd") + "')

What is "TosSring"? That should be a red flag right there.

Sandip Paul 491984 10-Mar-14 15:24pm

sry it was typing mistake
it is datetime.parse(txtdob.tex).tostring("yyyy-mm-dd")

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2014-03-10T09:16:00

I would suggest to use stored procedure[^], instead the queries in code behind.
There are 2 resons:
1) possible SQL Injection[^]
2) date time format depends on localization[^] (culture).

Ad 1)
How To: Protect From SQL Injection in ASP.NET[^]
Stop SQL Injection Attacks Before They Stop You[^]
SQL Injection and how to avoid it[^]

Ad 2)
Globalizing and Localizing .NET Framework Applications[^]
How to: Set the Culture and UI Culture for ASP.NET Web Page Globalization[^]
Formatting Date and Time for a Specific Culture[^]
Formatting Numeric Data for a Specific Culture[^]

Finally, your stored procedure might looks like this:

SQL

CREATE PROCEDURE InsertMyData
    @myDate DATETIME
AS
BEGIN
    --temporary change 
    SET DATEFORMAT ymd; --or dmy or mdy
    INSERT INTO TableName (Field) VALUES(@myDate)

END

_Asif_ · Answer 2 · 2014-03-10T09:51:00

Solution 2

Thats the reason experts always recommend to use ISO 8601 date format for server side processing. Check this

ISO_8601[^]

ISO 8601 Format[^]

Posted 10-Mar-14 9:51am

_Asif_

TusharBharambe · Answer 3 · 2014-03-10T19:45:00

I would suggest to use

XML

<asp:TextBox ID="txtStartDate" runat="server" Width="31%"></asp:TextBox>
                 <Ajax:calendarextender id="CalStartDate" runat="server" format="yyyy-MM-dd" targetcontrolid="txtStartDate"></Ajax:calendarextender>
                 <asp:Label ID="lbl_Validate_SD" runat="server" ForeColor="Red"></asp:Label>

Tom Marvolo Riddle · Answer 4 · 2014-03-10T20:26:00

Try this:

DateTime doj = new DateTime(); 
System.Globalization.CultureInfo c1 = new System.Globalization.CultureInfo("en-GB", true);
            doj = DateTime.Parse(txtdob.Text.Trim(), c2, System.Globalization.DateTimeStyles.NoCurrentDateDefault);

and insert like this

C#

insert into table (dob) values ('" + doj.ToShortDateString()+ "')

vsrikanth87 · Answer 5 · 2014-03-13T06:57:00

Solution 5

use this

IFormatProvider Provider = new System.Globalization.CultureInfo("en-US", true);
convert.toDateTime(txtdate.text,provider)

Posted 13-Mar-14 6:57am

vsrikanth87

Date format issue in asp.net application

5 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0