<div>
The SQL statement was fine, the error was caused by assigning incorrect string value to the actual query/dataset.
</div>


<div>
<div class="content wysiwyg-content">
Hello, I have a SQL statement that works in a VB-6 DAO based application on an access database, trying to get it to work with ado.net in VS-2010 on the same database. &nbsp;Database opens and simple Select SQL queries work but this one fails;<br />
<br />
SELECT Month([Articles]![DateTime<wbr />Recovered]<wbr />)) AS [Month Name], Count(Articles.ID) AS [Count Of Items Recieved]<br />
FROM Articles WHERE (((Articles.DateTimeRecove<wbr />red)&gt;#9/30<wbr />/2012 23:59:0# And (Articles.DateTimeRecovere<wbr />d)&lt;#1/1/20<wbr />13#))<br />
GROUP BY Month([Articles]![DateTime<wbr />Recovered]<wbr />));<br />
<br />
Does anyone know how to convert this to an ADO.net compliant SQL statement?
</div>
</div>


Hello, I have a SQL statement that works in a VB-6 DAO based application on an access database, trying to get it to work with ado.net in VS-2010 on the same database.  Database opens and simple Select SQL queries work but this one fails;

SELECT Month([Articles]![DateTimeRecovered])) AS [Month Name], Count(Articles.ID) AS [Count Of Items Recieved]
FROM Articles WHERE (((Articles.DateTimeRecovered)>#9/30/2012 23:59:0# And (Articles.DateTimeRecovered)<#1/1/2013#))
GROUP BY Month([Articles]![DateTimeRecovered]));

Does anyone know how to convert this to an ADO.net compliant SQL statement?

The SQL statement was fine, the error was caused by assigning incorrect string value to the actual query/dataset.

SQL Statement

Hello, I have a SQL statement that works in a VB-6 DAO based application on an access database, trying to get it to work with ado.net in VS-2010 on the same database.  Database opens and simple Select SQL queries work but this one fails;

SELECT Month([Articles]![DateTimeRecovered])) AS [Month Name], Count(Articles.ID) AS [Count Of Items Recieved]
FROM Articles WHERE (((Articles.DateTimeRecovered)&gt;#9/30/2012 23:59:0# And (Articles.DateTimeRecovered)&lt;#1/1/2013#))
GROUP BY Month([Articles]![DateTimeRecovered]));

Does anyone know how to convert this to an ADO.net compliant SQL statement?

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.

.NET Programming

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.