data type mismatch in criteria expression

[coreyjustin]

I am coding a website and have run into a problem I can't seem to figure out.

I keep getting the above error when I am trying to use this code.

    Protected Sub UpdateData_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles UpdateData.Click
 
            Dim dbCommand As System.Data.IDbCommand = New System.Data.OleDb.OleDbCommand
            Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(connectionString)
            Dim strInsert As String = "INSERT INTO Data(MajorProblem, Cat_Street_Number, Cat_Score, StartAddr, EndAddr, CatId, SubId, Sid, NeighborhoodID)VALUES("
            Dim majorProblem As Integer = 0
            dbCommand.Connection = dbConnection
            dbCommand.Connection.Open()
            If RubbishMajor.Checked Then
               majorProblem = 1
           Else
               majorProblem = 0
           End If
           If OverFilledBins.Checked Then
               Dim sub1 As String = 1
               strInsert = strInsert & "'" & majorProblem & "', '" & OverFilledAddr.Text & "', '" & Rubbishscore.Text & "', '" & StartAddr.Text & "', '" & EndAddr.Text & "', "
 
               strInsert = strInsert & "'SELECT SubCat.CatId FROM SubCat WHERE  SubId = 1', 'sub1', "
               strInsert = strInsert & "'SELECT Street_Lookup.Sid FROM Street_Lookup WHERE " & ddlStreetName.SelectedValue & " = St_name', "
               strInsert = strInsert & "'SELECT Neighborhood.NeighborhoodID FROM Neighborhood WHERE " & ddlNeighborhood.SelectedValue & " = NeighborhoodDesc'"
           End If
 
           strInsert = strInsert + ")"
           dbCommand.CommandText = strInsert
           dbCommand.ExecuteNonQuery()
           dbCommand.Connection.Close()
       End Sub

If someone could please tell me what Im doing wrong that would be amazing.

[Nicodemas]

Could you reformat that and post the line number the error occurs on?

[coreyjustin]

25 dbCommand.ExecuteNonQuery()

that is the line the error occurs on, but I believe that itt occurs with where i concatenate my first select statement

[jhardman]

If you were to print out strInsert, what would it say?

Jared