Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2012
    Posts
    32

    Unanswered: Stored Procedures with parameters

    dbCommPayroll.Parameters.Add("@PayrollDate", SqlDbType.DateTime).Value = Me.dtpWeek.Value

    this is the line of code that is giving me issues. I have several stored procedures throughout my application that are set up the same way. I believe the issue somehow deals with the date time.

    In a try catch block I get the following error message:

    "Failed to convert parameter value from a String to a Int32"

    Any help would be appreciated.

  2. #2
    Join Date
    Aug 2012
    Posts
    32
    Oh, and the value being passed is not empty, I set up a messagebox to verify that

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •