Visual Basic 2005 - tableadapter queries - parameter

I am using VS 2005, Oracle 10g, and have a question on passing a parameter to the query defined in a DataSet.

The query is “ SELECT USERID, PASSWORD, LAST_NAME, FIRST_NAME, ROLE, STATUS FROM testdb.SECURITY
where USERID = :parmUSERID”

This query runs fine in the wizard - but when I build my app I get the following error:

Error 33 Overload resolution failed because no accessible 'New' accepts this number of arguments. on this generated statement.

Me._commandCollection(1).Parameters.Add(New System.Data.OracleClient.OracleParameter("parmUSERID", System.Data.OracleClient.OracleType.VarChar, 8, System.Data.ParameterDirection.Input,"USERID", System.Data.DataRowVersion.Current,false,Nothing))

Why? What am I doing wrong?

[1152 byte] By [JoB] at [2007-12-26]

.NET Development

Site Classified