Avatar of tbeck1983
Flag for United States of America

asked on 

How to return all records in a query

Select statement in oledbdataadapter is
SELECT     ID, DateEntered, TimeEntered, ReportedBy, AssignedTo, Problem, Category, SubCategory, Solution, Status, ResolutionDate, ResolutionTime
FROM         Issues
WHERE     (ID = ?)

I've tried Me.daIssues.SelectCommand.Parameters("ID").Value = "%" to load all records but I get the following error Failed to convert parameter value from a String to a Int32.

If I change the parameter from a int32 to a string it works but then I cannot generate the dataset.  I get the following error.

Retrieving the schema for daIssues failed.
OleDbCommand.Prepare method requires all variable length parameters to have an explicitly set non-zero Size.

Any ideas?
.NET Programming

Avatar of undefined
Last Comment

8/22/2022 - Mon