<div>
is there a reason you don't want to just eliminate the where clause in the SQL Statement? 

</div>

<div>
I removed it. &nbsp;I manually setup the parameter but it's not filtering the results now.
</div>

<div>
I want to be able to filter by ID but I also want to be able to show all records as well.
</div>

<div>
I'd recommend creating a stored procedure and having your code call the stored procedure. &nbsp;Create the SP such that it accepts the ID as a parameter - and then include logic such that if the parameter is passed as NULL - it executes the SELECT without a WHERE clause - and when an actual value is passed to the parameter, the SP executes the SELECT with the WHERE using the parameter value. 
 
the SP would look something like (sorry - I don't have time ro run thru a syntax check at the moment) 

<pre><code class="code-10 nolinks" id="code-123436">CREATE PROCEDURE Issues_Read
 @MatchingID int
AS
 
BEGIN
 IF @MatchingID IS NULL
		SELECT 	ID, 
				DateEntered, 
				TimeEntered, 
				ReportedBy, 
				AssignedTo, 
				Problem, 
				Category, 
				SubCategory, 
				Solution, 
				Status, 
				ResolutionDate, 
				ResolutionTime 
	FROM 		Issues
 
 ELSE
		SELECT	ID, 
				DateEntered, 
				TimeEntered, 
				ReportedBy, 
				AssignedTo, 
				Problem, 
				Category, 
				SubCategory, 
				Solution, 
				Status, 
				ResolutionDate, 
				ResolutionTime
		FROM	Issues
		WHERE ID = @MatchingID
		
END
</code></pre>
</div>

<div>
I tryed right clicking Stored Procedures in Server Explorer to create a stored procudere but I don't have that option. &nbsp;Am I missing something?
</div>

<div>
I'm not using an SQL server im using OleDB. &nbsp;
</div>

<div>
<div class="content wysiwyg-content">
Select statement in oledbdataadapter is 
SELECT &nbsp; &nbsp; ID, DateEntered, TimeEntered, ReportedBy, AssignedTo, Problem, Category, SubCategory, Solution, Status, ResolutionDate, ResolutionTime 
FROM &nbsp; &nbsp; &nbsp; &nbsp; Issues 
WHERE &nbsp; &nbsp; (ID = ?) 
 
I've tried Me.daIssues.SelectCommand.Parameters(&quot;ID&quot;).Value = &quot;%&quot; 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. &nbsp;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?
</div>
</div>

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?

How to return all records in a query

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.