I have the following code segment:
Public Function getprodcatgrylist() As DataSet
Try
sqlStr = "Select Distinct Category from tblProducts"
DA = New OleDb.OleDbDataAdapter(sqlStr, connect())
DA.Fill(dset, "dtproductcategory")
DA.Dispose()
getprodcatgrylist = dset
Catch ex As Exception
Throw ex
finally
if connect.state = connectionstate.open then
connect.close()
end if
End Try
End Function
pretty simple and straight forward.
The thing is when ran from the app this returns 2 more records than it should and the data is still wrong...when the query is ran in access...its as good as it can get...whats the deal...MS Access sucks...never had this prob. with MSSQL...