Loading

The correct use of a variable in a SQL QUERY

Administrator

I would like to know as to use a variable in a SQL QUERY. I have a variable called NOMEGENERO that contains the name "JOSE" for example. what is the correct SQL QUERY using this variable. I'm trying to use: thisAdapter = new OleDbDataAdapter( "SELECT n_genero FROM genero WHERE genero = '+ nomegenero'", dbBanco.thisConnection);). But is wrong. How can i use the variable NOMEGENERO correctly? Debtor for the attention Andre

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Administrator23y ago
Of course it's wrong. It reads on the SQL exactly this: SELECT n_genero FROM genero WHERE genero = '+ nomegenero', i.e it's looking for the string + nomegenero in the genero field. I would suggest you to create command string outside the creation of DataAdapter, so you can debug it and see what you are really send to the database: string sCommand = "Select...."; //Write you command there. thisAdapter = new OLEDbDataAdapter(sCommand, dbBanco.thisConnection); Hope this will help you Mike
+1