Hello, I have one DateTimePicker and two textbox (txtHour and txtMinute)
I want insert the value of datetimepicker (date) and textbox (hour and minute from two different textbox) to DateTime data type on my table, example: 2013-08-28 12:30:00 PM --> the value of 12 got from txtHour, the value of 30 got from txtMinute
How to do that?
Thanks

Recommended Answers

All 5 Replies

you can try like this, if i wrong please inform me

Dim dr As DataRow = DBDataSet.Tables("Table").NewRow
                    cmdIn1 = conn.CreateCommand
                    cmdIn1.CommandText = "INSERT INTO Table(Name, Sex, DateTime)VALUES('" & Trim(Name.Text) & "','" & Trim(Sex.Text) & "','" & Trim(DateTimePicker.Value) & "')"
                    check = cmdIn1.ExecuteReader.RecordsAffected()
                    If check > 0 Then
                        MsgBox("Data " & Trim(Name.Text) & " save successfull", MsgBoxStyle.OkOnly, "Message :")
                        DBDataSet.AcceptChanges()

please vote me if i already fix your problem, or ask me if you got problem.
Thank You!!

not like that,
this is my code :

Dim wm As String = txtJamM.Text + txtMenitM.Text + "00"
Dim ws As String = txtJamS.Text + txtMenitS.Text + "00"
Dim tampWM As String = dtpWM.Value.ToString("yyyyMMdd") + wm
Dim tampWS As String = dtpWS.Value.ToString("yyyyMMdd") + ws
Dim dtWM = DateTime.ParseExact(tampWM, "yyyyMMddHHmmss", Nothing)
Dim dtWS = DateTime.ParseExact(tampWS, "yyyyMMddHHmmss", Nothing)
MsgBox(dtWM + " & " + dtWS)
sql = "update detailjadwal set waktumulai='" + dtWM + "',waktuakhir='" + dtWS + "' where kodedetail='" + lbKodeDetail.Text + "'"

but that code generate 0000-00-00 00:00:00 in my database table on DateTime column

Nice job Iwin....for easy code, you can only insert the datetimepicker.value and it will save your date and time for column type = datetime.

I already know that, but datetimepicker.value generates timestamp (time from PC), not the time from user input in textbox.
I've solved my problem,
Here is the right code:

Dim wm As String = txtJamM.Text + txtMenitM.Text + "00"
Dim ws As String = txtJamS.Text + txtMenitS.Text + "00"
Dim tampWM As String = dtpWM.Value.ToString("yyyyMMdd") + wm
Dim tampWS As String = dtpWS.Value.ToString("yyyyMMdd") + ws
Dim thn As String = tampWM.ToCharArray(0, 4)
Dim bln As String = tampWM.ToCharArray(4, 2)
Dim hari As String = tampWM.ToCharArray(6, 2)
Dim jam As String = tampWM.ToCharArray(8, 2)
Dim mnt As String = tampWM.ToCharArray(10, 2)
Dim dtk As String = tampWM.ToCharArray(12, 2)
Dim tanggal As String = thn + "-" + bln + "-" + hari + " " + jam + ":" + mnt + ":" + dtk

sql = "update detailjadwal set waktumulai='" + tanggal + "' where kodedetail='" + lbKodeDetail.Text + "'"

:D anyway, thanks for your response

oh! ok....i understand now, hour and minutes textbox is manually insert by user right? nvm, dont forget to mark as solve your question....Thank You!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.