The correct use of a variable in a SQL QUERY

Question

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

Administrator · Answer

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