<div>
Are you able to get all the records without LIMIT? &nbsp;<br />

<pre><code class="code-1 nolinks" id="code-233849"><span>SELECT     counties.County, states.UsStateAbbreviation, projects.ProjectId, projects.ProjectTitle</span>
<span>FROM         states INNER JOIN</span>
<span>                      counties ON states.StateId = counties.StateId INNER JOIN</span>
<span>                      projects ON counties.CountyId = projects.LocationCountyId</span>
<span>WHERE     (projects.IsVisible = 1) AND (projects.ReleaseDate &lt;= CURDATE()) AND (projects.IsPrivate = 0)</span>
<span>ORDER BY projects.BidDateTime DESC</span>
</code></pre>
</div>


<div>
LIMIT has to be after the ORDER BY CLAUSE
</div>


<div>
&gt;&gt; Putting the LIMIT after the WHERE and after the ORDER BY<br />
reb73 - yes, but i guess the asker tried that one also.<br />

</div>


<div>
My mistake! Apologies.. (Thanks, Sharath!)
</div>


<div>
Yes, I can get ALL records without the LIMIT.<br />

</div>


<div>
I tried...<br />
<br />
SELECT * FROM projects LIMIT 10<br />
<br />
In my TableAdapter Query Configuration Wizard (in my XSD dataset) I get this error....<br />
<br />
Error in FROM clause: near '10'. Unable to parse query text.<br />
<br />
I am using MySql with Corelabs MyDirect.Net MySql stuff...<br />
<br />
<br />

</div>


<div>
that means, your MySql does not support LIMIT. I don't know the reason. Can you give a try with TOP 10 like <br />
SELECT TOP 10.... <br />

</div>


<div>
Yeah I tried that too, but it didn't work. &nbsp;I've been googling and see that MySql works with LIMIT. &nbsp;In fact, when I use my MySql Admin tool I can use LIMIT. <br />

</div>


<div>
I am using the connector from DevArt called MyDirect.Net.<br />

</div>


<div>
<div class="content wysiwyg-content">
Using latest versions of both ASP.NET and MySQL. &nbsp;I want to create a query returning only the TOP 10 rows of data, but using LIMIT does not seem to work. &nbsp;(This is a query within an XSD dataset.)<br />
<br />
I've tried:<br />
LIMIT 10<br />
LIMIT 0,10<br />
Putting the LIMIT after the WHERE and after the ORDER BY<br />
<br />
The TableAdapter Query Configuration Wizard tells me: &nbsp;Error in SELECT clause: expression near '10'. Unable to parse query text.<br />
<br />
What am I missing?<br />

<pre><code class="code-1 nolinks" id="code-233839"><span>SELECT     counties.County, states.UsStateAbbreviation, projects.ProjectId, projects.ProjectTitle</span>
<span>FROM         states INNER JOIN</span>
<span>                      counties ON states.StateId = counties.StateId INNER JOIN</span>
<span>                      projects ON counties.CountyId = projects.LocationCountyId</span>
<span>LIMIT 10</span>
<span>WHERE     (projects.IsVisible = 1) AND (projects.ReleaseDate &lt;= CURDATE()) AND (projects.IsPrivate = 0)</span>
<span>ORDER BY projects.BidDateTime DESC</span>
</code></pre>
</div>
</div>


Using latest versions of both ASP.NET and MySQL.  I want to create a query returning only the TOP 10 rows of data, but using LIMIT does not seem to work.  (This is a query within an XSD dataset.)

I've tried:
LIMIT 10
LIMIT 0,10
Putting the LIMIT after the WHERE and after the ORDER BY

The TableAdapter Query Configuration Wizard tells me:  Error in SELECT clause: expression near '10'. Unable to parse query text.

What am I missing?

How LIMIT MySql Query to top 10 rows - Error in SELECT clause: expression near '10'. Unable to parse query text.

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.