C# & Access 2003 - TableAdapter query with parameter

[adrianjohnson]

Hi all,

I'm trying to add a query to an existing TableAdapter using VS 2005 and Access 2003. I add the query ok, including the parameter field, add the name, but when I save the DataSet it changes the (@ to underscore. This means I cannot access the new query.

My Query:
SELECT * FROM Contacts WHERE FirstName = @ContactFirstName
(the query does return results when run in Visual Studio)

Query is saved as FillByFirstName(@ContactFirstName)
(this gets changed to FillByFirstName__ContactFirstName_

I've installed SP1 for Visual Studio, but it doesn't tell me it's installed in the About box, or Add/Remove questions.

Hope I've explained everything ok. Any ideas?

Thanks,

Adrian

Adrian Johnson

http://www.amanian.co.uk

http://www.adrian-johnson.com

 

[adrianjohnson]

It's ok, I've sorted it now.

Used a rowfilter on the DataGrid.

Adrian Johnson

http://www.amanian.co.uk

http://www.adrian-johnson.com