No Value given for one or more parameters

[Matrix.net]

Hi , I'm having a problem with my dataset for some reason . I've check my sql query and it looks 100% correct. the part where I get this error comes down to the adaptor.fill line . Here is the actual code : (sql is the query and con is the connection , the part in bold is where the error occurs)


adapt.SelectCommand = New OleDbCommand(sql, con)
Line 383: adapt.Fill(dSet, dSet.DataSetName)

[pclement]

You may want to post your SQL statement so that we can take a look.

[Matrix.net]

You may want to post your SQL statement so that we can take a look.

Heres the query string : query = "SELECT DISTINCT CaseNumber,PartyNameFull,Ty,Filing,CAT,CSID FROM Civilpartynames3 WHERE CaseNumber = " & CaseNumberTextBox.Text


Heres my function that creates the connection and executes the query string

Public Function getData(ByVal query As String) As DataSet
Dim PathInfo As String
PathInfo = "Provider=Microsoft.Jet.OLEDB.4.0;"
PathInfo += "Data Source=C:\Inetpub\wwwroot\CivilComplaintCases\bin\CivilCourt.mdb"
Dim con As OleDbConnection = New OleDbConnection(PathInfo)

Dim adapt As New OleDbDataAdapter
Dim sql As String = query
Dim data As New DataSet

con.Open()

adapt.SelectCommand = New OleDbCommand(sql, con)
adapt.Fill(data,data.datasetname)
con.Close()
Return data

End Function

[Matrix.net]

Nevermind, I think I found my problem which was I didnt have the single quotes around the casenumbertextbox.text but I'm still having the same problem when I execute this string :


query = "SELECT DISTINCT CaseNumber,PartyNameFull,Ty,Filing,CAT,CSID FROM Civilpartynames3 WHERE CivilPartyNames3.CaseNumber = CivilattyNames.CaseNumber AND Civilattynames.AttyNM = " & "'" & attorneyNameDropDown.SelectedItem.ToString & "'"

[Matrix.net]

I think the problem has to do with using two tables, I must be querying it incorrectly somehow.

[pclement]

It looks like you're missing CivilattyNames in the FROM clause.

"FROM Civilpartynames3, CivilattyNames WHERE..."

[RijeshThomas]

CivilattyNames table is not refered. Execute the same query before putting in .NET file