How to concatenate date and time from two different datetimepicker

Question

eileenc87 0 Light Poster

13 Years Ago

Hi ,

i'm new to vb.net.

i wish to concatenate date and time from 2 different datetimepicker
after concatenated I want it to be save in sql database format which is yyyy-MM-dd HH:mm:ss

I'm doing half way and my query is like below.

Dim insertCmd As New SqlCommand(Sqlstr, connection)
insertCmd.Parameters.Add("@School_Subject", Data.SqlDbType.NVarChar).Value = txtSchoolSubject.Text
insertCmd.Parameters.Add("#" & SchoolDatePicker.Value & "#") ', Data.SqlDbType.NVarChar).Value = SchoolDatePicker.Text
insertCmd.Parameters.Add(" @DT_PlannedStartDt " + " " + "@DT_PlannedStartHour" + " " + "@DT_PlannedStartMin" + " " + "@DT_PlannedStartSec") ', Data.SqlDbType.NVarChar).Value = DT_PlannedStartYear.Text
insertCmd.Parameters.Add(" @DT_PlannedEndDt" + " " + "@DT_PlannedEndHour" + " " + "@DT_PlannedEndMin" + " " + "@DT_PlannedEndSec") ', Data.SqlDbType.NVarChar).Value = DT_PlannedStartYear.Text

vb.net

2 Contributors
3 Replies
227 Views
8 Hours Discussion Span
Latest Post 13 Years Ago Latest Post by Saikalyankumar

Reply to this topic

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.

Saikalyankumar -2 Junior Poster in Training · Answer 1 · 2011-03-22T10:29:47+00:00

Concatenate in the Sense to add two Date Times into a single one?

eileenc87 0 Light Poster · Answer 2 · 2011-03-22T10:52:29+00:00

yaya.....
because i'm taking from two different datetimepicker and i want to combined it as one so i can save it into sql database format.

u may refer to the attachment to see how my form looks like

Saikalyankumar -2 Junior Poster in Training · Answer 3 · 2011-03-22T12:18:10+00:00

U refer to this Urlhttp://www.techrepublic.com/article/adding-and-subtracting-datetime-values-in-vbnet/6175682, U can get some idea about adding the DateTimes.