7 Replies - 12244 Views - Last Post: 25 March 2013 - 06:12 AM Rate Topic: -----

#1 Adqusit   User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 176
  • Joined: 02-March 13

Why dateTimepicker is not showing proper date and time in Database

Posted 22 March 2013 - 03:02 AM

Hi. I'm using DatetimePicke on my SaleInfo form, for inserting the Date and Time of Sale. The dataType of Sale_Date field in SQL Server 2005 is DateTime. I set the DTP format property to short and then to its original default to Long but in both the cases, when i insert the data so only date is displayed validly but the time is fix to 12:00:00 AM. In Addition to this, i changed its value property (which is originally 3/22/2013 2:59 PM, but i removed the time from the value property). Now please tell me that what is this problem, why the current date and time both are not inserting properly? Please guide me.

Is This A Good Question/Topic? 0
  • +

Replies To: Why dateTimepicker is not showing proper date and time in Database

#2 CharlieMay   User is offline

  • This space intentionally left blank
  • member icon

Reputation: 1729
  • View blog
  • Posts: 5,708
  • Joined: 25-September 09

Re: Why dateTimepicker is not showing proper date and time in Database

Posted 22 March 2013 - 03:44 AM

if you don't supply a time to a datetime it defaults to 12am if you want the time just use the .Value of your datetimepicker upon insertion into the database. Value will put the current time in
Was This Post Helpful? 0
  • +
  • -

#3 Adqusit   User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 176
  • Joined: 02-March 13

Re: Why dateTimepicker is not showing proper date and time in Database

Posted 22 March 2013 - 06:14 AM

Can't i put the value property to its default value?
Was This Post Helpful? 0
  • +
  • -

#4 CharlieMay   User is offline

  • This space intentionally left blank
  • member icon

Reputation: 1729
  • View blog
  • Posts: 5,708
  • Joined: 25-September 09

Re: Why dateTimepicker is not showing proper date and time in Database

Posted 22 March 2013 - 06:22 AM

OK, DateTimePicker. It's used to hold a well, a date and time (or a TimeStamp if you prefer)

As a developer, you have access to a datetime structure which is what is returned from the DataTimePicker's .Value property.

This means that you can break it down even further by specifying .Date which appears to be what you're doing.

Assume you have a datetimepicker with the following showing in the textfield "03/22/2013"

DateTimePicker1.Value will be equal to #03/22/2013 09:17:00 AM#
DateTimePicker1.Value.Date will be equal to #03/22/2013#
DateTimePicker1.Text will be equal to "03/22/2013"

When you ONLY put a date into a database field that has a type of Date|DateTime|TimeStamp the field will replace a non-existant time with midnight

If you need a time then as you can see above, passing the value will place the current time into the field without changing the format of your datetimepicker.

So change the input into the database for the datetimepicker to .Value not .Value.Date
Was This Post Helpful? 0
  • +
  • -

#5 Adqusit   User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 176
  • Joined: 02-March 13

Re: Why dateTimepicker is not showing proper date and time in Database

Posted 22 March 2013 - 06:46 AM

Dear Charlie. I deleted the old DTP and add a new one on my form and then started insertion of data so you know i just change the format to short and did nothing to its value property and when i check the last inserted records, so its fulfilling my need i.e. the current date and current time of insertion is there in DataBase. I think the problem i am facing with my old DTP is that i modify the value property and removed the time from it on design mode, therefore it inserts the fix time i.e. "12:00". In this case if i bring the value property to its default value, on which it is, when it is added first time on form.

or in other case, as you mentioned.

I want this value back in value property #03/22/2013 09:17:00 AM#. I am totally baffle that what to do now, Charlie. I am sorry but i'm not understanding anything.. :dontgetit: :dontgetit:
Was This Post Helpful? 0
  • +
  • -

#6 CharlieMay   User is offline

  • This space intentionally left blank
  • member icon

Reputation: 1729
  • View blog
  • Posts: 5,708
  • Joined: 25-September 09

Re: Why dateTimepicker is not showing proper date and time in Database

Posted 22 March 2013 - 06:55 AM

If I remember correctly, you are inserting these from a DataTable that you create and populate with the entry. Then you loop through the datatable and insert the field into the database. Is that correct?

If that is correct, look at where you're inserting the date into the database and make sure that you are also inserting time.
Was This Post Helpful? 0
  • +
  • -

#7 Adqusit   User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 176
  • Joined: 02-March 13

Re: Why dateTimepicker is not showing proper date and time in Database

Posted 22 March 2013 - 10:55 AM

yes its correct. Yes time is available for all of the records. But with some records, the correct time is available and for some records the fix time i.e. 12:00 Am or PM.
Was This Post Helpful? 0
  • +
  • -

#8 Adqusit   User is offline

  • D.I.C Head

Reputation: 1
  • View blog
  • Posts: 176
  • Joined: 02-March 13

Re: Why dateTimepicker is not showing proper date and time in Database

Posted 25 March 2013 - 06:12 AM

Hi. I set the DateTimepicke property to:

dtpSales.ResetText
and its working validly. :)/>

But my question is that i've reset its text, then what concern this .ResetText has with value property of DateTimePicker. I want to clarify and enhanced my knowledge about. Please.

This post has been edited by Adqusit: 25 March 2013 - 06:14 AM

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1