Questo linguaggio è la capacità di rendere complessa la costruzione di query. La colpa ricade anche su di me pero'.
codice:
String sqlquery = "SELECT ord.*,prod.* FROM ordini AS ord WHERE [iduser]=";
sqlquery += iduser+" INNER JOIN prodotti AS prod ON [prod.idprodotto]=[ord.idprodotto]";
e ritorna:

System.Data.OleDb.OleDbException: Errore di sintassi (operatore mancante) nell'espressione della query '[iduser]=8 INNER JOIN prodotti AS prod ON [prod.idprodotto]=[ord.idprodotto]'. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteReader(Comma ndBehavior behavior) at System.Data.OleDb.OleDbCommand.ExecuteReader() at ASP.carrello_aspx.__Render__control1(HtmlTextWrite r __output, Control parameterContainer) in d:\inetpub\wwwroot\Carrello\carrello.aspx:line 38