I get a syntax error near dtTo. Not sure if dates are handled differently or if it is something else. The select statement is hitting the Case False. Code below...
Dim con As New SqlConnection
Dim cmd As New SqlCommand
Try
con.ConnectionString = sqlComm
con.Open()
cmd.Connection = con
Select Case ysnNew
Case False
cmd.CommandText = "Update tblLeads " & vbCrLf &
"SET strType = @strType," & vbCrLf &
"numClient = @numClient," & vbCrLf &
"strLast = @strLast," & vbCrLf &
"strFirst = @strFirst" & vbCrLf &
"dtTo = @dtTo, SqlDbTypes.DateTime" & vbCrLf &
"tmTo = @tmTo, sqldbtypes.Time" & vbCrLf &
"dtCTC = @dtCT, SqlDbTypes.DateTime" & vbCrLf &
"tmCTC = @tmCT, sqldbtypes.Time " & vbCrLf &
"strNotes = @strNotes" & vbCrLf &
"strResponse = @strResponse" & vbCrLf &
"strLeadType = @strLeadType" & vbCrLf &
"ysnBad = @ysnBad" & vbCrLf &
"ysnPhone = @ysnPhone" & vbCrLf &
"Where numLeadID = @numLeadID"
Case Else
cmd.CommandText = "Insert Into tblLeads " & vbCrLf &
"strType = @strType," & vbCrLf &
"numClient = @numClient," & vbCrLf &
"strLast = @strLast," & vbCrLf &
"strFirst = @strFirst" & vbCrLf &
"dtTo = @dtTo, SqlDbTypes.DateTime" & vbCrLf &
"tmTo = @tmTo, sqldbtypes.Time" & vbCrLf &
"dtCTC = @dtCT, SqlDbTypes.DateTime" & vbCrLf &
"tmCTC = @tmCT, sqldbtypes.Time " & vbCrLf &
"strNotes = @strNotes" & vbCrLf &
"strResponse = @strResponse" & vbCrLf &
"strLeadType = @strLeadType" & vbCrLf &
"ysnBad = @ysnBad" & vbCrLf &
"ysnPhone = @ysnPhone" & vbCrLf & ""
End Select
cmd.Parameters.AddWithValue("@strType", Me.txtType.Text)
cmd.Parameters.AddWithValue("@numClient", Me.txtClient.Text)
cmd.Parameters.AddWithValue("@strLast", Me.txtlast.Text)
cmd.Parameters.AddWithValue("@strFirst", Me.txtFirst.Text)
cmd.Parameters.AddWithValue("@dtTo", Me.dtTO.Text)
cmd.Parameters.AddWithValue("@tmTO", Me.tmTO.Text)
cmd.Parameters.AddWithValue("@dtCT", Me.dtCT.Text)
cmd.Parameters.AddWithValue("@tmCT", Me.dtCT.Text)
cmd.Parameters.AddWithValue("@strNotes", Me.txtNotes.Text)
cmd.Parameters.AddWithValue("@strResponse", Me.txtEmail.Text)
cmd.Parameters.AddWithValue("@strLeadType", Me.cboVehicle.Text)
cmd.Parameters.AddWithValue("@ysnBad", Me.chkBad.Text)
cmd.Parameters.AddWithValue("@ysnPhone", Me.ysnPhone.Text)
Select Case ysnNew
Case False
cmd.Parameters.AddWithValue("@numLeadID", Me.txtID.Text)
End Select
cmd.ExecuteNonQuery()
Catch ex As Exception
MessageBox.Show("Error while inserting record on table..." & ex.Message, "Insert Records")
Finally
con.Close()
End Try