我的form中有个DateTimePicker1
我要把DateTimePicker1的输入保存到SQl数据库中去要怎么弄
SQL语句我是知道的，我想知道怎么得到那上面的输入值

DateTimePicker1.SelectText   或者 DateTimePicker1.Text

我写好了SQL语句，在执行时报“从字符串转为Datatime时发生语法错误”

两边不要加单引号

不是那个问题了，出新问题了
'年12月11日附近有语法错误。'
我的SQL语句： strsql = "update Employees set ELName='" & TextYGXS.Text & "',EFName='" & TextYGXM.Text & "',Address='" & TextDZ.Text & "',City='" & TextSZCS.Text & "',State='" & TextSZSF.Text & "',Zip='" & TextYB.Text & "',Phone='" & TextDH.Text & "',Dob=" & DateTimePicker2.Text & ",Doj=" & DateTimePicker1.Text & ",Designation='" & ComboZW.Text & "',DeptID='" & ComboSSBM.Text & "',Password='" & TEXTMM.Text & "' where EmpID='" & ComboYGID.Text & "'"
麻烦了

设置一个断点就知道是哪里的错了.

strsql = "update Employees set ELName='" & TextYGXS.Text & "',EFName='" & TextYGXM.Text & "',Address='" & TextDZ.Text & "',City='" & TextSZCS.Text & "',State='" & TextSZSF.Text & "',Zip='" & TextYB.Text & "',Phone='" & TextDH.Text & "',Dob=" & DateTimePicker2.Text & ",Doj=" & DateTimePicker1.Text & ",Designation='" & ComboZW.Text & "',DeptID='" & ComboSSBM.Text & "',Password='" & TEXTMM.Text & "' where EmpID='" & ComboYGID.Text & "'"

Public Function updatedatabase(ByVal SQLcmd As String)
Try
Dim conn As SqlConnection
Dim cmd As SqlCommand
conn = New SqlConnection(Connstr)
conn.Open()
cmd = New SqlCommand(SQLcmd, conn)
cmd.ExecuteNonQuery()在这个地方就跳到下面去了
conn.Close()

Catch ex As Exception
MsgBox(ex.Message)

DateTimePicker1.value.date

Dim cmd As New SqlCommand("select count(*) from c_invoice where inumber='" & TextBox1.Text & "'", conStr)

Dim cmd1 As New SqlCommand("update c_invoice set department='" & ComboBox1.Text & "',slid='" & ComboBox2.Text & "',idate='" & dt1.Text & "',mdid='" & ComboBox3.Text & "',iquantity='" & TextBox6.Text & "',money='" & TextBox9.Text & "',uid='" & ComboBox5.Text & "',colorid='" & ComboBox6.Text & "',Payment='" & ComboBox7.Text & "',smid='" & ComboBox8.Text & "',remarks='" & TextBox11.Text & "' where inumber='" & TextBox1.Text & "'", conStr)