Query with paramters, mysql and Windows Forms

Pascal Hudon

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.

4 Replies

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

Pascal Hudon16y ago
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 Hobbs16y ago
Have you verified that Globale.Nomreq does actually have the data that you are assuming it does?
Pascal Hudon16y ago
Select `dds.date`,dds.batiment,dds.piece,dds.description,dds.actif,service.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 Sisodiya16y ago
can i see your query......
thanks