Hey, im trying to get some information out of my database, which i have tableadapter and dataset. Both created with the VS2010. I have made 4 queries in the tableadapter taking different parameters, to make a WHERE clause in the sql sentence.
But it simply doesnt work and i dont know where... here is one with 1 parameter:
SELECT Medlemmer.Fornavn, Medlemmer.Efternavn, Medlemmer.Studienummer, Medlemmer.Email, Medlemmer.Studiested, Medlemmer.IDA, Medlemmer.PROSA,
Medlemmer.IndmeldelsesDato, Medlemmer.BetalingsBeløb, Medlemmer.BetalingsType, Retninger.retningNavn
FROM Medlemmer INNER JOIN
Retninger ON Medlemmer.retningID = Retninger.retningID
WHERE
Medlemmer.Studienummer=@Studienummer
But when i preview data with it, it doesnt show any at all. And i have checked that the data is present.
Please help me
Sincererly
Anders