string SQL = "SELECT * FROM [Art] WHERE ID_Categoria=" + cate + " AND Descrizione LIKE '" + descri + "'";

SELECT * FROM [Art] WHERE ID_Categoria=46 AND Descrizione LIKE 'elevatori'

Server Error in '/ppp/areariservata' Application.
--------------------------------------------------------------------------------

Istruzione SQL non valida. Prevista 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT' o 'UPDATE'. 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.OleDb.OleDbException: Istruzione SQL non valida. Prevista 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT' o 'UPDATE'.

Source Error: 


Line 129:      OleDbDataAdapter DA = new OleDbDataAdapter(comm);
Line 130:      DataTable MyTable = new DataTable();
Line 131:      DA.Fill(MyTable);
Line 132:      conn.Close(); 
Line 133:      return MyTable;
 

Source File: c:\inetpub\wwwroot\ppp\areariservata\Access.cs    Line: 131 

public void CollegaGriglia()
    {
      string cate = Request.QueryString["cat"];
      string descri = Request.QueryString["des"];
      string SQL = "SELECT * FROM [Art] WHERE ID_Categoria=" + cate + " AND Descrizione LIKE '" + descri + "'";
      // Collego i dati al datagrid che si chiama datastati
      DataStati.DataSource = Access.visRecord4(SQL);
      DataStati.DataBind();
    }

//    GLI PASSO LA STRINGA SQL E FUNZIONA PER UNA SELECT
    public static DataTable visRecord4 (string SQL)
    {
      //creo l'oggetto connection e gli passo la stringa di connessione
      OleDbConnection conn = new OleDbConnection(connString);
      //faccio l'Open della connessione
      conn.Open();
      OleDbCommand comm = new OleDbCommand("SQL" ,conn);
      OleDbDataAdapter DA = new OleDbDataAdapter(comm);
      DataTable MyTable = new DataTable();
      DA.Fill(MyTable);
      conn.Close(); 
      return MyTable;
    }