Query with paramters mysql and Windows Forms

Question

Hi I'm coding a windows application which use mysql db. It's similar to a helpdesk system (electronic service request we call it). When the user has fill all field the request is insert in db. I have a button so the user can see his history (active request). To do so I use the wizard and create a query (in designer) to accept a parameter (the user name). When I run my application the datagridview was empty because the query doesn't work in C# (VS 2008). I try the query in MySQL Query Browser and it work if the parameter is with quote   . Is there a way to make my query work in C# with the designer or how do I have to pass the parameter so the query work ? Thank you.

Pascal Hudon · Answer

Yes. The variable contain what it suppose to (for example : it contain my username Pascal). So what I want is to list the resquest I made that are active (not close) only for me.

Sam Hobbs · Answer

Have you verified that Globale.Nomreq does actually have the data that you are assuming it does?

Pascal Hudon · Answer

Select `dds.date`dds.batimentdds.piecedds.descriptiondds.actifservice.nom FROM dds INNER JOIN service ON dds.serviceID = service.serviceID WHERE (dds.actif = 1) AND (dds.Nom_utilisateur = @NUtilisateur) ORDER `dds.date` DESC I make the call with this: ddsTableAdapter.FillHist(ddseDataset.dds Globale.Nomreq); Which Globale is a globale variable that I use in another form. it's a string variable (nomreq is string).

Hirendra Sisodiya · Answer

can i see your query...... thanks

Query with paramters, mysql and Windows Forms