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?
