Trouble passing parameters

[PoisonousFish]

Okay, i'm working in VB.NET 2005. I am trying to configure one of my table adapter fill queries by passing it a parameter. My parameter is named par1 and is a AnsiString.

SELECT EMPID, First_Name, Last_Name, Salary, Dept_ID
FROM Employee
WHERE (Dept_ID = Department.Dept_ID) AND (Dept_Name = @par1)

It does not like this it seems. We struggled with this last night in my vb.net class. Apparantly some things have changed from 2003 to 2005. Anyone have a clue on how to get this thing to work? Thanks for your time.

 

[InertiaM]

I would start by looking at the query, not at the parameters. Where is your JOIN to the Department table?

If you have trouble with a query, always check the syntax of your query

 

[PoisonousFish]

Thanks for the suggestion, you were correct.