How to handle date in asp.net application

Question

1.00/5 (1 vote)

See more:

I am creating a web application using asp.net.I am using ajaxtoolkit:calenderextender for date type textbox.Can anyone tell me what is the best option to insert date into sql server and retrive data basis on date.

Posted 3-Mar-14 2:12am

Sandip Paul 491984

Add a Solution

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)

Tom Marvolo Riddle · Answer 1 · 2014-03-03T02:15:00

Solution 1

OP ask:
what is the best option to insert date into sql server and retrive data basis on date

Best option use DateTime[^] datatype.

Always use appropriate datatype to store data in order to perform queries effectively

Posted 3-Mar-14 2:15am

Tom Marvolo Riddle

Updated 3-Mar-14 2:22am

v3

King Fisher · Answer 2 · 2014-03-03T02:19:00

Solution 2

Use the Datatype as Datetime in your table

XML

<asp:CalendarExtender ID="CalendarExtender1" TargetControlID="txtfrom" runat="server" Format="dd/MM/yyyy">
               </asp:CalendarExtender>

Posted 3-Mar-14 2:19am

King Fisher

Comments

Sandip Paul 491984 3-Mar-14 8:21am

is the calender extender date format is dependent on windows date format?

Tom Marvolo Riddle 3-Mar-14 8:23am

It depends on system format in local and server datetime format after hosting

Sandip Paul 491984 3-Mar-14 8:27am

means the computer in which the aspx has been uploaded

Tom Marvolo Riddle 3-Mar-14 8:29am

yup you're right.

Amalraj Ramesh · Answer 3 · 2014-03-03T02:26:00

Send date as string like "2014-03-03"(yyyy-MM-dd) to sp

Sp sample
Create procedure sample
@date varchar(20)
as
begin
// done
end

Aspx

XML

<asp:CalendarExtender ID="CalendarExtender1" TargetControlID="txtfrom" runat="server" Format="yyyy-MM-dd">
               </asp:CalendarExtender>

you can use any format but finally you have to convert to this 'yyyy-MM-dd' format.

Krunal Rohit · Answer 4 · 2014-03-03T03:12:00

First see this tutorial[^] on Ajax Calendar Control.

And then whatever you're saying is this,

XML

<asp:TextBox ID="txtYouDateTime" runat="server" Width="190px" ></asp:TextBox>

<asp:ImageButton runat="Server" ID="ImgCal1" ImageUrl="calendar.png" AlternateText="Click to show calendar" OnClientClick="return false;"  />

<ajaxToolkit:CalendarExtender ID="CalendarExtender1" runat="server"
                    TargetControlID="txtYouDateTime" PopupButtonID="ImgCal1" Format="dd/MMM/yyyy hh:mm" />

String dt = DateTime.Parse(txtYouDateTime.Text).ToString("yyyyMMdd HH:mm:ss")

Now fire the Insert query using dt variable within it.
-KR

Pranav-BiTwiser · Answer 5 · 2014-03-03T03:36:00

Solution 6

INSERT INTO MyTable (MyDate) Values (Convert(DateTime,'"+txtboxname+"',112))

Posted 3-Mar-14 3:36am

Pranav-BiTwiser