No overload for method 'Add' takes '3' arguments RSS

• • Reply
  

  dba123

  Contributor

  2726 Points

  1364 Posts

  No overload for method 'Add' takes '3' arguments

  Jul 25, 2006 06:01 PM|LINK

  <div id=intelliTxt style="PADDING-RIGHT: 5px; PADDING-LEFT: 5px">For some reason, I don't know if maybe I'm just not using the right method for the adding of parameters, but I get this error during the build:
  
  No overload for method 'Add' takes '3' arguments            
  
  Should I be using Add here?  I did see using dbCommandWrapper.AddInParameter here but I do'nt think that's a valid method in Enterprise Library 2.0: http://aspalliance.com/688
  
  Part of my code:
  
  
  ....some code before
  Database db = DatabaseFactory.CreateDatabase();
  
               DbCommand dbCommandWrapper = db.GetStoredProcCommand("MyStoredProcHere");
  
              //Stored procedure input parameters
              dbCommandWrapper.Parameters.Add("@SearchTerm", DbType.String, SearchTerm);
              dbCommandWrapper.Parameters.Add("@CreateDate", DbType.DateTime, DateTime.Now);
              dbCommandWrapper.Parameters.Add("@ResultCount", DbType.DateTime, 1);
  
              // Execute Stored Procedure to insert Search Term into table
              db.ExecuteNonQuery(dbCommandWrapper);
  ....rest of code</div>
  When is Microsoft going to get rid of VB.NET!
• • Reply
  

  AmNoGeek

  Member

  411 Points

  96 Posts

  Re: No overload for method 'Add' takes '3' arguments

  Jul 26, 2006 03:27 PM|LINK

  I have used AddInParameter with Enterprise Lib2.0 and it works prefectly fine. I think you should give it a try.